The Scenario
You are an agency operations manager. Every quarter you do an account audit: which client ad accounts are active, which are paused, which client pages are still associated with the Business Manager. The audit feeds into billing reconciliation — you charge clients based on which accounts were active.
The Q2 audit is due Friday. It is Wednesday morning and you have 20+ client ad accounts and an unknown number of associated pages under the Business Manager.
The bad version of Wednesday:
- Log into Meta Business Manager
- Click through the Business Settings to find the client ad accounts list
- Manually copy account names, IDs, and statuses into a spreadsheet row by row
- Navigate to Pages, do the same for client pages
- Realize some accounts have sub-accounts you did not know about
- Spend Thursday reconciling the spreadsheet against the billing system
- The audit is technically done but you are not confident it is complete.
One prompt from inside the sheet pulls the complete account inventory.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that can query Meta Business Manager through the API, so you get a complete client account and page inventory without clicking through Business Settings.
Open the SheetXAI sidebar and type:
List all client ad accounts under our Meta Business Manager and write client business name, ad account name, ad account ID, and account status into columns A through D of this sheet. Sort by account status so ACTIVE accounts appear first.
SheetXAI queries the Business Manager API, retrieves every client ad account with its metadata, and writes them sorted by status. The billing team has a complete active account list before the end of Wednesday.
What You Get
A complete client ad account inventory:
- Column A — client business name
- Column B — ad account name
- Column C — ad account ID
- Column D — account status (ACTIVE, DISABLED, etc.)
- Sorted by status — active accounts at the top for billing reconciliation
The account IDs in column C are what billing needs. Not names — IDs. Names change, IDs do not. This sheet is the source of truth that the billing reconciliation runs against.
What If the Data Is Not Quite Ready
Business Manager inventories have layers.
When you also need the associated client pages in a second tab
The audit covers both ad accounts and pages. They belong in separate tabs.
Fetch all client ad accounts under our Meta Business Manager and write business name, ad account name, ad account ID, and status into the 'Ad Accounts' tab. Then fetch all client pages and write page name, page ID, and category into the 'Pages' tab. Create both tabs if they do not exist.
When you want to flag accounts that have been inactive for more than 90 days
Some accounts are technically ACTIVE but have had no spend in months.
List all client ad accounts under our Meta Business Manager. Write business name, ad account name, ad account ID, and status into columns A through D. Then for each ACTIVE account, fetch the total spend for the last 90 days and write it into column E. In column F, write 'no recent spend' if column E is zero.
When the audit needs to include owned pages separately from client pages
The agency has its own pages alongside client pages. They should be listed separately.
Fetch all pages associated with our Meta Business Manager. In column A write the page name, in column B the page ID, in column C the category, and in column D write 'owned' if it is a page the agency owns or 'client' if it belongs to a client. Sort by column D so owned pages appear first.
When the full audit combines accounts, pages, spend data, and billing flags in one sheet
The complete quarterly audit in one prompt — account inventory, spend data, and billing flags all at once.
List all client ad accounts under our Meta Business Manager with business name, ad account name, account ID, and status in columns A through D. For each account, fetch total spend for the last 90 days and write it in column E. In column F, write 'BILL' if status is ACTIVE and spend is above zero, 'REVIEW' if status is ACTIVE but spend is zero, and 'INACTIVE' if status is not ACTIVE. Sort by column F so BILL accounts appear first.
The pattern: the quarterly audit that used to take two days happens in one prompt on Wednesday morning. Friday's reconciliation meeting has real data behind it.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your Meta Business Manager account inventory into any Google Sheet you have open. The Meta Ads integration is included in every SheetXAI plan. For related work, see how to compare performance across all your ad accounts or the Meta Ads in Google Sheets overview.