The Scenario
You are a performance marketer. You have a briefing sheet with 10 new product promotion campaigns to launch — each row has the campaign name, objective, and daily budget. The campaigns need to be live before the product launch email goes out on Thursday at 10 AM.
It is Tuesday afternoon.
The bad version of Tuesday:
- Open Ads Manager, click Create Campaign
- Choose the objective, type the name, set the budget
- Navigate to the next screen, configure the ad set, save
- Go back to the campaign list, click Create again
- Repeat ten times
- Click through the confirmation dialogs for each one
- You are still in Ads Manager at 6 PM.
One prompt from inside the sheet and you are done before the end of the day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that can read a briefing table and create Meta Ads campaigns directly through the API, writing the resulting campaign IDs back into the sheet as confirmation.
Open the SheetXAI sidebar and type:
For each row in this sheet, create a Meta Ads campaign using the objective in column A, name in column B, and daily budget in column C. Write the created campaign ID back into column D.
SheetXAI reads the ten rows, calls the Meta Ads API once per row, creates each campaign with the specified objective and budget, and writes the campaign IDs into column D. When you see ten IDs in column D, the campaigns exist in Meta Ads.
What You Get
Ten live Meta Ads campaigns, each confirmed:
- Column D — the Meta Ads campaign ID for each row
- Campaign name — exactly as written in column B
- Objective — mapped to the Meta Ads API objective type (CONVERSIONS, TRAFFIC, AWARENESS, etc.)
- Daily budget — set in the account currency
Column D is your audit trail. If anything fails, the row that failed will have an error message instead of an ID. You know exactly which campaign to investigate without logging into Ads Manager.
The campaign IDs in column D are also the input for the next step: creating ad sets. One more prompt reads those IDs and builds the ad sets from columns E and F.
What If the Data Is Not Quite Ready
Campaign briefing sheets are rarely launch-ready on the first read.
When objective values in the sheet use plain English instead of API codes
The briefing sheet says "conversions" and "traffic" in lowercase. The Meta Ads API expects "CONVERSIONS" and "TRAFFIC."
Read the objective from column A for each row. Normalize it to the Meta Ads API objective code (convert to uppercase, map "conversions" to "CONVERSIONS," "traffic" to "TRAFFIC," "awareness" to "BRAND_AWARENESS"). Then create the campaign and write the campaign ID to column D.
When some rows are missing a daily budget
A few rows have no budget specified — they were left for approval later.
For each row, create a Meta Ads campaign using column A (objective), column B (name), and column C (daily budget). If column C is blank, skip that row and write "MISSING BUDGET — SKIPPED" into column D. Create campaigns for all rows that have a budget.
When you also want to create the ad sets in the same pass
The campaign IDs from step one are immediately used to build ad sets from the next set of columns.
For each row, create a Meta Ads campaign using objective in column A, name in column B, and daily budget in column C. Write the campaign ID to column D. Then, using the campaign ID just created, create one ad set using the targeting parameters in column E and the ad set daily budget in column F. Write the ad set ID into column G.
When the brief specifies start and end dates per campaign
The product launch has a defined promotion window. Each campaign should have a scheduled start and end.
For each row, create a Meta Ads campaign using column A (objective), column B (name), column C (daily budget), column D (start date in YYYY-MM-DD format), and column E (end date). Schedule each campaign to run only within the specified dates. Write the campaign ID into column F.
The pattern: the sheet is the brief, the sheet is the audit trail, and the sheet is the input for every subsequent step. You never open Ads Manager.
Try It
Get the 7-day free trial of SheetXAI and ask it to create Meta Ads campaigns from any briefing sheet you have open. The Meta Ads integration is included in every SheetXAI plan. For related work, see how to do bulk status updates and budget changes from a sheet or the Meta Ads in Google Sheets overview.