Email Automation
Vet Instagram creators by engagement and reach with Apify, OpenAI and Sheets
On a schedule, it handles email with OpenAI / ChatGPT using Gmail, Google Sheets, Slack, Apify.
What it does
## Instagram creator vetting from public profiles Reads public Instagram profiles you list, skips private accounts, and scores each on follower range, real engagement from the latest posts, an email or link in the bio and posting recency. Built for influencer shortlists, brand partnerships and competitor benchmarking. Public profile data only. ### 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
Email AutomationTriage vet prescription refills and chase sign-offs with Sheets, Gmail, DeepSeek42 stepsForms & SurveysReach small businesses by phone and manage replies with Odile Direct27 stepsEmail AutomationAudit Instagram post performance with Apify, OpenAI, Google Sheets, Slack and Gmail35 stepsEmail AutomationFind high-performing Instagram Reels with Apify, OpenAI, Slack and Gmail35 steps