Email Automation
Monitor weekly AI search readiness with Apify, Google Sheets, and Gmail
On a schedule, it handles email with Claude using Apify, Gmail, Google Sheets.
What it does
## Weekly AI search readiness monitor (ChatGPT, Claude, Perplexity) Every Monday this audits your site the way AI crawlers see it and logs the scores to Google Sheets. Pages that fall below your threshold trigger one email with the fixes to make first. What gets checked per page: robots.txt rules for 14 AI crawlers (GPTBot, OAI-SearchBot, ClaudeBot, PerplexityBot, Google-Extended…), /llms.txt, sitemap, Schema.org JSON-LD, server-rendered text (JavaScript-only pages), title/description/H1, FAQ content, response time. You get a 0-100 score plus four sub-scores (crawler access, discovery, content, structured data). If the site has no llms.txt, a ready-to-publish draft is included in the email. ### Set up (about 5 minutes) 1. Create a free Apify account and add an Apify credential to *Audit pages with Apify* (Apify API token from Console → Settings → Integrations). 2. Add a Google Sheets credential, pick your spreadsheet and tab in *Append to score history*. Columns are created from the first run. 3. Add a Gmail credential to *Email the alert*. 4. Edit *Set sites and alert threshold*: your site URLs, pages per site, the alert threshold and your email. 5. Run once with *Test workflow*, then activate. ### Cost The Actor charges per audited page (see its Apify Store page for the current price). 3 sites x 10 pages = 30 pages a week. New Apify accounts get monthly free platform credit. ### Customize - Change the schedule in *Every Monday 8:00*. - Set pagesPerSite to 1 to audit only the URLs you list. - Swap Gmail for Slack, Teams or Telegram.
The steps
- Every Monday 8:00
- Set sites and alert threshold
- Audit pages with Apify
- One row per page
- Append to score history
- Pages below threshold
- Build one alert email
- Email the alert
Similar automations
Email AutomationScore small business AI readiness from forms with OpenAI and Gmail34 stepsMCP Servers & ToolsOura Ring Sleep and Readiness as an MCP Server5 stepsEmail AutomationTurn changed docs pages into a weekly podcast with Apify, DeepSeek & ElevenLabs27 stepsEmail AutomationFind hiring-intent companies weekly with Apify and Google Sheets and log them20 steps