Screen CVs by role and invite the right candidates

The scenario evaluates each CV against the right role, invites strong candidates to interview and politely rejects the rest, tracking everything in a sheet.

  • CVs scored against the specific role
  • Good fits invited, the rest declined
  • Interview times logged automatically
  • Not a single CV read by hand
Connect Calendly and runScriptera

How it works

To move data from Google Sheets to Databricks automatically, use a ready-made scenario — no manual exports.

  1. Starts when: New Application Received
  2. Then: Extract CV File ID
  3. Then: Is Email Unique?
  4. Then: Add Email to Table
  5. Check: Route by Job Role
  6. If yes: Job Profile
  7. Then: Normalize Data
  8. Then: Download CV from Drive
  9. Then: Extract CV Text
  10. Then: Evaluate Candidate
  11. Then: Update in Sheet
  12. If no: Job Profile1
  13. If no: Job Profile2
  14. If no: Job Profile3
  15. Then: OpenRouter Chat Model
  16. Then: Structured Output Parser
  17. Starts when: Google Sheets Trigger
  18. Check: If
  19. If yes: Switch
  20. If yes: Invitation Message
  21. Then: Send Interview Invite
  22. Then: Mark Invite Sent
  23. If no: Rejection Message
  24. Then: Send Rejection Email
  25. Then: Mark Invite Sent1
  26. Starts when: Interview Event Received
  27. Check: Route by Event Type
  28. If yes: Extract Booking Details
  29. Then: Format Interview Time
  30. Then: Log Interview Time
  31. If no: Skip if Rescheduled
  32. If yes: Mark as Canceled
  33. Then: Log Cancellation

You can launch this Google Sheets + Databricks integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios