Email Automation
Audit competitor ad footprints from Google and Meta with Apify and OpenAI
On a schedule, it handles email with OpenAI / ChatGPT using Gmail, Google Sheets, Slack, Apify.
What it does
## Audit which competitor domains are running Google and Meta ads with Apify and OpenAI Checks each domain you list in the public Google Ads Transparency Center and Meta Ad Library, and scores how much it advertises, how recently it launched new ads and whether it uses more than one network. Built for agencies, sales teams and marketers sizing up competitors or prospects. ### 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 ad-footprint-by-domain and downloads the results. 3. Drops incomplete rows and anything already seen in the last 30 days. 4. Score ad footprint gives a 0-100 rule score; an OpenAI model adds a fit score, verdict and summary. 5. Upserts every row to the Ad footprint 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.domains, country, sources and minActiveMetaAds. Run it weekly or daily; each run adds a dated row per domain. - [ ] Describe your ideal result in aiCriteria, run once manually, then activate. ### Customization - Change the weights in Score ad footprint (actor footprint score 40, both networks 15, new Meta ads 20, active Meta ads 15, recent Google ads 10). - Needs an Apify account; actor runs use your Apify credits.
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
Web Scraping & ResearchAudit Google Maps local leads with Apify Local Lead Audit and Google Sheets8 stepsEmail AutomationAudit Instagram post performance with Apify, OpenAI, Google Sheets, Slack and Gmail35 stepsEmail AutomationTrack Meta Ad Library winners with Apify, OpenAI, Google Sheets, and Slack35 stepsEmail AutomationAudit vendor and customer registrations via Apify and alert on lapsed standing35 steps