Data Dictionary
Start typing to search…

Upload Ads Data Using Google Sheets

Overview

This guide explains how to use a pre-built Google Sheets template to upload your ads spend data to Triple Whale via the Data-In API. With the Google Sheet Ads Data In Template, you can easily:

  • Upload data manually from non-integrated sources: Use CSV exports or manual entry from any advertising platform.
  • Ensure complete data: Incomplete data can lead to skewed results. For example, when running Marketing Mix Modeling, having all your spend data (rather than just a partial view) is essential for accurate attribution.
  • Bypass coding requirements: The Google Sheet is pre-configured with a script to send your data via API, so you don’t need to write any code.

📘

Note:

To automate the upload process, use the /create-ad-record API endpoint instead.

Prerequisites

Before you begin, make sure you have:

  • A Triple Whale Account with API Access: Access to your Triple Whale account where your ads data will be processed. You must have access to generate an API Key.
  • A Google Account: Use your regular account or a dedicated/service account for enhanced security.
  • Your Ads Spend Data: Data can be in CSV format or exported from your ad platform, ready to be pasted into the sheet.

Step 1. Copy the Template

  1. Open the Google Sheet Ads Data In Template.

  2. In Google Sheets, click File > Make a copy.

  3. Rename your copy (e.g., “Triple Whale Ads Data Upload”) and click Make a copy.

Step 2. Obtain Your API Key And Paste it Into the Google Sheet

  1. Navigate to Settings > API Keys in your Triple Whale account to generate an API key with the required Ads: Write scope selected.

  2. Paste your API key into the designated cell in your copied Google Sheet.

  3. For more information on API key creation and management, refer to the API Keys Documentation .

Step 3. Enter Your Ads Data

  1. Fill in Channel Details:
    Ensure the “channel” field matches the UTM parameters on your Pixel page for correct data attribution.
  2. Input Your Data:
    Manually enter your ads data (e.g. spend, clicks, impressions) or copy and paste it from a CSV export. For more details which fields are available for upload, refer to the Ads Data-In Documentation.

Step 4. Authorize and Run the Script

  1. In your copied Google Sheet, open the API Tools menu (top right) and click Send Ad Data to Triple Whale.

  2. Authorize the Script (First-Time Only): A pop-up will request permissions (including managing your Google Drive files); this permission is required for the script to run the API call. Use a dedicated service account for enhanced security.

  3. Once authorized, the script will run and display a confirmation message with the number of days of data uploaded.

  4. Subsequent runs won’t require reauthorization.