Email Automation
Monitor Google Maps listing changes with Apify, OpenAI, Sheets, Slack, and Gmail
On a schedule, it handles email with OpenAI / ChatGPT using Gmail, Google Sheets, Slack, Apify.
What it does
## Google Maps listing change monitor Checks a list of Google Maps places (or a search) on a schedule and turns the changes the actor reports into scored alerts: a business that closed or disappeared, a rating drop, a review spike or removal, new opening hours, or a changed phone or website. ### How it works 1. A schedule or manual run reads everything from Config. 2. The Apify actor runs asynchronously; the flow waits and polls until it ends. 3. Results are validated and deduped against earlier runs. 4. A rule score plus an AI chain (structured output) rate each record. 5. Rows are saved to Google Sheets; hot ones go to Slack for approve or dismiss, warm ones to an email digest. 6. A weekly report and an error alert branch run separately. ### Setup 1. Create an HTTP Header Auth credential (Authorization: Bearer ) and pick it on the Apify nodes. 2. Add a Google Sheet tab matching the sheet columns and paste its ID into Config. 3. Connect OpenAI (or any chat model), Slack and Gmail; set the Slack channel and digest email in Config. 4. Fill the actor input and the scoring keywords in Config, run once manually, then activate. ### Customization tips - Change the rule weights in the scoring Code node and the aiCriteria text. - Swap Slack or Gmail for Teams, Discord, HubSpot or Airtable; delivery nodes only read $json. Disclosure: I maintain these Apify actors (account transparent_meteorite). The actor is a paid pay-per-event Apify tool; check its Store page for current pricing before scheduling.
The steps
- Daily schedule
- Run manually
- Weekly report schedule
- Config
- Daily run or weekly report?
- Start Apify run
- Wait before polling
- Get run status
- Check run status
- Route by run status
- Stop: Apify run failed
- Fetch dataset items
- Validate and dedupe
- Any new records?
35 steps in total.
Similar automations
MCP Servers & ToolsCreate eBay Listing Drafts with an MCP Server2 stepsEmail AutomationSpot newly opened local businesses on Google Maps with Apify, OpenAI and Slack35 stepsLead Generation & EnrichmentScrape Google Maps Businesses and Contacts with Apify and Firecrawl14 stepsWeb Scraping & ResearchScrape Google Maps Places with Apify into Google Sheets5 steps