{"product_id":"linkedin-ad-library-to-google-sheets-via-n8n-apify","title":"LinkedIn Ad Library to Google Sheets via n8n + Apify","description":"\u003ch3\u003eTurn LinkedIn Ad Library results into Google Sheets rows automatically (with n8n + Apify)\u003c\/h3\u003e\n\u003cp\u003eScrape LinkedIn Ad Library ads, generate hooks and transcripts, and append one spreadsheet-ready row per ad directly into Google Sheets—using an n8n workflow powered by Apify.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e starts when you manually run it. It then:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends your configured LinkedIn Ad Library URL\u003c\/strong\u003e and \u003cstrong\u003emaximum ad count\u003c\/strong\u003e to an \u003cstrong\u003eApify\u003c\/strong\u003e actor to start a LinkedIn Ad Library scrape.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls the Apify run status\u003c\/strong\u003e until it finishes and retrieves the run’s \u003cstrong\u003edataset ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls a second Apify actor\u003c\/strong\u003e to \u003cstrong\u003etranscribe video ads\u003c\/strong\u003e (and read \u003cstrong\u003eon-image copy where available\u003c\/strong\u003e) using the dataset ID, returning transcript items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReshapes and sorts the results\u003c\/strong\u003e into \u003cstrong\u003eone row per ad\u003c\/strong\u003e, including fields like \u003cstrong\u003eheadline\u003c\/strong\u003e, \u003cstrong\u003eformat\u003c\/strong\u003e, a \u003cstrong\u003e3-second hook\u003c\/strong\u003e, \u003cstrong\u003etranscript\u003c\/strong\u003e, \u003cstrong\u003elanguage\u003c\/strong\u003e, \u003cstrong\u003eduration\u003c\/strong\u003e, and \u003cstrong\u003edetail_url\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the rows\u003c\/strong\u003e to your chosen \u003cstrong\u003eGoogle Sheets spreadsheet\u003c\/strong\u003e and \u003cstrong\u003esheet\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eB2B ad research\u003c\/strong\u003e: collect competitors’ LinkedIn ad creatives into Google Sheets for structured analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreative iteration\u003c\/strong\u003e: use the generated \u003cstrong\u003e3-second hook\u003c\/strong\u003e and \u003cstrong\u003etranscripts\u003c\/strong\u003e to inform new messaging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonthly monitoring\u003c\/strong\u003e: run on a schedule (e.g., monthly) to track changes over time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMulti-advertiser sweeps\u003c\/strong\u003e: loop through a list of advertiser\/search URLs and keep a \u003cstrong\u003edetail_url\u003c\/strong\u003e to jump back to the original ad.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (HTTP requests with \u003cem\u003eAuthorization: Bearer \u0026lt;token\u0026gt;\u003c\/em\u003e) and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e if, set, code, sticky note, HTTP Request, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements:\u003c\/strong\u003e an \u003cstrong\u003eApify\u003c\/strong\u003e account and a \u003cstrong\u003eGoogle\u003c\/strong\u003e account.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup highlights:\u003c\/strong\u003e add your Apify API token as HTTP header auth, connect Google Sheets, and update Config with the LinkedIn Ad Library URL and max ads.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eBest for:\u003c\/strong\u003e n8n users, automation engineers, and SaaS operators who want LinkedIn Ad Library scraping + transcript enrichment feeding directly into Google Sheets.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950097883315,"sku":"N8N-19157","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2BdNCblXcdCwzAnQnbcea_oE6U36mW.png?v=1788513355","url":"https:\/\/buyflowscripts.com\/products\/linkedin-ad-library-to-google-sheets-via-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}