# Overview This guide explains how to use the **Triple Whale Data-In for Google Sheets** template to upload **Products**, **Subscriptions**, **Ads**, and **Post-Purchase Survey** data directly to Triple Whale without writing any code. With the Google Sheet Data-In Template, you can: * **Upload multiple data types manually:** Send Products, Subscriptions, Advertising, and Survey data to your Triple Whale workspace. * **Bypass coding requirements:** The sheet is pre-configured with a built-in script that sends your data through the API, no technical setup required. * **Validate before sending:** Catch formatting issues or missing fields with the built-in validation tool. * **Check responses in logs:** Each submission generates a detailed log in the `TW_Logs` tab so you can confirm success or review any errors. To automate this process, you can also use the [Data-In API endpoints](https://triplewhale.readme.io/reference/create-ad-record) directly. *** # Prerequisites Before you begin, make sure you have: * **A Triple Whale Account with API Access:** You’ll need to generate an API Key with write permissions for the endpoints you plan to use. See [Creating and Managing API Keys](https://triplewhale.readme.io/reference/creating-and-managing-triple-whale-api-keys#/) for details. * **A Google Account:** Any account works; using a dedicated service account is recommended for security. * **Your Data:** Prepare your Products, Subscriptions, Ads, or Survey data — either exported from your systems or formatted manually following the sample structure in each template. *** # Step 1. Copy the Template 1. Open the Google Sheet Data-In Template. 2. In Google Sheets, click **File > Make a copy**. The original version is view-only — you must make your own copy before editing.

3. Rename your copy (e.g., “Upload Data to Triple Whale”) and click **Make a copy**. *** # Step 2. Configure Your API Connection 1. In the menu bar, click **Triple Whale → Configure**. (First time only: Click **OK** to authorize the script to run, sign in to your Google account, and grant the requested permissions.)

2. Enter your **Store URL** (e.g., `myexampleshop.com`) and your **API Key** (see [Creating and Managing API Keys](https://triplewhale.readme.io/reference/creating-and-managing-triple-whale-api-keys#/).)

3. Click **Save**. *** # Step 3. Create a Template 1. In the Google Sheet menu, click **Triple Whale → Create Template**.

2. Choose which endpoint you want to send data to: [Products](https://triplewhale.readme.io/reference/create-product-record#/), [Subscriptions](https://triplewhale.readme.io/reference/create-subscription-record#/), [Ads](https://triplewhale.readme.io/reference/create-ad-record#/), or [PPS (Post-Purchase Survey)](https://triplewhale.readme.io/reference/create-pps-record#/)).

3. Click **Create Template**. A new sheet will be generated automatically, pre-formatted with the correct columns for the chosen endpoint. Required fields are highlighted in red. *** # Step 4. Add and Validate Your Data 1. In the template sheet created in Step 3, replace the sample row with your actual data. Keep IDs and phone numbers as text, and use ISO 8601 date format (e.g., `2025-01-01T00:00:00Z`). Columns with red backgrounds are required fields. > 📘 Date time zones > > Google Sheets uses the spreadsheet's time zone for date and time behavior. If your upload includes date values without an explicit time zone offset, click **File > Settings**, then set **Time zone** to match the dates in your upload data before adding date values.

2. In the menu bar, click **Triple Whale → Validate Active Sheet** to check for missing or incorrectly formatted fields. Validation results will appear instantly, so you can fix any issues before sending data.

> ✅ Best Practice: Start with a few rows (5–10) for your first test upload. *** # Step 5. Send Data to Triple Whale 1. Once your data is ready and validated, click **Triple Whale → Send All Rows** (or **Send Selected Rows** to send a subset).

2. The script will process your rows and send them to Triple Whale’s API. Open the `TW_Logs` sheet to view results, including success confirmations or error messages for each row.

*** # Step 6. Confirm Your Data in Triple Whale ### Processing Time New data typically appears in your Triple Whale workspace within 5 minutes. Large or historical uploads may take up to 30 minutes. Once your upload is complete, you can query the data in the Triple Whale app using the [SQL Builder](https://app.triplewhale.com/sql-editor). Each record will appear in the appropriate table: * [Products](https://triplewhale.readme.io/docs/products-table#/) * [Ads](https://triplewhale.readme.io/docs/ads-table#/) * [Subscriptions](https://triplewhale.readme.io/docs/subscriptions-table#/) * [Post-Purchase Survey](https://triplewhale.readme.io/docs/post-purchase-survey-table#/) *** # Step 7. 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. 1. In the top menu of your Google Sheet, go to **Extensions > Apps Script**.

2. In the Apps Script Editor, select **Triggers** from the left sidebar.

3. Click **+ Add Trigger**. 4. Configure the new trigger using the following settings:

* **Choose which function to run:** `sendAllRowsWithProgress` * **Choose which deployment should run:** `Head` * **Select event source:** `Time-driven` * **Select type of time-based trigger:** The timing you want the function to run. * **Failure notification settings:** The frequency you want to be notified of script errors. 5. 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.