# Google Sheets

## Walkthrough Video: Creating and Syncing to a New Sheets Workbook <a href="#distilled-to-google-sheets-integration-overview" id="distilled-to-google-sheets-integration-overview"></a>

{% embed url="<https://youtu.be/1jEpMm6nn3A>" %}

## Walkthrough Video: Syncing an Additional Audience to an Existing Sheets Workbook <a href="#distilled-to-google-sheets-integration-overview" id="distilled-to-google-sheets-integration-overview"></a>

After you've set up Google Sheets as a Destination within Untitled, adding new Audiences to new tabs within the Google Sheets Workbook can help keep everything organized in a single shareable, downloadable document for your team.

{% embed url="<https://youtu.be/9xy9giz_Ud0>" %}

## Destination Overview <a href="#distilled-to-google-sheets-integration-overview" id="distilled-to-google-sheets-integration-overview"></a>

This user guide will walk you through the process of syncing segmented audiences from your platform to Google Sheets effectively. When configuring Google Sheets as your destination in Untitled, **all audiences will be sent to a** **single Google Sheet**. Each audience will have its own **separate tab within the sheet**.&#x20;

When you set up a new audience to sync with your Google Sheets destination, you'll be asked to create a new tab in the linked Google Sheet file. You'll then need to share the URL link to that specific tab with Untitled to complete the syncing process. We recommend naming each sheet tab with the exact title of the corresponding Untitled audience being synced to that tab.

### Table Structure in Google Sheets <a href="#table-structure-in-google-sheets" id="table-structure-in-google-sheets"></a>

{% hint style="warning" %}
All file types included in your audience filters will be combined into a **single table** in your Google Sheet. See the combined table structure and column order from Untitled to Google Sheets in the next section below.
{% endhint %}

The column titled “match\_type” will indicate whether a lead is B2B, B2C, or PTE. The location of the email field for each lead type is outlined in the table below:

| Lead Type | Email Address Column     | Column Number |
| --------- | ------------------------ | ------------- |
| B2B       | business\_email          | 3             |
| B2C       | personal\_email          | 41            |
| PTE       | email email\_address\_lc | 22            |

<details>

<summary>Google Sheet Column Ordering</summary>

1. activity\_date
2. age\_range
3. business\_email
4. business\_email\_last\_seen
5. children
6. client
7. company\_address
8. company\_address\_2
9. company\_city
10. company\_domain
11. company\_employee\_count
12. company\_linkedin\_url
13. company\_name
14. company\_phone
15. company\_revenue
16. company\_sic
17. company\_state
18. company\_zip4
19. company\_zip
20. department
21. direct\_number
22. email email\_address\_lc
23. event\_date
24. external\_id
25. first\_name
26. gender
27. hem
28. homeowner
29. income\_range
30. ip\_address
31. job\_title
32. last\_name
33. linkedin\_url
34. married
35. **match\_type\***
36. net\_worth
37. page\_url
38. personal\_address
39. personal\_address\_2
40. personal\_city
41. personal\_email
42. personal\_email\_last\_seen
43. personal\_state personal\_zip4
44. personal\_zip primary\_industry
45. professional\_address
46. professional\_address\_2
47. professional\_city
48. professional\_state
49. professional\_zip4
50. professional\_zip
51. referer\_url
52. seniority\_level
53. unix\_timestamp

</details>

***

## Connection Instructions <a href="#instructions" id="instructions"></a>

### Starting Out  <a href="#log-into-distilled" id="log-into-distilled"></a>

1. First, log into your Untitled account.
2. Select `Destinations` in the left navigation menu.
3. Find **Google Sheets** and click `Connect` on the Destination Card.&#x20;
4. A popup will appear prompting you to name your Google Sheet Destination. Make it something descriptive like "Untitled G-Sheet Audience&#x73;*"* and then select `Connect`&#x20;

<figure><img src="/files/dPFZim7SIjlJtVTAv5Wg" alt=""><figcaption></figcaption></figure>

5. Another popup modal will appear informing you the Google Sheet Destination is ready to be authenticated. Select `Continue` - you will be redirected to a new window.

<figure><img src="/files/W58cQiTJOE2L9AUelZzY" alt=""><figcaption></figcaption></figure>

6. In the new window, first select `Continue` to allow a connection to Google Sheet&#x73;**.**

<figure><img src="/files/4bqxEQwIj2KdHcUsWZPA" alt=""><figcaption></figcaption></figure>

7. Next, you will be asked to share access to your Google Sheet. **First,** `copy` **the provided email** (press the icon on the far right of this email field for easy copy/paste of the full email url).

<figure><img src="/files/VD4Yw3OQS7m5s1x49mZ7" alt=""><figcaption></figcaption></figure>

8. **Keep this window open,** create a new tab or window, and login to Googl&#x65;**.**

### Configure Google Sheet Access to Untitled <a href="#configure-google-sheet-access-to-distilled" id="configure-google-sheet-access-to-distilled"></a>

1. Log in to your Google account and create a new Google Sheet file.
2. In the top right corner, select the `Share` button for the file
3. **Paste the email** you copied from the Untitled window, ensure "**Editor"** access is being granted, and hit `Send`&#x20;

