❗️
This Google Sheet Template version has been deprecated. Use the updated and expanded Google Sheets Data-In Template instead.

Overview

This guide explains how to use a pre-built Google Sheets template to manually 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.

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

📘
Note
The Google Sheet template provided in this guide can also be adapted for use with any of the Data-In endpoints.

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

Open the Google Sheet Ads Data In Template.
In Google Sheets, click File > Make a copy.
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

Navigate to Settings > API Keys in your Triple Whale account to generate an API key with the required Ads: Write scope selected.
Paste your API key into the designated cell in your copied Google Sheet.
For more information on API key creation and management, refer to the API Keys Documentation .

Step 3. Enter Your Ads Data

Fill in Channel Details: Ensure the “channel” field matches the UTM parameters on your Pixel page for correct data attribution.
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

In your copied Google Sheet, open the API Tools menu (top right) and click Send Ad Data to Triple Whale.
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.
Once authorized, the script will run and display a confirmation message with the number of days of data uploaded.
Subsequent runs won’t require reauthorization.

Step 5. Automate Data Uploads (Optional)

You can set your Google Sheet to automatically run uploads to Triple Whale on a schedule using Google Apps Script triggers.

In the top menu of your Google Sheet, go to Extensions > Apps Script.
In the Apps Script Editor, select Triggers from the left sidebar.
Click + Add Trigger.
Configure the new trigger using the following settings:
- Choose which function to run: sendApiRequest
- Choose which deployment should run: Head
- Select event source: Time-driven
- Select type of time-based trigger: Whenever you’d like the upload to occur
- Failure notification settings: However often you’d like to be notified of script errors
Click Save.

Once saved, the sheet will automatically upload your data to Triple Whale on the schedule you’ve configured.

🚧
Important
Scheduling only re-runs the sheet submission — it does not fetch new data automatically.
To truly automate ongoing uploads, make sure your sheet is populated by another process (e.g., a Zapier flow, export script, or data feed) so the scheduled trigger sends fresh data rather than re-exporting the same rows.