# Send weekly client performance reports via Gmail and Slack using Google Sheets, Meta Ads, Google Ads, GA4, and OpenAI

> Quick overview This workflow runs every Monday, reads a Google Sheets config to fetch weekly metrics from Meta Ads, Google Ads, and GA4, uses OpenAI to write a narrative around deterministic week-over-week deltas, and delivers branded reports via Gmail and/or Slack while logging sends back to Google Sheets. How it works 1. Runs on a schedule every Monday at 09:00 (workflow timezone) and loads client settings from the Google Sheets config tab plus previously sent dedupekey values from the reports tab. 2. Validates each config row, skips disabled clients, and turns missing sources or delivery targets into alerts that continue through the run. 3. For each enabled data source per client, fetches weekly metrics from the Meta Marketing API, Google Ads API, and/or Google Analytics Data API (GA4) and normalizes the results into a shared metric format. 4. Computes week-over-week percentage deltas and flags anomalies when a metric’s absolute change meets the per-client alertthresholdpct. 5. Grou

- **Domain**: `n8n-workflow-20661.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20661
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20661.n8n.io
- Documentation: https://n8n.io/workflows/20661