Free Criteo Ads to Google Sheets Connector by OWOX: See the Full Picture of Your Performance Data

Running Criteo Ads is simple. Accessing raw, usable data for reporting? That’s where things get tricky.

If you’ve ever tried to analyze your Criteo campaign data, you know the hurdles: outdated CSV exports, missing fields, or expensive tools that limit your access and flexibility.

That changes now.

With this free, no-code connector from OWOX Data Marts (Community Apps Script Edition), you can transfer detailed Criteo Ads data into Google Sheets quickly, securely, and without hidden costs. 

Best of all? You own the data, not the platform.

Why We Made This Free Connector

Criteo offers powerful performance advertising tools, but accessing its raw data for custom analysis often feels unnecessarily complex.

At OWOX, we believe marketers should never have to wrestle with CSV exports or overpay for rigid analytics tools just to access their data. That’s why we built this free Criteo Ads connector as part of the OWOX Data Marts (Community Apps Script Edition).

No subscriptions. No locked features. Just open, flexible access to your ad campaign data in Google Sheets, where you can work with it.

Whether you’re optimizing retail campaigns, analyzing return on ad spend, or building dashboards across platforms, this connector gives you full control over what data you pull and how you use it.

Join the Open-Source Movement

We’re not just releasing a free connector, we’re inviting you to help shape the future of open marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source, giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors and / or documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation; now it’s your turn to take it further.

Why Bring Criteo Ads Data into Google Sheets?

Criteo Ads offers marketers advanced retargeting and commerce-focused ad campaigns; however, it’s not designed for flexible analysis or sharing. That’s where this connector unlocks a major advantage.

❌ You’re stuck inside the Criteo dashboard with rigid filters and static exports
❌ There’s no simple way to compare Criteo's performance with data from Google Ads or Facebook
❌ Existing reporting tools often lack transparency or charge per account, field, or update

✅ With Google Sheets, you take full control: explore campaign data your way, without preset constraints
✅ Blend Criteo insights with performance data from analytics tools, product feeds, or CRM systems
✅ Build and share custom reports with your team – no special tools or logins needed

Connecting Criteo Ads to Google Sheets with this free OWOX connector means fewer restrictions, better visibility, and zero vendor lock-in.

Google Sheets

Data sources

Free Criteo Ads Connector to Google Sheets

Download template

Why Choose OWOX Free Connector for Criteo Ads to Google Sheets

Most Criteo-to-Sheets solutions come with compromises: limited field access, premium upgrades, or rigid platforms that restrict your options. The OWOX connector takes a different path, built for marketers and analysts who want full ownership, without friction.

Here’s what sets it apart:

• Designed specifically for Criteo Ads – with full control over your start dates, account IDs, objects, and reporting fields
• Runs entirely on Google Apps Script – no third-party platforms, subscriptions, or hidden services involved
• Includes support for automatic refreshes and incremental data loading – perfect for tracking campaign performance over time
• Handles token expiration, API limitations, and cleanup intelligently – fewer errors, smoother workflows
• Fully open-source and community-driven – powered by OWOX Data Marts (Community Apps Script Edition) so you can inspect, adapt, and improve it on your terms.

If your goal is to build a transparent, scalable Criteo reporting workflow, without code, fees, or surprises, this is the connector that finally delivers.

Check out our other free connectors:
Already enjoying custom Criteo reporting? You can also connect:
‍
Criteo Ads → BigQuery
Microsoft Ads → Google Sheets
LinkedIn Ads → Google Sheets
Facebook Ads → Google Sheets
‍
No subscriptions. No coding. Just smarter workflows across your ad stack.

How the Connector Works

At OWOX, we designed this connector to give you complete control over your Criteo Ads data, without relying on external tools or paid platforms. 

Built with analysts and marketers in mind, it runs entirely inside Google Sheets and is powered by OWOX Data Marts (Community Apps Script Edition).

Here’s how it works under the hood:

• Built with native Google Apps Script – no additional setup, platforms, or installations required.
• Connects directly to the Criteo API using your developer credentials – no third-party proxies or gateways.
• Fetches raw data for all supported objects: campaigns, creatives, and performance metrics – not just summaries.
• Supports authenticated requests with automated token handling – so you don’t need to reauthorize manually every day.
• Includes a cleanup module to remove expired data safely, keeping your spreadsheet lean and your reports focused.

You get full visibility into the code, logic, and structure – and the freedom to modify or extend it for your team’s unique reporting needs.

It’s not just a connector, it’s a foundation for building your own lightweight, transparent Criteo data pipeline, inside the tool you already use every day.

💡 Follow along with this video to connect your Criteo Ads account to Google Sheets using OWOX. It’s a quick and clear walkthrough for setting up your first data sync.

Step-by-Step: Import Criteo Ads Data to Google Sheets

In just a few quick steps, you can start pulling structured Criteo Ads data into Google Sheets, no manual exports, no coding, and no third-party platforms.

Let’s walk through the setup:

Step 1: Copy the Google Sheets Template ( ~1 min)

To streamline the setup process, use our pre-configured Google Sheets template – no need to build from scratch.

1. Access the Template

• Open the “Criteo → Google Sheets. Template” from OWOX.
  
  

