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)

  1. 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.

  2. Open Google Sheets

    Go to sheets.new → File → Import → Upload and choose the CSV.

  3. Choose how to import

    Pick Replace current sheet (or Append to add to existing research), separator Detect automatically.

  4. 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.

  1. Copy the script

    In the AdHarvest side panel, open the Sheets tab → Copy script.

  2. Paste it into Apps Script

    In your Google Sheet: Extensions → Apps Script → delete the sample code → paste → save (Ctrl+S).

  3. 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.)

  4. 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.

Skip the manual work

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.

See AdHarvest →

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.