Audit client websites weekly with Apify, Google Sheets, and email summaries

Description

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 white-label HTML report link.

How it works
Schedule Trigger runs weekly (Monday 6am; change it to any interval).
Set node holds your site list, the agency name shown on the reports, and the email addresses.
Apify node runs the Website Audit Report Actor (https://apify.com/pewterdesk/website-audit-report) and waits for the results (cost cap: $1 per run). It checks the homepage plus up to 10 pages sampled from each site's sitemap.
Code node turns the results into clean rows for Google Sheets.
A second Code node builds the HTML email; Send Email delivers it.

Setup
Create a free Apify account and add your API token as an Apify credential.
Optional: add a free Google PageSpeed Insights API key as googleApiKey in the Apify node for Lighthouse and Core Web Vitals.
Create a Google Sheet with a tab named Audit log and connect Google Sheets.
Connect an SMTP credential for Send Email (or swap in Gmail/Outlook).
Edit your site list and agency name in the Set node.

Requirements
Apify account (free) and API token
Google Sheet with an Audit log tab
Email (SMTP) credential

Customization
Add brandColor and logoUrl in the Apify node for white-label HTML reports.
Change maxPagesPerSite (0–25) to sample more or fewer pages.
Run monthly instead of weekly via the Schedule Trigger.

Additional info
Built on the Website Audit Report Apify Actor: https://apify.com/pewterdesk/website-audit-report