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 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 --- 🔧 Step-by-Step Setup 1️⃣ Schedule or Manual Trigger - Node: Schedule Workflow or Test Workflow - Purpose: Either run daily via a cron-like rule or manually trigger the flow. 2️⃣ Get Google Sheet Data - Node: Get Data - What it does: Fetches all rows from your connected sheet. - Setup: - Go to Google Cloud Console - Create a new project - Enable Google Sheets API - Create OAuth2 credentials for a desktop or web application - Connect your Google account in n8n via OAuth2 - Grant access to the sheet you want to read (ensure it's shared with your OAuth email) - Use the copied sheet's link when connecting in n8n 3️⃣ Summarize Spend by Day - Node: Sum spend by Day - What it does: Groups the dataset by Date and sums the Spend ($) column - Requirements: - Your sheet must have a header row with Date and Spend ($) as columns 4️⃣ Sort by Most Recent Date - Node: Sort Dates Descending - What it does: Sorts all entries by the Date field so that the most recent day is first - Custom JavaScript: 5️⃣ Select Top Result - Node: Keep only Last Day - What it does: Captures the top row (most recent day) for evaluation - Fields: Sets only Date and sumSpend($) to keep things clean 6️⃣ Check Spend Threshold - Node: Check if Spend over $100 - What it does: Uses an IF node to compare sumSpend($) against a 100 threshold - Logic: 7️⃣ Send Slack Notification - Node: Send Slack Message - What it does: Sends a message to a Slack channel if the threshold is exceeded - Setup: - Go to Slack API - Create a new app - Enable chat:write and channels:read scopes under OAuth & Permissions - Install the app to your workspace - Copy the OAuth Token into your Slack credentials in n8n - Select your target channel from the dropdown (must be public or the bot must be invited) - Message: 8️⃣ No Action if Under Budget - Node: Do Nothing. Under 100 - Purpose: This path simply ends the flow with no action if spend is below the threshold --- 👤 Created By Robert Breen Automation Consultant | AI Workflow Designer | n8n Expert 📧 rbreen@ynteractive.com 🌐 ynteractive.com 🔗 LinkedIn --- 🏷️ Tags slack marketing automation budget alert daily schedule google sheets threshold logic n8n spend tracking data summarization