List ad sheets (`adsap_list_ad_sheets`)

Platform: Meta · Read or write: Read · Plan: All plans · Consumes a task: No · Preview supported: No

What it does

Lists the bulk ad creation sheets that belong to an ad account. Each sheet holds rows of ad configurations built in the Adsap web app. Use it to find a sheet before asking about its structure.

When to use it

Use it to find a sheet and its id before you ask about its columns with adsap_get_ad_sheet_schema.
It returns facts about each sheet, such as its type and row count. It does not return the rows.
Sheets are read-only for the assistant. You create and edit rows in the Adsap web app.
Without ad_account_id, it lists sheets for every ad account connected to your workspace, on Meta and on Google Ads.
Sheets come back newest first. A page holds 20 sheets by default and 100 at most.

Worked example

You ask

“Which ad sheets do I have for act_1234567890?”

The assistant calls `adsap_list_ad_sheets`


{
  "ad_account_id": "act_1234567890"
}

Adsap returns

The field names are the ones Adsap returns. The values are examples.


{
  "ok": true,
  "data": [
    {
      "id": "3f2a9c1e-5b7d-4e8a-9c21-7d4f6a1b2c3d",
      "ad_account_id": "act_1234567890",
      "name": "Spring sale launch",
      "ad_platform": "Meta Ads",
      "sheet_type": "SINGLE_IMAGE_VIDEO",
      "row_count": 12,
      "ad_formats": ["Single Image or Video"],
      "status": "DRAFT",
      "visible_columns": ["display_link", "descriptions"],
      "catalog_id": null,
      "created_at": "2026-03-01T09:30:00+00:00",
      "updated_at": "2026-03-02T14:05:00+00:00"
    }
  ],
  "meta": {
    "next_cursor": null,
    "total_count": 1,
    "ad_account_id": "act_1234567890"
  }
}

How to read it

id is the sheet_id that adsap_get_ad_sheet_schema takes. sheet_type comes from the ad formats of the rows. One format gives that format, several give MIXED, and no rows give EMPTY. status is worked out from the stages of the rows. visible_columns lists the optional columns switched on for the sheet.

For a Google Ads sheet, ad_platform is Google Ads, sheet_type is the campaign type such as SEARCH, and ad_formats is empty. When next_cursor is not null, the assistant passes it as cursor to get the next page.

Parameters

Descriptions are shortened from the tool schema. Your assistant sees the full text.

Name	Type	Required
`ad_account_id`	string	No
`limit`	number	No
`cursor`	string	No

Example prompts

“Which ad sheets do I have for the US account?”
“List my ad sheets and tell me how many rows each one has.”

adsap_get_ad_sheet_schema: Retrieve column schema, constraints, and dependencies for an ad sheet: use it to read or explain a sheet’s structure.

Guide

Read Ad sheets for the workflow around this tool, and the Tool reference for every tool.

The Meta Ads MCP server page shows how to connect Meta Ads to Claude, ChatGPT or Perplexity.

List ad sheets (adsap_list_ad_sheets)