From ChatGPT Ads to Google Sheets: managed, scheduled, no code.
Creating a pipeline that sends data from ChatGPT Ads to Google Sheets spreadsheets takes only a few minutes with Kondado. And the whole integration from ChatGPT Ads to Google Sheets is managed and executed by our platform. With Kondado, you can focus on extracting value from ChatGPT Ads data and combining it with other data in your Google Sheets spreadsheet
You can send ChatGPT Ads data to Google Sheets by connecting your OpenAI Ads account to Kondado and choosing Google Sheets as your destination. Kondado pulls performance metrics, campaign registries, and creative assets from ChatGPT Ads through direct pipelines and loads them into your spreadsheet on a configurable schedule. You select the exact pipelines you need, map each one to specific sheets, and define how frequently the data refreshes, whether every five minutes, hourly, or daily.
Once your data lands in Google Sheets, you can build custom reports, blend spend figures with other marketing channels, and share updated views with stakeholders without manual exports. Analysts use the replicated datasets to monitor CTR, ROAS, and conversion trends directly inside a familiar spreadsheet environment.
Kondado is a platform that replicates ChatGPT Ads data to Google Sheets automatically on a configurable schedule, offering eight pipelines and 144 fields covering ads, campaigns, ad groups, performance metrics, conversion events, custom audiences, ad previews, and account details.
With the Ad performance pipeline, you can pull hourly or daily metrics into Google Sheets to track impressions, spend, CTR, and ROAS across campaigns, ad groups, and individual ads. The Campaigns pipeline delivers budget limits, bidding strategies, and targeting countries, making it easy to build pacing dashboards and monitor delivery without switching platforms. You can also combine the Custom audiences pipeline with conversion event settings to analyze match rates, audience health, and attribution windows alongside performance data, giving you a complete view of funnel metrics inside a shared spreadsheet.
Try out all the features for free for 14 days
Replicated to Google Sheets
ChatGPT Ads data available for Google Sheets
Tables Kondado writes into your Google Sheets, on a schedule you control.
8
available pipelines
144
extractable fields
Google Sheets
Destination
Available integrations
Ads
Registry of the account's ads, with the parent ad group and campaign, status and review outcome, creative format and copy (headline, body, price and destination URL with tracking parameters), and the reasons an ad is not serving.
Campaigns
Registry of campaigns, with objective, bidding strategy, billed event, start and end windows, daily and lifetime spend limits in the account currency, product catalog, and countries included in targeting.
Conversion event settings
Conversion events configured on the account, with type, the sources that feed them (pixels or integrations), associated campaigns, and the click-through and view-through attribution windows.
Ad account
Details of the connected ad account: name, main website, status and review, the time zone that defines how report days are cut, and the currency every monetary value in this connector is expressed in.
Ad groups
Registry of ad groups, with the parent campaign, status, context signals used for targeting, associated product feed, bidding strategy, billed event, and maximum bid in the account currency.
Ad performance
Performance report grouped by hour, day or month at account, campaign, ad group or ad level, with impressions, clicks, spend, CTR, CPC, CPM, conversions, CPA, ROAS and attributed sales, plus breakdowns by product, country, device or platform.
Ad preview
Renderable preview of each ad: an HTML snippet with the creative's iframe and the moment the preview was generated — the address inside the iframe expires 24 hours later.
Custom audiences
Registry of custom audiences, with status, hash specification version, and the ranges of uploaded, matched and invalid identifiers — for privacy the API returns text ranges, never the exact count.
Sync data automatically — no code, no manual exports.
1
Connect ChatGPT Ads
In Kondado, add ChatGPT Ads as a new data source and authenticate with your OpenAI Ads credentials to grant access to your account's campaigns and performance data.
2
Configure Google Sheets destination
Choose Google Sheets as your destination, select the target workbook, and define which sheet tabs will receive each pipeline so your data lands exactly where you need it.
3
Select pipelines and schedule
Pick the pipelines you want to replicate, such as Ad performance or Campaigns, and set your update frequency to run every five minutes, hourly, or daily based on your reporting needs.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending ChatGPT Ads data to Google Sheets automatically
How do I connect ChatGPT Ads to Google Sheets using Kondado?▼
Start by adding ChatGPT Ads as a data source in Kondado and authenticating your OpenAI Ads account. Then choose Google Sheets as your destination, pick the pipelines you want, and set your preferred update schedule. Kondado handles the replication automatically so your spreadsheet stays current without manual CSV exports.
What ChatGPT Ads metrics can I pull into Google Sheets?▼
You can replicate 144 fields across eight pipelines, including impressions, clicks, spend, CTR, CPC, CPM, conversions, CPA, and ROAS from the Ad performance pipeline. The Campaigns pipeline brings budget caps and bidding strategies, while the Ad account pipeline provides time zone and currency context for every monetary value. This lets you build custom reports that match your exact analysis needs.
How often does ChatGPT Ads data refresh in Google Sheets?▼
Kondado updates your spreadsheet on a configurable schedule that you control, with options ranging from every five minutes to daily intervals. You choose the frequency when setting up each pipeline, and you can adjust it later as your reporting needs evolve. This keeps your Google Sheets data aligned with your operational rhythm without overwhelming your workflow.
Does ChatGPT Ads data come in as structured rows inside Google Sheets?▼
Yes, each pipeline delivers structured rows with defined columns that map directly to fields from the OpenAI Ads API, such as campaign names, spend values, and audience match ranges. Because the data lands in standard spreadsheet cells, you can immediately apply filters, pivot tables, and formulas to analyze performance. This structure makes it simple to connect your sheet to Looker Studio or Power BI for deeper visualization.
Can I combine ChatGPT Ads data with other marketing sources in the same Google Sheet?▼
Absolutely, you can replicate data from multiple sources into separate tabs of the same workbook and unify them with spreadsheet formulas or lookup functions. For example, blend spend from ChatGPT Ads with revenue from your CRM or web analytics to calculate true cross-channel ROAS. If your dataset grows large, you can also send the combined data to BigQuery or PostgreSQL for more advanced modeling.
What is the difference between the Ads pipeline and the Ad performance pipeline?▼
The Ads pipeline is a registry that lists every creative in your account along with its headline, body copy, destination URL, status, and review outcome. The Ad performance pipeline contains the actual metrics, showing how those creatives perform across hours, days, or months with breakdowns by product, country, device, or platform. Together they let you correlate creative attributes with results directly inside Google Sheets.
Can I send ChatGPT Ads data to a database instead of Google Sheets?▼
Yes, while Google Sheets is ideal for quick collaboration and lightweight analysis, Kondado can also replicate the same ChatGPT Ads pipelines to destinations like BigQuery, PostgreSQL, MySQL, Redshift, SQL Server, or Amazon S3. This flexibility lets you start in a spreadsheet for immediate stakeholder reviews and later scale to a warehouse as your data volume increases.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
