A list of local businesses with contacts

You set queries and cities in a spreadsheet, and the scenario finds businesses on maps and collects their emails — as rows back in the spreadsheet.

  • Searches businesses by query and city
  • Visits sites and pulls out emails
  • Puts contacts into a spreadsheet
  • Marks what's done to avoid repeats
Google Sheets
Connect Notion and launchScriptera

How it works

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

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Extract Search Terms
  3. Check: Keep Unprocessed Rows
  4. Then: Filter to first row
  5. Then: Mark Row as Completed
  6. Then: Search Google Maps
  7. Then: Format output as table
  8. Check: Loop Over Items
  9. Then: Save Emails to Sheet
  10. Then: Reduce to 1 row
  11. Then: Execute Workflow
  12. Then: Scrape Web Page
  13. Then: Extract Email - AI Agent
  14. Then: OpenAI Chat Model
  15. Then: Structured Output Parser

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

Similar scenarios