Daily Google Ads Performance Reporter to Notion & Sheets
Automates daily extraction of Google Ads clicks, impressions, costs, and conversions, merging data into Notion databases and Google Sheets for effortless campaign tracking.
This workflow streamlines daily Google Ads performance reporting by triggering at 08:00 AM to fetch yesterday's campaign metrics via the Google Ads API. It queries clicks, impressions, and costs in one request, and conversions with action names in another, then splits and merges datasets by campaign ID and date for comprehensive records.
Campaign-level data is upserted into a Notion 'Google Ads Campaign Tracker' database and appended to a 'Campaign Daily Report' Google Sheets tab. A code node then aggregates totals for impressions, clicks, conversions, costs, and unique conversion types, storing summaries in Notion's 'Google Ads Daily Summary' and Sheets' 'Summary Report' tabs.
Benefits include eliminating manual reporting, ensuring consistent centralized data across tools, and saving hours weekly for marketing teams. Ideal for agencies managing multiple campaigns, e-commerce brands tracking ROI, or any business needing automated ad performance insights without spreadsheets or BI tools.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Related bundle
Customer Support Automation Suite
8 hand-picked workflows for $39.00.
That is $4.88 each, vs $24.99 for this one alone.
View bundleSecure checkout powered by Stripe
Tags
Support
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Communication workflows
- Automate Outbound Calls with Ultravox AI and Twilio$4.99
- Automate Intelligent Email Classification with AI in Gmail$4.99
- Generate AI videos and carousels with Blotato for Instagram and TikTok$9.99
- Automating WhatsApp Replies Using GoHighLevel with Redis and Anthropic$24.99
- Automate Gmail Email Labeling with AI for Enhanced Organization$14.99
- Automate Email Summarization and Logging with AI and Google Sheets$9.99
More from Gideon Hedlund
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.