Learn how to automate each element of your ad reports - tables, charts, text, and scorecards - using Google Ads data as an example.
Element | What It Shows | Example |
---|---|---|
Data Table | Raw performance data | Campaign names, clicks, cost, conversions |
Chart | Visual trends | Monthly spend trend, campaign comparison |
Text Summary | Written insights | ”Brand campaigns had 25% higher CTR this month” |
Scorecard | Key metrics | Total spend: $12,500, Total conversions: 145 |
campaign_table
Update Campaign Table
campaign_table
(must match what you set earlier)campaign_table
cost
clicks
impressions
conversions
cost
→ Connect Cost from Google Ads outputclicks
→ Connect Clicks from Google Ads outputimpressions
→ Connect Impressions from Google Ads outputconversions
→ Connect Conversions from Google Ads outputcost
finds cost, clicks
finds clicksspend_chart
and use that in the Refresh Sheets Chart node.
Advanced: Dynamic Chart Creation for Templates
weekly_insights
weekly_insights
campaign_table
, spend_chart
)Table not updating
Chart not appearing or not refreshing
AI text looks weird or incomplete
Scorecards showing wrong numbers
cost
, not Cost
)Workflow runs but slides don't update
Google Ads data is empty or missing
Charts show old data even after running
Can I use this with other ad platforms?
How do I schedule this to run automatically?
Can I update multiple presentations with one workflow?