Audit client websites weekly with Apify, Google Sheets, and email summaries
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 7 nodes and runs on a schedule (every week at 06:00). Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: On a schedule (every week at 06:00).
- Client sites and report settings (Edit Fields (Set)): sets 4 fields: urls, agencyName, emailTo…
- Audit every site (Apify): run actor and get dataset (actors)
- One row per site (Code): runs custom JavaScript code
- Log scores to Google Sheets (Google Sheets): append
- Build email with top fixes (Code): runs custom JavaScript code
- Email the summary (Send Email): sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Audit every site).
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend
From the author
Quick overview Every Monday this workflow audits your list of websites with the Website Audit Report Apify Actor, logs one row per site to Google Sheets, and emails one summary listing the lowest-scoring sites first with each site's top 3 fixes and…