Local lead discovery with an automated three-email sequence

The scenario walks through areas and niches, finds businesses, pulls their emails off their sites, writes a personal first letter and sends two timed follow-ups by itself.

  • Your own lead list instead of a purchased one
  • The first letter is written per company
  • Follow-ups go out by date, not by memory
  • Service failures are retried, not dropped
Google SheetsGoogle
Set it upScriptera

How it works

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

  1. Starts when: Trigger: Generate AI Emails
  2. Then: Get row(s) in sheet
  3. Check: Check: Intro Mail Empty
  4. If yes: Loop: Generate AI Emails
  5. Then: Email Writer
  6. Then: Update row in sheet
  7. Then: Stop and Error1
  8. Then: Update Status to Success
  9. Check: Loop Subcats
  10. Then: Set Zip1
  11. Then: GMaps API
  12. Check: Check: GMaps Result Empty
  13. If no: Split Places Array
  14. Then: Scrape URL
  15. Then: Extract Emails From Website
  16. Check: Check: Email Found
  17. If yes: Add rows in Google Sheets
  18. Then: Get Status
  19. Then: Calc Retry Delay (Get Status)
  20. Then: Wait: Backoff Before Retry (Get Status)
  21. Check: Check: Retry Limit (Get Status)
  22. If yes: Stop and Error2
  23. Then: Calc Retry Delay (Add Rows)
  24. Then: Wait: Backoff Before Retry (Add Rows)
  25. Check: Check: Retry Limit (Add Rows)
  26. Then: Calc Retry Delay (Update Status)
  27. Then: Wait: Backoff Before Retry (Update Status)
  28. Check: Check: Retry Limit (Sheet Update)
  29. If yes: Stop and Error
  30. Then: Get row(s) in sheet1
  31. Check: Check: Intro Ready & Not Sent
  32. If yes: Loop: Send Intro Emails
  33. Then: Send Intro Mail
  34. Then: Generate Follow Up Dates
  35. Then: Update Row with all Follow Up Mail Dates
  36. Then: Get row(s) in sheet4
  37. Check: Check: Follow Up 1 Due
  38. If yes: Loop: Send Follow Up 1
  39. Then: Check Follow Up 1 Date
  40. Then: Follow Up Mail 1
  41. Then: Update row with follow up status 1
  42. Then: Get row(s) in sheet5
  43. Check: Check: Follow Up 2 Due
  44. If yes: Loop: Send Follow Up 2
  45. Then: Check Follow Up 2 Date
  46. Then: Follow Up Mail 2
  47. Then: Update row in sheet3
  48. Then: Settings
  49. Then: Get Zip Codes
  50. Then: Zips
  51. Check: Filter Zips
  52. Then: Split Out
  53. Then: Limit: Zips Per Run
  54. Then: Map Zip Field
  55. Check: Merge Zips & Categories
  56. Then: Build Zip × Category Matrix
  57. Then: Set Zip
  58. Then: Get Category
  59. Starts when: Trigger: Send Intro Emails
  60. Starts when: Trigger: Send Follow Up 1
  61. Starts when: Trigger: Send Follow Up 2
  62. Starts when: Trigger: Lead Scraping (GMaps)

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

Similar scenarios