The Automation Wing
PPC campaign intelligence: Google Ads scored daily to Sheets and Slack
A daily n8n workflow that scores Google Ads performance against a rules system, logs it to Sheets, and alerts Slack on wasted spend or scaling openings.
A daily health check is the difference between catching a wasted-spend problem on day two and finding it in the monthly report. This template pulls Google Ads metrics every day, runs them through a rules-based scoring system, logs the result to a Google Sheet as a running record, and pushes a Slack alert when a campaign is bleeding budget or showing a genuine opening to scale.
Why it made the cut
Templates get published constantly; few get reused. This one shows the rare, checkable signs of it: it has been independently mirrored on GitHub outside n8n's own library, and it has turned up repackaged for resale by third parties. Nobody bothers doing either to a template that does not work. That is a stronger endorsement than a star count, because it is evidence of people actually running it against real accounts and finding it worth keeping.
How to run it
- Import the workflow from the n8n workflows page below (the GitHub mirror is a useful cross-check on the current node structure).
- Connect Google Ads, set the customer ID, and review the scoring rules against your own account's KPIs before the first run.
- Point the logging step at a Google Sheet you control.
- Connect Slack and set the alert channel and thresholds.
- Schedule it daily and watch the first week of scores before trusting the alerts unattended.
Worth knowing
The scoring rules are a starting framework, not a calibrated model for your account; expect to adjust thresholds against your own margins and seasonality before the alerts are worth acting on. Like every workflow on this list, it reports and flags only, it does not touch budgets, bids or campaign status. Because it is popular enough to have been repackaged for resale, check you are importing the source template rather than a paid reskin before you pay anyone for it.