AutomationMart
Home/Browse/Daily ad spend monitoring with Google Sheets and Slack threshold alerts
n8n

Daily ad spend monitoring with Google Sheets and Slack threshold alerts

n8nn8n8 modulesv1.0
SlackGoogle SheetsLinkedIn

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
Daily ad spend monitoring with Google Sheets and Slack threshold alerts workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Every time a new task is created in Kanbanize, Make will automatically import the data to Google Sheets. The template uses [this example spreadsheet](https://docs.google.com/spreadsheets/d/1PqlS6nwi2OfZ6a043ckNcmDMm6ObaGoLpznxWISXyyU/edit?usp=sharing).

Free

Harmoniq [Step 2]: Receive Transcription via Webhook

πŸ“„ Harmoniq [Step 2]: Receive Transcription via Webhook This template handles the response from Harmoniq when a transcription task is completed. It is triggered via webhook and is designed to work together with Step 1. πŸ” What it does: – Waits for the Harmoniq webhook callback – Receives full transcript (text, segments, word-level timing) – Passes data for further processing or storage (e.g., Google Sheets, OpenAI, dubbing) βš™οΈ Setup required: – In the first Harmoniq module, click β€œCreate a webh

Free

Create HERE Tracking locations from Google Sheets

Every time a new row is submitted in Google Sheets, Make will create a new location in HERE Tracking.

Free

Automated video creation using Google Veo3 and n8n workflow

Who is this for? Content creators, social media managers, digital marketers, and businesses looking to automate video production without expensive equipment or technical expertise. What problem is this workflow solving? Traditional video creation requires cameras, editing software, voice recording equipment, and hours of post-production work. This workflow eliminates all these barriers by automatically generating professional videos with audio using just text prompts. What this workfl

Free

Save a new YouTestMe users to a Google Sheets spreadsheet

Every time a new user is created in YouTestMe, Make will automatically add that user to your Google Sheets spreadsheet as a new row. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1dAW00FlUQRjXW8AYkY3FnbbR3VWdRWO7LIS-XDNYv-M/edit?usp=sharing).

Free

Build a Slack knowledge graph with Claude, Neo4j and Google Sheets

Quick Overview This workflow ingests chat messages via a webhook or a 15-minute schedule, filters out low-signal content, uses Anthropic Claude to extract entities and relationships, and stores the resulting knowledge graph in Neo4j while appending an audit log row to Google Sheets. How it works 1. Receives a chat message via an n8n webhook or runs every 15 minutes to process polled Slack data. 2. Normalizes the incoming payload into consistent fields like channel, sender, timestamp, and message

Free

Medical Q&A chatbot for urology using RAG with Pinecone and GPT-4o

Medical Q&A Chatbot for Urology using RAG with Pinecone and GPT-4o This template provides an AI-powered Q&A assistant for the Urology domain using Retrieval-Augmented Generation (RAG). It uses Pinecone for vector search and GPT-4o for conversational responses. 🧠 Use Case This chatbot is designed for clinics or medical pages that want to automate question answering for Urology-related conditions. It uses a vector store of domain knowledge to return verified responses. πŸ”§ Requirements - βœ… OpenAI AP

Free

Raw materials inventory management with Google Sheets, Supabase and approvals

Automated Raw Materials Inventory Management with Google Sheets, Supabase, and Gmail using n8n Webhooks Description What Problem Does This Solve? πŸ› οΈ This workflow automates raw materials inventory management for businesses, eliminating manual stock updates, delayed material issue approvals, and missed low stock alerts. It ensures real-time stock tracking, streamlined approvals, and timely notifications. Target audience: Small to medium-sized businesses, inventory managers, and n8n users familia

Free

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.

Log in to review
Free
No ratings yet

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.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free