<figure><img src="/files/5B16ikBCqA3nQHF0lJQe" alt=""><figcaption></figcaption></figure>

4. Depending on your organizations Google access controls, you may be asked to confirm the external share. Click `Share anyway`

<figure><img src="/files/RXH8ZxXLJvxZGAKwhtwO" alt=""><figcaption></figcaption></figure>

5. Navigate back to the previous window (where you copy/pasted the census email from) and click `Continue` to begin the authentication test.&#x20;
6. Wait for the **success** message to appear. Select `Finish` once the connection has successfully tested.

<figure><img src="/files/PVT0g359O3eGxABwkplu" alt=""><figcaption></figcaption></figure>

7. You can now safely close this window and being Syncing Audiences to your Google Sheet Destination!&#x20;

<figure><img src="/files/UlxJI4z3KKzVE4ljJ4kc" alt=""><figcaption></figcaption></figure>

Once your sheet is successfully connected, you'll see a green indicator icon next to the Google Sheets Destination card as shown in the example below

<figure><img src="/files/MkqSouhIec77n7dfdLIH" alt=""><figcaption></figcaption></figure>

## Sync Your Audience to Google Sheets <a href="#sync-your-audience-to-google-sheets" id="sync-your-audience-to-google-sheets"></a>

1. Navigate back to Untitled and secelect the **Audiences** page
2. Select the `View` button next to the audience you want to push to Google Sheets (or click `Sync to destination` if it's a brand new audience with no existing destinations attached)

<figure><img src="/files/QRUkxxFAXmTXOHGkZuem" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
If you still need to create your first Audience, select the **Create new +** button in the top right corner. Utilize the demographic, firmographic, and behavioral **filters** to target specific segments of your website visitors. Follow this guide to learn more -[ <mark style="color:blue;">How to Build & Save Audiences in Untitled.</mark>](/audience-studio.md)
{% endhint %}

3. Click the `Destinations` tab of the Audience
4. Locate the Google Sheet you want to connect (e.g. if you have multiple connected, they will all appear here), and select `Setup sync` on the Destination Card

<figure><img src="/files/9BRZcinRyCRhCtOgYGK0" alt=""><figcaption></figcaption></figure>

5. IMPORTANT: You must select from the drop down "Select your sheet" > this will populate the available Spreadsheet TABS in your Google Sheet. If you do not see the desired tab from the drop down, try clicking the refresh icon. Once you've located the tab you want to sync data to, click `Continue`&#x20;

<figure><img src="/files/oYbyA4kSaXuWKrN7078C" alt=""><figcaption></figcaption></figure>

6. Once you've clicked continue, you'll see the initial sync message on the Destination card. The initial sync to Google Sheets may take up to 5 minutes to populate.

<figure><img src="/files/fcy08LkqjArn1d2HCwfK" alt=""><figcaption></figcaption></figure>

7. Once the initial sync has been completed, you should see the green indicator message next to the sync status message letting you know that the sheet will now sync resultant audience data daily at 12:15 PM ET.&#x20;

<figure><img src="/files/RtSFrei1Rx4RIBtcLDks" alt=""><figcaption></figcaption></figure>

Proceed to the next section in the event you would like to connect additional audiences to the SAME Google Sheet you just completed setting up as an Untitled Destination.&#x20;

### New Audience Syncs to the Same Google Sheet

{% hint style="warning" %}
**NOTE** - When configuring Google Sheets as your destination in Untitled, all audiences will be sent to the **single Google Sheet** you connected during the destination setup process. However, each audience will have its own separate tab within the sheet via following the instructions below.&#x20;
{% endhint %}

**Each time you setup a new audience to sync with your Google Sheets destination, complete the steps below**:

1. Open your linked Google Sheet file and **create a new Sheet tab**.&#x20;
   1. We recommend naming each sheet tab with the **exact title of the corresponding Untitled audience being synced to that tab**.
2. Select `Setup sync` on the Google Sheet Card from within the Destination view inside of the Audience you intend to sync.
3. Select the specific **Sheet tab** that you would like to sync your audience to (see Step 5 in the previous section for what to do if you're new Sheet tab does NOT appear in the "Select your sheet" drop down list).&#x20;
4. Press `Continue` to Complete Setup.&#x20;

**Done!** Your audience has been successfully integrated with Google Sheets. The initial sync to Google Sheets may take up to 5 minutes to populate.

### Sync Schedule <a href="#sync-schedule" id="sync-schedule"></a>

Your audience will push updates daily at **12:15 pm EST**. With the audience's filter settings applied, new visitors that meet the filter criteria will be continuously refreshed and added to your list automatically.

You can integrate an unlimited number of saved audiences in Untitled to your Google Sheet file by repeating the last seven steps.

## Need Further Support or Have Additional Questions?

Check out our[ <mark style="color:blue;">FAQs</mark> ](/misc/frequently-asked-questions.md)to get some answers, start a chat on our [website](https://getuntitled.ai/), or get connected directly with our team [<mark style="color:blue;">here</mark>](https://getuntitled.ai/contact/).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.getuntitled.ai/integrations/destinations/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.