> For the complete documentation index, see [llms.txt](https://docs.getuntitled.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.getuntitled.ai/integrations/destinations/google-sheets.md).
# Google Sheets
Syncing segmented audiences to Google Sheets enables you to organize and manage your audience data conveniently in a spreadsheet format.
## Walkthrough Video: Creating and Syncing to a New Google Spreadsheet
{% embed url="" %}
Step by Step Guide: Creating and Syncing to a New Google Spreadsheet
Connect your Google account, choose a spreadsheet, and set up a sync that writes an audience into it on a schedule.
{% hint style="info" %}
**Before you start**
* Create the spreadsheet you want Untitled to write to in Google Sheets. Untitled can only open sheets you pick during setup.
* Know which Google account owns that spreadsheet. Stay signed into that Google account during the setup process.
* Allow pop-ups for Untitled in your browser. Google sign-in opens in a pop-up window.
{% endhint %}
### Connect your Google account
{% stepper %}
{% step %}
#### Open Integrations and add a destination
In the left sidebar, click **Integrations**. Then click **New Integration** and choose **Connect a destination**.
Integrations → New Integration → Connect a destination
{% endstep %}
{% step %}
#### Choose Google Sheets
Under **Destinations**, click **Google Sheets**.
Destinations → Google Sheets
{% endstep %}
{% step %}
#### Name the connection
Enter a **Connection name**, such as “Google Sheets”, so you can recognize this Google account later. Click **Continue to sign-in**.
Continue to sign-in
{% endstep %}
{% step %}
#### Open Google sign-in
Click **Connect**. A Google sign-in pop-up opens.
Connect
{% endstep %}
{% step %}
#### Choose your Google account
In the pop-up, choose the Google account that owns your spreadsheet.
{% endstep %}
{% step %}
#### Allow access
Google asks you to let Untitled see, edit, create and delete only the Google Drive files you use with it. Click **Allow**.
Allow
{% endstep %}
{% endstepper %}
### Add your spreadsheet
Untitled only gets access to the spreadsheet you pick here, so the rest of your Drive stays private.
{% stepper %}
{% step %}
#### Open the spreadsheet picker
Untitled confirms the connection and asks you to choose a spreadsheet. Click **Choose a spreadsheet**.
Choose a spreadsheet
{% endstep %}
{% step %}
#### Pick the spreadsheet
Search for your spreadsheet by name (the video uses “Sheets Destination for Untitled Data”). Click it, then click **Select**.
Select
{% endstep %}
{% step %}
#### Name the destination
Untitled fills in **Destination name** with the spreadsheet's name. Change it if you like, then click **Create destination**.
Create destination
{% endstep %}
{% step %}
#### Finish the test
Untitled tests the destination. When it says **Destination is healthy**, click **Finish**.
Finish
{% endstep %}
{% step %}
#### Check the connection is listed
Your Google Sheets connection now appears under **Your connections**, with the spreadsheet listed under it and **No syncs yet**.
{% endstep %}
{% endstepper %}
### Sync an audience to the sheet
{% stepper %}
{% step %}
#### Start a new sync
Click **Manage connection** on the Google Sheets connection. In the panel that opens, under your spreadsheet, click **New sync**.
Manage connection → New sync
{% endstep %}
{% step %}
#### Choose an audience
Open the **Audience** list and pick the audience to send. The video uses “All Visitors 7 days”.
Audience → All Visitors 7 days
{% endstep %}
{% step %}
#### Set up the sync and create it
Choose the sync settings, then click **Create sync**:
* **Sheet target**: **Create a new tab** adds a tab for this sync. **Write to an existing tab** uses a tab that's already in the spreadsheet.
* **Sync name**: labels the sync in Untitled. It's filled in from the audience name.
* **Update method**: **Replace** clears the tab and writes the current members on every run. **Append** adds new rows on every run and never removes any.
* **Run sync on creation**: leave it on to run the first sync right away. Turn it off to wait for the schedule.
Create sync
{% endstep %}
{% step %}
#### Confirm the sync
Untitled summarizes what the sync will do. Click **Create sync**.
Create sync
{% endstep %}
{% step %}
#### Check the sync was created
A message says the sync was created and started. The sync now appears under **Audience syncs**.
{% endstep %}
{% step %}
#### Open the spreadsheet
Open your spreadsheet in Google Sheets. A new tab named after the sync holds the audience, with a header row of contact fields such as **first\_name**, **email** and **job\_title**.
{% endstep %}
{% endstepper %}
{% hint style="success" %}
**Google Sheets is connected**
Untitled now writes your audience to the spreadsheet on the connection's schedule. To send another audience, open **Manage connection** and click **New sync** again. If a sync stops working, check that the spreadsheet still exists and that the Google account you connected can still edit it.
{% endhint %}
Step by Step Guide: Sync an audience to a Connected Google Sheet
## Sync an audience to a Connected Google Sheet
{% stepper %}
{% step %}
### Start a new sync
Click **Manage connection** on the Google Sheets connection. In the panel that opens, under your spreadsheet, click **New sync**.
Manage connection → New sync
{% endstep %}
{% step %}
### Choose an audience
Open the **Audience** list and pick the audience to send. The video uses “All Visitors 7 days”.
Audience → All Visitors 7 days
{% endstep %}
{% step %}
### Set up the sync and create it
Choose the sync settings, then click **Create sync**:
* **Sheet target**: **Create a new tab** adds a tab for this sync. **Write to an existing tab** uses a tab that's already in the spreadsheet.
* **Sync name**: labels the sync in Untitled. It's filled in from the audience name.
* **Update method**: **Replace** clears the tab and writes the current members on every run. **Append** adds new rows on every run and never removes any.
* **Run sync on creation**: leave it on to run the first sync right away. Turn it off to wait for the schedule.
Create sync
{% endstep %}
{% step %}
### Confirm the sync
Untitled summarizes what the sync will do. Click **Create sync**.
Create sync
{% endstep %}
{% step %}
### Check the sync was created
A message says the sync was created and started. The sync now appears under **Audience syncs**.
{% endstep %}
{% step %}
### Open the spreadsheet
Open your spreadsheet in Google Sheets. A new tab named after the sync holds the audience, with a header row of contact fields such as **first\_name**, **email** and **job\_title**.
{% endstep %}
{% endstepper %}
{% hint style="success" %}
**Google Sheets is connected**
Untitled now writes your audience to the spreadsheet on the connection's schedule. To send another audience, open **Manage connection** and click **New sync** again. If a sync stops working, check that the spreadsheet still exists and that the Google account you connected can still edit it.
{% endhint %}
***
Migrate Google Spreadsheet connections made before October 15, 2026
### Who needs to migrate
If you connected Google Sheets to your Untitled account before October 15, 2026, those connections will likely need to be migrated. Not sure if you need to migrate? Email and we will check for you!
### Before you begin
There is some vocabulary that will help make the migration simpler.
When migrating an Untitled Audience to the new Google Sheets integration, you will make a **connection** to a Google Drive account. If you are migrating Untitled Audiences, make sure you are either the **owner** or an **editor** of the Google Sheets where your Untitled Audience data appears.
A **sync** in Untitled refers to what Google calls a **spreadsheet**.
You can have multiple Untitled Audiences syncing to a single spreadsheet. When you do, each Audience is syncing to a tab within the spreadsheet, which Google calls a **sheet**.
***
### Step-by-step guide
From the Integrations page of your Untitled account, click the Legacy Connections tab and ensure you have Destinations selected.
Click Migrate on any of your existing Google Sheets migrations.
In the popup that opens, drop down the menu for Choose a connection and select Create a new connection
1. You will need to do this at least once to create a connection between your Untitled account and your Google Drive account.
Name the Google Sheets connection.
1. This name only appears in Untitled and it can be edited later. If you have multiple users in your Untitled account who will integrate with Google Sheets, a good name may be \[Your Name]'s Sheets to distinguish the connections.
Click Continue to sign-in
Click Connect, and then choose the account which owns, or has editor access to, the Sheets you want your Untitled data to sync to.
Allow Untitled to edit the specific Drive files you use with this app. Untitled does not have edit, create, or delete permissions for your other files.
Once the connection is made, grant Untitled access to the file where your Audience is currently syncing.
1. If your Audience syncs only to one Google Sheet, then only one file will be available to choose here.
2. If the file selector is blank, it it most likely because you do not have ownership or editor access to the file where the Untitled Audience is currently syncing.\*
Grant access to **sheets** within the **spreadsheet** you just connected and click Migrate syncs .
1. If your existing sync has one sheet within the spreadsheet, you will see only one Tab ID here.
A success message will indicate that your migration is complete.
Repeat the process for each **connection** (unique Google spreadsheet) that receives Untitled data.
### Sync Schedule
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.
***
## Destination Overview
This user guide will walk you through the process of syncing segmented Audiences from your Untitled account 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**.
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
{% 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 |
Google Sheet Column Ordering
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
***
Legacy walkthrough video of creating a new Google Spreadsheet
{% embed url="" %}
Legacy step-by-step guide of connecting Untitled to Google Sheets
## Connection Instructions
### Starting Out
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.
4. A popup will appear prompting you to name your Google Sheet Destination. Make it something descriptive like "Untitled G-Sheet Audiences*"* and then select `Connect`
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.
6. In the new window, first select `Continue` to allow a connection to Google Sheets**.**
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).
8. **Keep this window open,** create a new tab or window, and login to Google**.**
### Configure Google Sheet Access to Untitled
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`
4. Depending on your organizations Google access controls, you may be asked to confirm the external share. Click `Share anyway`
5. Navigate back to the previous window (where you copy/pasted the census email from) and click `Continue` to begin the authentication test.
6. Wait for the **success** message to appear. Select `Finish` once the connection has successfully tested.
7. You can now safely close this window and being Syncing Audiences to your Google Sheet Destination!
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
## Sync Your Audience to Google Sheets
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)
{% 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 -[ How to Build & Save Audiences in Untitled.](/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
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`
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.
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.
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.
### 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.
{% 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**.
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).
4. Press `Continue` to Complete Setup.
**Done!** Your audience has been successfully integrated with Google Sheets. The initial sync to Google Sheets may take up to 5 minutes to populate.
Legacy video of adding an additional Audience to an existing Google Spreadsheet connection
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="" %}
### Sync Schedule
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[ FAQs ](/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 [here](https://getuntitled.ai/contact/).
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.
Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:
```
GET https://docs.getuntitled.ai/integrations/destinations/google-sheets.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.
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.
