Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Adyntel (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Bulk List Ad-Spend Scorer (Google Sheets): uses Google Sheets
- Loop Over Accounts (Loop Over Items (Split in Batches)): loops over the items in batches
- Search Facebook Ads (Adyntel): uses Adyntel
- Search Google Ads (Adyntel): work with google ads
- Search LinkedIn Ads (Adyntel): work with linked in ads
- Merge: merges the data from its input branches
- Score & Enrich (Code): runs custom JavaScript code
- Update Sheet — Scored (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-adyntel is verified or supports 3.0 (used in Search LinkedIn Ads, Search Google Ads, Search Facebook Ads).
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Adyntel
n8n-nodes-adyntel.adyntel - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code
From the author
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…