2. Create a Personal Copy
   
   • Go to File → Make a copy to save it to your Google Drive.

Master Criteo Ads → Google Sheets Reporting With Our Free Template!

Say goodbye to CSV exports and complex APIs – this plug-and-play Google Sheets template lets you pull Criteo Ads data effortlessly.

Download your FREE template today!

Step 2: Configure the Template ( ~1 min)

Set up your desired parameters for importing Criteo Ads data, it takes just a few clicks.

1. Set the Start Date

On the Config sheet, choose when data collection should begin.

Note: Selecting a long date range may prevent data from downloading due to volume limits.

2. Add Your Criteo Advertiser ID

• Find your Advertiser ID on the homepage of your Criteo Ads account, then 

• Paste it into the Advertiser ID field in the template.

3. Select the Fields to Import

•  To include specific metrics and dimensions in your report, navigate to the Fields tab in the template.
• Check the boxes next to the fields you want to import from your Criteo Ads account. 

These fields help track the traffic source in downstream analytics.

Further, Specify the Fields with the Following Parameters:

• Destination Spreadsheet: Leave blank to load data into the currently open spreadsheet.
• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31)
  

Step 3: Get Your Criteo Access Token ( ~1 min)

To authorize your connector and fetch data from Criteo Ads, you’ll need to generate an access token using your Criteo developer account.

1. Log In to Criteo Partners

• Visit  https://partners.criteo.com 

• Sign in with your Criteo Ads credentials.

‍

2. Create a New App

• Click the ➕ icon in the My Apps section or 
• Hit “Create a new app” to start the setup.

3. Set the Application Name

• Enter a recognizable name like: OWOX (open source connector)
• Optionally add a short description to help identify it later.
  Tip: Use a clear name to simplify troubleshooting or team collaboration.

• Click Next.

‍

4. Choose the Authentication Method

• Select  Client Credentials as the method of authentication for the app.

5. Assign the Right Service

• Under Service, choose: C-Growth and marketing solutions.

6. Set Required Permissions

Check the following permissions to enable full access to reporting data:

• Analytics – Read
• Campaigns – Read
• Creatives – Read

Note: You won’t be able to edit these settings once the app is activated.

• Click Activate app to proceed with the setup.

7. Generate Your API Keys

• Click Create new key. 

• After that:
  
  • Download a .txt file containing your client_id and client_secret.
  • Store these credentials securely,  you’ll need them during setup.
    

8. Grant Consent

• Click  Generate new URL → Copy the Consent URL

•  Paste it into your browser.
•  Follow the prompts to grant access to the app.

Once access is granted, you now have everything you need to proceed.

• Client ID
• Client Secret
• App authorization

Step 4: Input Access Token into the Template ( ~10 seconds)

Once you've generated your Criteo credentials, it’s time to connect them to the template.

1. Open the Credentials Menu

• In your Google Sheet, go to the top menu → OWOX → Manage credentials.

2. Add Your Credentials

• Paste the client_id and client_secret from the Criteo developer portal into the prompt that appears.
• Click  Save.

You’re now ready to start importing your Criteo Ads data into Google Sheets.

Step 5: Run the Connector & Import Your Data ( ~1 min)

With your credentials set, you’re ready to bring Criteo Ads data into your spreadsheet.

1. Start the Import

• Go to the top menu → OWOX → Import New Data.

2. Monitor the Logs

• Check the Logs tab. Once the message "Import is finished" appears, your data has been successfully retrieved.

• Your structured Criteo Ads data will appear in a new tab labeled Statistics.

3. To Include More Fields or Change the Date Range

• Go to the Fields tab, check additional boxes, and click OWOX → Import New Data.
• To update the date range, clear the Status columns, set new dates, and run Import New Data again.

📊Real-Time Visualization with OWOX BigQuery Data Marts

Getting your Criteo Ads data into Google Sheets is just the start. The real value shows up when you start analyzing it, in seconds, not hours.

With the OWOX BigQuery Data Marts, you can instantly transform your raw Criteo campaign data into clean pivot tables and charts. No manual formatting. No clunky formulas. Just fast, flexible insights,  ready when you are.

Use OWOX AutoCharts to:

📊 Build pivot tables and visual reports in 1 click

📈 Track Criteo Ads performance by campaign, creative, or device

🔍 Identify trends, outliers, and budget leaks across audience segments

🔁 Refresh visualizations automatically as new data is imported

Whether you're optimizing bids, monitoring conversions, or comparing creatives, OWOX AutoCharts makes it easy to stay on top of your Criteo Ads performance.

What’s Next?

This free Criteo Ads to Google Sheets connector is another step toward making marketing data ownership practical, accessible, and transparent.

Explore other resources here:

🔗 More free connectors – including Twitter Ads and LinkedIn Pages Connectors for Google Sheets and many more.
🎥 Step-by-step video walkthroughs – to help you set up and troubleshoot with ease
📊 Prebuilt dashboard templates – to speed up insights and performance tracking.

Explore the full list of tools on our GitHub repo, drop us a ⭐ star, and help shape the future of open analytics with OWOX Connectors.

Google Sheets

Data sources

Free Criteo Ads Connector to Google Sheets

Download template