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 Sheets Workbook

Walkthrough Video: Syncing an Additional Audience to an Existing Sheets Workbook

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.

Destination Overview

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.

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

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.

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

---

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

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.

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.

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.