Workflow templateEmail a weekly Meta Ads report
Collects last week's Meta Ads numbers, compares them with the previous week, and emails the write-up.
Workflow illustration
01Trigger
TriggerEvery Monday at 07:00 AM UTC, pull last week's spend, clicks, and conversions from the Meta Ads ad account id you choose in setup.
02Go
Google SheetsAppend the totals as a new row in the Google Sheets spreadsheet id you choose in setup, skipping the week if its row is already there.
03
Custom stepRead the previous week's row back and write a short commentary on what moved up or down.
04Gm
GmailEmail the report with Gmail to the address you choose in setup.
05
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every Monday at 07:00 AM UTC, pull last week's spend, clicks, and conversions from the Meta Ads ad account id you choose in setup.
Then
- Append the totals as a new row in the Google Sheets spreadsheet id you choose in setup, skipping the week if its row is already there.
- Read the previous week's row back and write a short commentary on what moved up or down.
- Email the report with Gmail to the address you choose in setup.