Extract Google Ads creatives by domain with SerpAPI and export to CSV
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes. It also calls serpapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Domain & Region (Edit Fields (Set)): sets or maps fields
- Get Ads Page (HTTP Request): calls serpapi.com
- Extract Ad Creatives (Function): runs custom JavaScript (legacy Function node)
- Split by Format (Switch): routes items into 3 branches
- Convert Text Ads to CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Convert Image Ads to CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Convert Video Ads to CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
HTTP calls to: serpapi.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Extract Ad Creatives: replace with Code node, mode 'Run Once for All Items'.
- Also check Spreadsheet File: Convert to File / Extract from File.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Extract Ad Creatives | Code node, mode 'Run Once for All Items' |
Nodes used (6)
- HTTP Request
n8n-nodes-base.httpRequest - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Function
n8n-nodes-base.function - Switch
n8n-nodes-base.switch - Spreadsheet File
n8n-nodes-base.spreadsheetFile
From the author
🧾 Template: Extract Ad Creatives from Google’s Ads Transparency Center This n8n workflow pulls ad creatives from Google's Ads Transparency Center using SerpApi, filtered by a specific domain and region. It extracts, filters, categorizes, and exports ads into…