Extract Google Ads creatives by domain with SerpAPI and export to CSV

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 neatly formatted CSV files for easy analysis. --- 👤 Who’s it for? Marketing Analysts researching competitive PPC strategies Ad Intelligence Teams monitoring creatives from specific brands Digital Marketers gathering visual and copy trends Journalists & Watchdogs reviewing ad activity transparency --- ✅ Features Fetch creatives using SerpApi's googleadstransparencycenter engine Filter results to include only ads with an exact match to your target domain Categorize by ad format: text, image, or video Export CSVs: Generates a downloadable file for each format under the /files/ directory --- 🛠 How to Use 1. Edit the “Set Domain & Region” node domain: e.g. example.com region: SerpApi numeric region code → See codes 2. Add your SerpApi API key In the “Get Ads Page 1” node’s credentials section. 3. Run the workflow Click "Test workflow" to initiate the process. 4. Download your results Navigate to /files/ to find: text{domain}ads.csv image{domain}ads.csv video{domain}ads.csv --- 📌 Notes Only the first page (up to 50 creatives) is fetched; pagination is not included. Sticky Notes inside the workflow nodes offer helpful internal annotations. CSV files include creative-level details: ad copy, images, video links, etc.