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 da
At a glance
Daily ad spend monitoring with Google Sheets and Slack threshold alerts is a ready-made n8n workflow you import as a workflow JSON file β no build required. It connects Slack, Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Slack, Google Sheets, LinkedIn
- Modules
- 8
- Price
- Free
- Version
- v1.0

About this workflow
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
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n β click the menu β Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Export Kanbanize tasks to Google Sheets automatically
Harmoniq [Step 2]: Receive Transcription via Webhook
Create HERE Tracking locations from Google Sheets
Automated video creation using Google Veo3 and n8n workflow
Save a new YouTestMe users to a Google Sheets spreadsheet
Build a Slack knowledge graph with Claude, Neo4j and Google Sheets
Medical Q&A chatbot for urology using RAG with Pinecone and GPT-4o
Raw materials inventory management with Google Sheets, Supabase and approvals
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint β instant download
- Setup guide PDF included
- 5 downloads Β· valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you