Daily ad spend monitoring with Google Sheets and Slack threshold alerts
This n8n workflow checks daily ad spend totals from a Google Sheet and sends a Slack alert if spend exceeds $100. It can be scheduled to run automatically or manually triggered for testing. This is perfect for marketi...
Template notes
This n8n workflow checks daily ad spend totals from a Google Sheet and sends a Slack alert if spend exceeds $100. It can be scheduled to run automatically or manually triggered for testing. This is perfect for marketing teams who want to monitor budget spikes in near real-time.
---
ā Key Features
- š„ Google Sheets Integration: Pulls raw spend data from a shared spreadsheet. - š Scheduled or Manual Execution: Can run daily on a schedule or manually for testing. - š Aggregates Spend: Summarizes daily totals from raw data. - š§ Logic Check: Alerts only when spend exceeds a certain threshold. - š Slack Alerts: Sends instant notification to a specified channel.
---
š§° What You'll Need
- Google Cloud Project with Sheets API enabled - OAuth2 Credential for Google Sheets - Slack Bot Token with permission to post to your workspace - Your Google Sheet link and tab name
š Copy this Sample Google Sheet to Use: [Marketing Data Sheet - Copy Me](https://docs.google.com/spreadsheets/d/19aUQYZq02qHsCelO4eeV4sxMTJJupC5qe0gDLQBtRA/edit?usp=sharing)