Hermoso connects to Apple Search Ads and exposes it as tools any MCP
client can call — Claude, ChatGPT, Cursor, Codex, Cline or the CLI. apple_ads_report pulls
campaign, ad group, keyword and search-term performance, and the rows come back as data rather than a CSV
download you then have to shepherd somewhere.
Where the rows can go
Written for you: Google Sheets (create_sheet, append_to_sheet),
Google Docs, Google Drive and OneDrive. Ask for a weekly report and it lands in a spreadsheet you already
own, on a schedule, without an ETL tool in between.
Everywhere else — BigQuery, Looker Studio, Power BI, Redshift, PostgreSQL, Excel, Qlik, Monday.com, plain JSON: Hermoso has no native connector for these, and we would rather say so than imply one. What it does have is the data in a shape your agent can act on, so the agent writes it wherever it can already reach. If your warehouse is reachable from the tool your agent runs in, this is a two-step job rather than a pipeline.
What else the connection does
Reporting is one of the Apple Search Ads tools (43 today). The rest build and run the account: campaigns, ad groups, keywords and negatives, creative sets, budget orders, geo and language targeting, keyword and CPA suggestions, impression share, search-term popularity and change history. See the Apple Ads channel page for the full list.
Connecting
Open the app, go to Workspace ▸ Connectors and connect Apple Ads. One authorisation covers the web app, the MCP server and the CLI.
Frequently asked questions
Can Hermoso export Apple Search Ads data to BigQuery or Looker Studio?
Not with a native connector, and we will not pretend otherwise. Hermoso pulls the report through the Apple Search Ads API and hands your agent the rows; the agent writes them wherever it can reach. Google Sheets, Docs, Drive and OneDrive are written directly.
Is there an Apple Search Ads reporting API?
Yes, and Hermoso is built on it. apple_ads_report covers campaign, ad group, keyword and search-term performance, and the rest build and manage the account.
Do I need a developer to set this up?
No. Connect Apple Ads once in the app, then ask your agent in plain language — "pull last week by keyword and put it in a sheet".