Export competitor ads from Google, Meta, LinkedIn, and TikTok into Google Sheets for instant analysis and research.
Meta Ads
TikTok Ads
LinkedIn Ads
Google Ads
Google SheetsUse this competitor ads spy workflow to pull creatives from Facebook Ads Library, Meta Ads Library, TikTok Ads Library, Google Ads Transparency Center, and LinkedIn Ads Library into a single Google Sheet. It gives you one place to run competitor ads analysis across all major ad platforms.
Instead of checking every ads library manually and copying screenshots, you paste an advertiser URL or basic details, run the workflow, and get a structured sheet of competitor ads you can filter, sort, and present.
This template acts like a multi platform ad spy tool built on top of official ads libraries. It helps you:

You can start in two ways:
For each advertiser, the workflow:
You end up with a clean competitor ads database instead of scattered screenshots and bookmarks.
Instead of checking Meta Ads Library, Google Ads library, TikTok Ads Library, and LinkedIn Ads Library separately, this workflow:
It feels like having your own ads library front end optimized for competitive research.
With this competitor ads spy template you can:
It turns ad library browsing into a repeatable competitor ads analysis process.
Because the data comes directly from the official ads libraries, you can:
You get a steady stream of fresh ideas grounded in actual competitor creatives.
For agencies and internal teams, this template:
It is much simpler to get buy in when everyone can see how other advertisers are showing up in each channel.
This ads library template fits into several workflows.
The workflow creates one Google Sheet with multiple organized tabs. A typical run includes:
Meta Ads (Facebook and Instagram)
Image, video, carousel ads with:
Google Ads Transparency Center / Google Ads Library
Search, display, and YouTube creatives with:
TikTok Ads Library
Vertical video ads with:
LinkedIn Ads Library (Sponsored Content)
B2B oriented ads with:
Each tab uses a structured layout so you can filter by advertiser, format, country, and more without extra cleanup.
Input Competitor Or Ads Library URL
You either paste a public ads library URL from Meta, Google, TikTok, or LinkedIn, or you enter the advertiser details such as name, ID, and country.
Platform Specific Ads Library Queries
The workflow calls each platform’s ads library or transparency endpoint. It pulls the available ads that match your filters, such as country, active status, and ad format.
Data Normalization And Mapping
Creative level data from Meta Ads Library, Facebook Ads Library, Google Ads Transparency Center, TikTok Ads Library, and LinkedIn Ads Library is normalized into a common structure. Fields like text, media URL, landing page, platform, and timestamp are aligned.
Google Sheets Export
The workflow writes the results into a Google Sheet:
Review And Ongoing Updates
You can rerun the workflow as often as you like to capture new competitor ads and append them to the same sheet or a new one.
Prepare A Google Sheet
Use the provided template or create a new Google Sheet where the workflow will write the output tabs for Meta, Google, TikTok, and LinkedIn.
Connect Your Google Account
In the workflow, connect your Google account so it can create and update the Google Sheet.
Add Competitor Inputs
Choose whether you want to start with:
Adjust Filters If Needed
Configure optional filters such as:
Run The Workflow
Execute the workflow to pull competitor ads from each ads library and write them into your sheet. Review the results, adjust filters if needed, and rerun for additional brands.
This competitor ads spy template is ideal for:
If you currently open Meta Ads Library, TikTok Ads Library, Google Ads Transparency Center, and LinkedIn Ads Library manually every time you do competitive research, this workflow gives you a repeatable ad spy tool that pulls everything into one place.
Discover more marketing workflow templates to automate your tasks



Generate consolidated Google & Meta Ads performance reports in Google Slides with AI-enhanced insights and visualizations.


Chat with your Google Analytics data directly in Slack by asking natural language questions and getting instant insights without leaving your workspace.



Say goodbye to manual Google Ads audits. Run a full account check in minutes with over 40 automated checks.



Create dozens of Meta ads in minutes by uploading your entire campaign structure from a single Google Sheet, eliminating tedious manual ad creation.



Generate comprehensive monthly SEO reports in Google Slides using data from Google Search Console and Google Analytics with AI insights.



Say goodbye to manual Meta Ads audits. Run a full account check in minutes with over 100 data points


Build Google Responsive Search & Display ads at scale using one Google Sheet — just enter headlines, descriptions, image URLs, and optional YouTube videos.



Turn Google Merchant Center’s price benchmarks into daily custom labels you can use in Google Ads to scale campaigns by competitiveness.


Chat with your Google Ads data directly in Slack by asking natural language questions and getting instant campaign insights without leaving your workspace.




10,000+ marketers scaling with AI.
Describe your marketing automation needs and let our AI build a custom workflow for you.
Sign up now and let Markifact handle the busywork so you can focus on growth.