The Scenario
You are a performance marketer. You have a briefing workbook 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 ten separate times
- Click through objective selection, naming, budget configuration, and confirmation dialogs for each one
- You are still in Ads Manager at 6 PM.
One prompt from inside the workbook and you are done before the end of the day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads a briefing table and creates Meta Ads campaigns directly through the API, writing the resulting campaign IDs back into the workbook as confirmation.
Open the SheetXAI sidebar and type:
For each row in this workbook, 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, and writes the campaign IDs into column D. When column D has ten IDs, 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
- Daily budget — set in the account currency
Column D is your audit trail. If anything fails, the row that failed shows an error message instead of an ID. You know exactly which campaign to investigate without opening Ads Manager.
The campaign IDs in column D are also the input for the next step: one more prompt reads those IDs and builds ad sets from columns E and F.
What If the Data Is Not Quite Ready
Campaign briefing workbooks are rarely launch-ready on the first read.
When objective values use plain English instead of API codes
The briefing workbook says "conversions" and "traffic" in lowercase. The API expects "CONVERSIONS" and "TRAFFIC."
Read the objective from column A for each row. Normalize it to the Meta Ads API objective code (uppercase, map "conversions" → "CONVERSIONS," "traffic" → "TRAFFIC," "awareness" → "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 — left for approval later.
For each row, create a Meta Ads campaign using objective in column A, name in column B, and daily budget in column C. 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 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 be scheduled.
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 workbook is the brief, the workbook is the audit trail, and the workbook 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 workbook 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 an Excel workbook or the Meta Ads in Excel overview.