Setup guide
Connect AdHarvest to where your team already works. Each setup is one-time and takes a few minutes. CSV and JSON exports need no setup at all.
Airtable (about 2 minutes)
AdHarvest creates the table and all columns for you. Airtable keeps a permanent copy of every video and image, so creatives survive after Meta removes the ad.
-
Open or create a base
Go to airtable.com. An empty base is perfect: Create → Start from scratch. You don't need to add any tables or columns.
-
Create a personal access token
Open airtable.com/create/tokens → Create token.
Name: AdHarvest. Scopes: click Add a scope four times and add:
data.records:readdata.records:writeschema.bases:readschema.bases:write
Access: click Add a base and pick your base. (Avoid “Add all resources”. The token only needs this one base.)
Click Create token and copy it right away. Airtable shows it only once. It starts with
pat.Your token is stored only in your browser and sent only to Airtable, never to AdHarvest. -
Copy your Base ID
Open your base. The address bar shows a URL like this. The Base ID is the part starting with
app:https://airtable.com/appJl4yPm0KVYRJfI/tblQ1w2e3r4t5y6u7/viw…Paste just that part, or the whole URL. AdHarvest picks out the ID either way.
-
Paste both into AdHarvest and push
Open the AdHarvest side panel → Airtable tab → paste the token (step 2) and Base ID (step 3). Leave the table name as Meta Ads Swipe File → Push to Airtable.
The first push creates the table and its columns. After that, pushing again updates existing rows. It never creates duplicates.
Google Sheets (about 3 minutes)
You add a small script to your own sheet. AdHarvest sends rows to it directly, and no Google login is shared with us.
-
Copy the AdHarvest script
Open the AdHarvest side panel → Sheets tab → Copy script.
-
Paste it into Apps Script
Open a Google Sheet (sheets.new makes a new one) → Extensions → Apps Script.
Select all the code that's there (
function myFunction…), delete it, paste the AdHarvest script, and press Ctrl+S to save. -
Deploy it as a web app
Click the blue Deploy → New deployment. Next to “Select type”, click ⚙️ → Web app. Set:
- Execute as: Me
- Who has access: Anyone (required. Other options make pushes fail.)
Click Deploy → Authorize access and choose your Google account.
If Google shows “Google hasn't verified this app”, click Advanced → Go to Untitled project (unsafe) → Allow. This is normal for your own scripts: the script is yours and runs in your account. -
Paste the Web app URL into AdHarvest and push
Copy the Web app URL. It ends in
/exec:https://script.google.com/macros/s/AKfycb…/execPaste it in the AdHarvest Sheets tab → Push to Google Sheets. The sheet fills with a bold header row and your ads.
Zapier, Make or n8n
Create a “Catch webhook” / “Custom webhook” trigger in your tool, copy its https:// URL, and paste it in the AdHarvest Sheets tab (step 4). AdHarvest sends a JSON body with columns and rows. Chrome will ask once to allow access to that site. Click Allow.
Troubleshooting
- Airtable: “UNKNOWN_FIELD_NAME” or “INVALID_PERMISSIONS” / 403
- Your token is missing a scope or doesn't have access to the base. Edit the token at airtable.com/create/tokens: check all four scopes are added and your base is listed under Access.
- Airtable: “NOT_FOUND” / 404
- The Base ID is wrong. Copy the
app…part from your base's URL again (step 3). - Google Sheets: “Google Sheets did not confirm the rows”
- The script isn't deployed for Anyone, or you pasted a
/devURL. Redeploy: Deploy → New deployment → Web app → Who has access: Anyone, and use the URL ending in/exec. - Google Sheets: I changed the script and nothing updated
- Apps Script keeps running the old version until you deploy again: Deploy → Manage deployments → ✏️ edit → Version: New version → Deploy.
- “Go back to a Meta Ad Library search page”
- AdHarvest only works on facebook.com/ads/library. Open a search there and try again.
- Still stuck?
- Email adharvest0@gmail.com with a screenshot of the message. We usually reply within a day.