Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets

Workflow preview

100%

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

1. Workflow Overview

Quick Overview This workflow pulls Pending companies from Google Sheets, checks their ad activity via Adyntel for Meta (Facebook), Google Ads, and LinkedIn Ads, calculates a budget signal score fro...

Best for

Automation automation workflows
intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.googlesheets, n8n-nodes-base.splitinbatches, n8n-nodes-adyntel.adyntel, n8n-nodes-base.merge, n8n-nodes-base.code, n8n-nodes-base.stickynote

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Zain Khan.

Original n8n.io source

1.1 Workflow description

Title: Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets
Workflow name: Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets

Quick Overview

This workflow pulls Pending companies from Google Sheets, checks their ad activity via Adyntel for Meta (Facebook), Google Ads, and LinkedIn Ads, calculates a budget signal score from ad volume and channel diversity, and writes the results back to the same sheet.

How it works

Runs when you manually execute the workflow in n8n.
Reads rows from Google Sheets where the Status column is set to Pending.
Processes each company domain in sequence and queries Adyntel for Meta (Facebook) ads, Google Ads, and LinkedIn Ads.
Combines the three ad search results into a single dataset for the current company.
Calculates per-platform ad counts, total ads, active platforms, channel diversity, and a composite budget_signal_score.
Updates the matching row in Google Sheets (by domain), writes the scoring fields, and sets Status to Done before moving to the next company.

Setup

Connect Google Sheets OAuth credentials and set the target spreadsheet and sheet where your company list lives.
Add Adyntel API credentials so the workflow can query Meta (Facebook), Google Ads, and LinkedIn Ads by company domain.
Ensure your Google Sheet includes at least company_name, domain, and Status columns, with Status set to Pending for rows you want to process.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - When clicking ‘Execute workflow’

Type / Role: n8n-nodes-base.manualTrigger - manualTrigger
Config choices: Version 1

Block 2 - Bulk List Ad-Spend Scorer

Type / Role: n8n-nodes-base.googleSheets - googleSheets
Config choices: Version 4.7

Block 3 - Loop Over Accounts

Type / Role: n8n-nodes-base.splitInBatches - splitInBatches
Config choices: Version 3

Block 4 - Search LinkedIn Ads

Type / Role: n8n-nodes-adyntel.adyntel - adyntel
Config choices: Version 1

Block 5 - Search Google Ads

Type / Role: n8n-nodes-adyntel.adyntel - adyntel
Config choices: Version 1

Block 6 - Search Facebook Ads

Type / Role: n8n-nodes-adyntel.adyntel - adyntel
Config choices: Version 1

Block 7 - Merge All Platform Results

Type / Role: n8n-nodes-base.merge - merge
Config choices: Version 3.2

Block 8 - Score & Enrich

Type / Role: n8n-nodes-base.code - code
Config choices: Version 2

Block 9 - Update Sheet — Scored

Type / Role: n8n-nodes-base.googleSheets - googleSheets
Config choices: Version 4.7

Block 10 - Sticky Note

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 11 - Sticky Note1

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 12 - Sticky Note2

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 13 - Sticky Note3

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

3. Summary Table

Workflow	Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets
Complexity	intermediate
Nodes	13
Categories	Automation
Author	Zain Khan
Published	16 Jun 2026

4. Reproducing the Workflow from Scratch

1. Download the workflow JSON

Use the JSON export at /data/workflows/16438/16438.json as the source template for this automation.
2. Import the template into n8n

Open n8n, import the downloaded JSON, and review each node before activating the workflow.
3. Configure credentials and variables

Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
4. Test with sample data

Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
5. Activate and monitor

Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source Automation workflows

Frequently asked questions

What does Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets do?

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Automation use case.

Zain Khan

21 workflows

Nodes

n8n-nodes-base.manualtrigger n8n-nodes-base.googlesheets n8n-nodes-base.splitinbatches n8n-nodes-adyntel.adyntel n8n-nodes-base.merge n8n-nodes-base.code n8n-nodes-base.stickynote

Complexity

intermediate

Published 16 Jun 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/16438/16438.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Generate and publish AI home cam Shorts with OpenAI, kie.ai and YouTube

## Quick overview This workflow runs three times daily to generate an AI “home cam” short video concept with OpenAI, create the video via kie.ai, then download and archive it to Google Drive, upload it to YouTube as a public video, and send a confirmation email via Gmail. ## How it works 1. Runs on a schedule three times a day (08:00, 12:00, and 18:00). 2. Selects a random scenario number from the configured range and asks OpenAI (GPT-4.1-mini) to generate a title, description, tags, and a detailed text-to-video prompt as structured JSON. 3. Builds a kie.ai Sora-2 text-to-video job request using the generated prompt and submits it to the kie.ai API. 4. Waits and repeatedly polls kie.ai until the job succeeds and returns a result payload containing a video download URL. 5. Downloads the generated video file from the returned URL. 6. Uploads the video to a specified Google Drive folder, publishes it to YouTube with the AI-generated metadata, and emails you a notification containing the prompt and video link. ## Setup 1. Add an OpenAI API credential, a kie.ai API key using HTTP Header Auth, and OAuth credentials for Google Drive, YouTube, and Gmail. 2. In the workflow variables, set your notification email address, the target Google Drive folder ID, and the callback URL value used in the kie.ai request. 3. Review or adjust the random scenario range (videoIdeaMin/videoIdeaMax) and YouTube upload settings (for example, privacyStatus and notifySubscribers) before activating the workflow. ## Requirements - OpenAI API credential - kie.ai API key - OAuth credentials for Google Drive, YouTube, and Gmail

