Bibliothek / E-Mail-Automatisierung
E-Mail-Automatisierung
Spot newly opened local businesses on Google Maps with Apify, OpenAI and Slack
On a schedule, it handles email with OpenAI / ChatGPT using Gmail, Google Sheets, Slack, Apify.
Was sie bewirkt
## Spot newly opened local businesses on Google Maps with Apify, OpenAI and Slack approvals Finds businesses that look newly opened on Google Maps (few reviews and photos, no hours or website yet, a recent first review), then scores each on the actor's newness score plus how easy it is to reach and pitch. Built for agencies, suppliers, banks and local-service sellers who want to reach a business before competitors do. ### How it works 1. A daily schedule (or the manual trigger) loads Config; a Monday schedule sends a 7-day report instead. 2. Runs the Apify actor google-maps-new-business-radar and downloads the results. 3. Drops incomplete rows and anything already seen in the last 30 days. 4. Score new businesses gives a 0-100 rule score; an OpenAI model adds a fit score, verdict and summary. 5. Upserts every row to the New businesses sheet tab. Hot rows go to Slack for approval, warm rows to an email digest. ### Setup steps - [ ] Add an Apify HTTP Header Auth credential (Authorization: Bearer ) on the 3 Apify HTTP nodes. - [ ] Create a Google Sheet with the columns in *Upsert to Google Sheets* and paste its ID into googleSheetId. - [ ] Connect OpenAI, Slack and Gmail; set slackChannelId and digestEmail in Config. - [ ] In Config set actorInput.categories and locations, minNewnessScore, and skipChains. Use a modest maxPlacesPerSearch while testing. - [ ] Describe your ideal result in aiCriteria, run once manually, then activate. ### Customization - Change the weights in Score new businesses (newness 55, no website 15, phone 15, claimed 5, recent first review 5, no hours 5). - Raise hotScore (60) or warmScore (35) to send fewer alerts. - Needs an Apify account; actor runs use your Apify credits.
Die Schritte
- 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?
Insgesamt 35 Schritte.
Ähnliche Automatisierungen
E-Mail-AutomatisierungSpot rising or declining npm packages with Apify, GPT-4o, Sheets, Slack, and Gmail35 SchritteWeb Scraping & RechercheGoogle-Maps-Unternehmen mit Apify scrapen und in Google Sheets speichern7 SchritteLead-Generierung & AnreicherungLokale Unternehmen ohne Website mit Apify finden und Leads in Google Sheets speichern14 SchritteE-Mail-AutomatisierungSpot rising Hacker News threads and npm or PyPI packages with Apify, OpenAI and Slack35 Schritte