Google Sheets workflow
From Google Sheet to Meta ads — paste, click, launched.
The fastest way to get ads from a brief into a Meta ad set. Compose in Sheets where your team already collaborates. Bulk-launch in one click.
Why sheets are the right ad-composition surface.
Strategists draft copy. Creative teams add file links. Account managers add UTMs. Sheets handle this workflow natively — comments, version history, named ranges, conditional formatting. It\'s where your briefs already live. Bulk Ad Upload reads the sheet directly so the brief becomes the launch.
The standard column layout.
Seven columns. One row per ad. Custom column mapping if your sheet uses different headers.
| Ad Name | Primary Text | Headline | Landing Page | 1:1 | 4:5 | 9:16 |
|---|---|---|---|---|---|---|
| Spring_UGC_01 | Real reviews from happy customers | Try risk-free for 30 days | site.com/ugc-1 | 🎬 | 🎬 | 🎬 |
| Spring_Studio_01 | Premium quality, made to last | Shop the spring drop | site.com/studio-1 | 🖼 | 🖼 | 🖼 |
| Promo_BankHoliday | Bank holiday only — 25% off | Use code MAY25 | site.com/promo | 🎬 | 🎬 | 🎬 |
| Anthems_Female | The night out everyone's talking about | Book the Anthems experience | site.com/anthems | 🎬 | 🎬 | 🎬 |
Ad Name
The name as it appears in Ads Manager. Naming conventions are your friend — we don\'t enforce one.
Primary Text
The body copy above the creative. One row per variation; we keep them paired correctly.
Headline
The bold headline below the creative. Limited to Meta\'s 40-character recommended length but not enforced.
Landing Page
The destination URL. Auto-prepends https:// if missing.
1:1 / 4:5 / 9:16
Drive file links, Meta video IDs, or hashes from previous uploads. Multi-placement video assembled when 2+ ratios are present.
CTA (optional)
LEARN_MORE, SHOP_NOW, BOOK_TRAVEL, etc. Defaults to LEARN_MORE if blank.
Three steps from sheet to launched ads.
- 1
Share your sheet
Set the sheet to "Anyone with the link can view" or share it with our service account. We only need read access.
- 2
Paste the URL
Hit Import in the app, paste your Google Sheet URL, pick the tab. We pull every row and resolve every Drive link in the background.
- 3
Launch
Pick the destination ad set, click launch. Watch the rows turn green as ads land in Meta.
Drive links resolve themselves.
Most agencies store creative in Google Drive. We accept any Drive sharing link directly in the creative cells — file/d/id, open?id=id, drive.usercontent.google.com download links, all of it. We connect once via Google OAuth, then fetch the file server-to-server, upload to Meta, wait for video processing, and stash the resulting Meta hash or video ID on the ad row. Re-using the same Drive file across rows hits the cache instead of re-uploading.
Frequently asked questions
Your brief is already in a sheet.
Skip the manual transcription. Paste the URL and launch.