Monitor LinkedIn Ad Library ads with Apify and Google Sheets

Quick overview

This workflow runs daily and uses Apify’s LinkedIn Ad Library Scraper to collect ads for a keyword and countries, then appends the ad details, CTAs, impressions by country, and targeting parameters into a Google Sheets spreadsheet stored in Google Drive.

How it works

1. Runs every day at 08:00 on a schedule.
2. Sets the search keyword, target countries, output spreadsheet name, and maximum number of ads to scrape.
3. Searches Google Drive for a Google Sheets file matching the configured spreadsheet name and creates it (with Overview, CTA, Impressions, and Targeting Parameters tabs) if it does not exist.
4. Runs the Apify actor “LinkedIn Ad Library Scraper” for the configured keyword, countries, and date range to retrieve a dataset of ads.
5. Appends one row per ad (overview fields like advertiser, dates, headline, body, and targeting location/language) into the Google Sheets “Overview” tab.
6. Splits multi-value fields into separate rows and appends them to dedicated tabs: CTAs to “CTA”, impressions per country to “Impressions”, and targeting parameters to “Targeting Parameters”.

Setup

1. Add Apify API credentials with access to the actor “LinkedIn Ad Library Scraper (serj_henrique/linkedin-ad-library-scraper)”.
2. Add Google Drive OAuth2 credentials and Google Sheets OAuth2 credentials with permission to search for and create/edit the target spreadsheet.
3. Update the input values in “Configure Input Parameters” (keyword, country array, sheet_name, and max_ads_to_scrape) to match what you want to monitor.