For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

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.

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.

Connect your Google account

1

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

Integrations page with the New Integration menu open, showing Connect a source and Connect a destination
2

Choose Google Sheets

Under Destinations, click Google Sheets.

Destinations → Google Sheets

Connect a destination menu listing Google Sheets, Facebook, and legacy destinations
3

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

Connect Google Sheets dialog with Google Sheets entered as the connection name
4

Open Google sign-in

Click Connect. A Google sign-in pop-up opens.

Connect

Link Google Sheets Account dialog with a note about pop-ups and a Connect button
5

Choose your Google account

In the pop-up, choose the Google account that owns your spreadsheet.

Google Choose an account pop-up asking which account to continue to Untitled with
6

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

Google consent screen saying Untitled wants access to your Google Account, with Cancel and Allow buttons

Add your spreadsheet

Untitled only gets access to the spreadsheet you pick here, so the rest of your Drive stays private.

1

Open the spreadsheet picker

Untitled confirms the connection and asks you to choose a spreadsheet. Click Choose a spreadsheet.

Choose a spreadsheet

Choose a spreadsheet dialog explaining that you must pick with the same Google account you just connected
2

Pick the spreadsheet

Search for your spreadsheet by name (the video uses “Sheets Destination for Untitled Data”). Click it, then click Select.

Select

Google Choose a spreadsheet picker with a search for Sheets Destination for Untitled Data and a file highlighted
3

Name the destination

Untitled fills in Destination name with the spreadsheet's name. Change it if you like, then click Create destination.

Create destination

Name your destination dialog with Sheets Destination for Untitled Data as the destination name
4

Finish the test

Untitled tests the destination. When it says Destination is healthy, click Finish.

Finish

Testing destination dialog saying Destination is healthy, with a Finish button
5

Check the connection is listed

Your Google Sheets connection now appears under Your connections, with the spreadsheet listed under it and No syncs yet.

Your connections list showing the Google Sheets connection with one sheet and no syncs yet

Sync an audience to the sheet

1

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

Google Sheets connection panel showing one destination with no audience syncs and a New sync link
2

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

New audience sync panel with the Audience list open, showing a search box and audiences with member counts
3

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

New audience sync panel with All Visitors 7 days, Create a new tab, Replace, and the Create sync button
4

Confirm the sync

Untitled summarizes what the sync will do. Click Create sync.

Create sync

Create this sync confirmation saying All Visitors 7 days will be written to a new tab, clearing it first on every run
5

Check the sync was created

A message says the sync was created and started. The sync now appears under Audience syncs.

Connection panel listing the All Visitors 7 days sync with a Sync created and started confirmation
6

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.

Google Sheets spreadsheet with a new All Visitors 7 days tab and a header row of contact fields, the data rows hidden
Step by Step Guide: Sync an audience to a Connected Google Sheet

Sync an audience to a Connected Google Sheet

1

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

Google Sheets connection panel showing one destination with no audience syncs and a New sync link
2

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

New audience sync panel with the Audience list open, showing a search box and audiences with member counts
3

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

New audience sync panel with All Visitors 7 days, Create a new tab, Replace, and the Create sync button
4

Confirm the sync

Untitled summarizes what the sync will do. Click Create sync.

Create sync

Create this sync confirmation saying All Visitors 7 days will be written to a new tab, clearing it first on every run
5

Check the sync was created

A message says the sync was created and started. The sync now appears under Audience syncs.

Connection panel listing the All Visitors 7 days sync with a Sync created and started confirmation
6

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.

Google Sheets spreadsheet with a new All Visitors 7 days tab and a header row of contact fields, the data rows hidden

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 support@getuntitled.ai 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

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

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

  1. 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.

  1. In the new window, first select Continue to allow a connection to Google Sheets.

  1. 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).

  1. 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

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

  1. Navigate back to the previous window (where you copy/pasted the census email from) and click Continue to begin the authentication test.

  2. Wait for the success message to appear. Select Finish once the connection has successfully tested.

  1. 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)

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.

  1. Click the Destinations tab of the Audience

  2. 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

  1. 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

  1. 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.

  1. 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

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.

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 to get some answers, start a chat on our website, or get connected directly with our team here.

Last updated

Was this helpful?