Screening leads by criteria — with a reply to each

The scenario takes a request with a bill into Databricks, saves it to Google Sheets, checks it against your criteria and sends an acceptance or rejection to Gmail.

  • A request with a bill in Databricks
  • Lead data in Google Sheets
  • Checking against your criteria
  • An acceptance or rejection to Gmail
Webhook
Set it up for yourselfScriptera

How it works

To pass leads from Databricks to Google Sheets automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Webhook
  2. Then: [STEP 2] Upload Utility Bill
  3. Then: [STEP 3] Make Bill Viewable
  4. Then: [STEP 4] Create Bill Link
  5. Then: [STEP 5] Save Lead to Spreadsheet
  6. Then: [STEP 7] Check Qualification Criteria
  7. Then: [STEP 8] Update Qualification Status
  8. Check: Check Qualification Status
  9. If yes: [STEP 10A] Send Acceptance Email
  10. Then: Append row in sheet
  11. If no: [STEP 10B] Send Rejection Email
  12. Then: [STEP 5] Save Lead to Spreadsheet1
  13. Starts when: Webhook1

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

Similar scenarios