Meta Ad Library → Google Sheets
Updated 2026-11-21 · AdHarvest guides
Google Sheets is where many teams keep their competitor research. Here are two ways to get Meta Ad Library ads into a sheet: a quick CSV import, or a live push straight into your sheet.
Method 1: Import a CSV (simplest)
Get a CSV of the ads
Either build it by hand or export it in one click — see how to export the Ad Library to CSV.
Open Google Sheets
Go to sheets.new → File → Import → Upload and choose the CSV.
Choose how to import
Pick Replace current sheet (or Append to add to existing research), separator Detect automatically.
Fix long IDs
Ad IDs are 15–16 digits; Sheets may show them in scientific notation. Select the column → Format → Number → Plain text before importing, or keep them as text.
Method 2: Push ads straight into your sheet (no CSV)
With a tiny script in your own sheet, AdHarvest can append rows directly — no files, and no Google login shared with any third party.
Copy the script
In the AdHarvest side panel, open the Sheets tab → Copy script.
Paste it into Apps Script
In your Google Sheet: Extensions → Apps Script → delete the sample code → paste → save (Ctrl+S).
Deploy as a web app
Deploy → New deployment → type Web app → Execute as Me, Who has access Anyone → Deploy → authorise. (If Google warns the app isn't verified, choose Advanced → Go to … (unsafe) — it's your own script.)
Paste the URL and push
Copy the Web app URL ending in
/exec, paste it in AdHarvest's Sheets tab and click Push. The sheet gets a header row and one row per ad.
AdHarvest exports the ads you're viewing in the Meta Ad Library to CSV, Google Sheets or Airtable in one click — 41 columns including winner score, hook tags, days running, ad sets and the real landing page. Free for 25 rows per export.
Tips for a useful research sheet
- Sort by days running (descending) to see the ads competitors keep paying for.
- Add a filter view per competitor so teammates can browse without changing the sheet.
- Add your own columns — "Hook type", "Offer", "Angle" — and tag ads as you review them.
- Media links expire after some time. If you need the creatives long-term, see how to save competitor ads permanently.
FAQ
Does this need my Google password?
No. The script runs in your Google account; AdHarvest only sends rows to the web-app URL you paste.
I get "Google Sheets did not confirm the rows"
The script isn't deployed for Anyone, or you pasted a /dev URL. Redeploy and use the URL ending in /exec.
I changed the script but nothing changed
Apps Script keeps running the old version until you deploy a new version: Deploy → Manage deployments → Edit → New version.