{"product_id":"n8n-workflow-track-google-ads-transparency-creatives-to-sheets","title":"n8n Workflow: Track Google Ads Transparency Creatives to Sheets","description":"\u003ch3\u003eAutomatically track competitors’ Google Ads creatives in Google Sheets—every Monday\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls live ads from the \u003cstrong\u003eGoogle Ads Transparency Center\u003c\/strong\u003e using \u003cstrong\u003eApify\u003c\/strong\u003e, then appends one spreadsheet row per ad into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, including dates, creative links, and a “long runner” flag.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e the workflow is set to execute every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets specific advertisers:\u003c\/strong\u003e you define the competitor \u003cstrong\u003eadvertiserIds\u003c\/strong\u003e (AR… codes from \u003cem\u003eadstransparency.google.com\u003c\/em\u003e URLs), with optional \u003cstrong\u003eregion\u003c\/strong\u003e and \u003cstrong\u003emaxAdsPerAdvertiser\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches live ads via Apify:\u003c\/strong\u003e it uses the \u003cstrong\u003eApify “google-ads-transparency-api” actor\u003c\/strong\u003e to retrieve the current ads for each advertiser.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to actual ads:\u003c\/strong\u003e it keeps only items confirmed as ads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats spreadsheet rows:\u003c\/strong\u003e each ad is converted into a Sheets-ready row—timestamps become dates, and creatives that have been running for \u003cstrong\u003e90+ days\u003c\/strong\u003e are flagged with a \u003cstrong\u003elong runner\u003c\/strong\u003e indicator.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends data to Sheets:\u003c\/strong\u003e the formatted rows are added to your chosen spreadsheet document and worksheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompetitive PPC monitoring:\u003c\/strong\u003e track how competitors’ creative and messaging evolve over time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarketing QA \u0026amp; compliance visibility:\u003c\/strong\u003e maintain a dated record of ads sourced from the Google Ads Transparency Center.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operator reporting:\u003c\/strong\u003e quickly surface “long runner” creatives for review and creative refresh planning.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n scheduling\u003c\/strong\u003e (runs every Monday)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses Apify credentials in n8n to call the \u003cstrong\u003egoogle-ads-transparency-api actor\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e OAuth authentication to append rows to a specific spreadsheet and worksheet\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, \u003ccode\u003eapifyn8n-nodes-apify\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eApify API token\u003c\/strong\u003e as Apify credentials in n8n.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e and select the target spreadsheet + sheet tab.\u003c\/li\u003e\n  \u003cli\u003eUpdate \u003cstrong\u003eadvertiserIds\u003c\/strong\u003e, and optionally adjust \u003cstrong\u003emaxAdsPerAdvertiser\u003c\/strong\u003e and \u003cstrong\u003eregion\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748944470195,"sku":"N8N-17698","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SDpg97rqWfsEJqZPDJ6N_wRo8tWPr.png?v=1785575232","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-google-ads-transparency-creatives-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}