View

Prioritize exception queues with Gemini, Google Sheets, Slack and Gmail

## Quick Overview This workflow receives a webhook trigger, reads exception records from Google Sheets, uses Google Gemini (Generative Language API) to rank and summarize them, posts a prioritized report to Slack, writes summary metrics back to Google Sheets, and emails a critical alert via Gmail when needed. ## How it works 1. Receives a webhook request to start an exception-queue analysis run. 2. Reads the current exception list from a Google Sheets worksheet and stops with a “No open exceptions found” webhook response if there are no rows. 3. Formats the sheet rows into a structured text list and sends it to the Google Gemini API to generate a ranked, scored priority list plus summary counts. 4. Parses the Gemini response and builds Slack Block Kit content, an HTML email body for critical items, and fields for saving analysis metadata. 5. Appends or updates a summary row in a second Google Sheets worksheet with the AI summary and severity counts. 6. Posts the ranked exception report to a Slack channel. 7. If any critical exceptions are detected, sends an alert email via Gmail, then returns a JSON “Done” response to the original webhook caller with processing statistics. ## Setup 1. Add credentials for Google Sheets OAuth2, Slack OAuth2, and Gmail OAuth2 in n8n. 2. Provide a Google Gemini API key and update the HTTP request to use it (preferably via an n8n credential or environment variable rather than hard-coding). 3. Update the Google Sheets document ID and ensure Sheet1 contains columns like ExceptionID, Title, Severity, System, and ReportedAt, and Sheet2 has columns for summary and count fields used by the workflow. 4. Select the target Slack channel in the Slack node and confirm it matches where you want the priority report posted. 5. Configure the Gmail node with the recipient(s) and ensure your webhook URL (path: /exception-trigger) is used by the system that should trigger the analysis.

View

Send end-of-day ops summaries with Google Sheets, Gemini, Slack and Gmail

## Quick Overview This workflow runs daily at 6 PM to pull trade breaks, failed trades, and exceptions from Google Sheets, calculate resolved vs pending counts with a severity/trend classification, generate an end-of-day summary with Google Gemini, optionally alert Slack for high pending volume, email the report via Gmail, and log results back to Google Sheets. ## How it works 1. Runs every day at 6 PM on a schedule trigger. 2. Reads rows from three Google Sheets tabs containing trade breaks, failed trades, and exceptions, then merges them into a single dataset. 3. Filters to records with a non-empty Status field and calculates total issues plus resolved vs pending counts. 4. Classifies overall severity (LOW–CRITICAL) and trend (IMPROVING/WORSENING/STABLE) based on pending and resolved counts. 5. Sends the metrics to Google Gemini to generate a formatted Summary and Email body. 6. Posts a high-priority Slack alert when pending issues exceed 5, and then extracts the generated email body. 7. Sends the end-of-day summary via Gmail and appends the date, counts, severity, trend, and summary to a Google Sheets log tab. ## Setup 1. Connect a Google Sheets OAuth2 account and update the spreadsheet ID and sheet/tab IDs for the three input tabs and the output log tab. 2. Ensure each source sheet includes a Status column with values such as “resolved” so the workflow can compute resolved vs pending. 3. Add a Google Gemini (PaLM) API credential for the AI-generated summary and email text. 4. Add a Slack OAuth2 credential and select the destination channel for high-priority alerts. 5. Add a Gmail OAuth2 credential and set the recipient(s) in the Gmail node so the end-of-day email goes to the right inbox.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets

Workflow preview

1. Workflow Overview

Best for

Tools used

Source and attribution

1.1 Workflow description

Quick Overview

How it works

Setup

1.2 Logical Blocks

2. Block-by-Block Analysis

Block 1 - When clicking ‘Execute workflow’

Block 2 - Bulk List Ad-Spend Scorer

Block 3 - Loop Over Accounts

Block 4 - Search LinkedIn Ads

Block 5 - Search Google Ads

Block 6 - Search Facebook Ads

Block 7 - Merge All Platform Results

Block 8 - Score & Enrich

Block 9 - Update Sheet — Scored

Block 10 - Sticky Note

Block 11 - Sticky Note1

Block 12 - Sticky Note2

Block 13 - Sticky Note3

3. Summary Table

4. Reproducing the Workflow from Scratch

1. Download the workflow JSON

2. Import the template into n8n

3. Configure credentials and variables

4. Test with sample data

5. Activate and monitor

5. General Notes & Resources

Frequently asked questions