Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

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

  1. Daily schedule
  2. Run manually
  3. Weekly report schedule
  4. Config
  5. Daily run or weekly report?
  6. Start Apify run
  7. Wait before polling
  8. Get run status
  9. Check run status
  10. Route by run status
  11. Stop: Apify run failed
  12. Fetch dataset items
  13. Validate and dedupe
  14. Any new records?

35 steps in total.

Similar automations