Google Spreadsheets
Connecting to Google Spreadsheets
To enable this integration, you'll need to authenticate with Google using OAuth 2.0.
Go to the Integrations page and click the "Connect" button under Google Spreadsheets to get started.
A screen will appear prompting you to authorize Syft to access your Google account. Click "Allow" to continue.
Using Google Spreadsheets in Motions
Syft can export account and lead data to Google Spreadsheets through motions. There are a couple of options that control what is automatically exported:
- Identify Leads and Push: Enable this by creating a leads motion. This will export identified leads to your specified Google Spreadsheet.
- Push Leads and Their Actions: Enable this by creating a sessions motion. This will export both leads and their session data to your Google Spreadsheet.
Exported Fields
The following objects and their fields are exported to Google Spreadsheets:
Company Object
Company - Company Name
name
The name of the company
string
Company - Company Domain
domain
The primary domain of the company website
string
Company - Company Website
website
The full URL of the company website
string
Company - Street Address
address
The street address of the company
string
Company - City
city
The city where the company is located
string
Company - Metropolitan Area
city_metro_area
The metropolitan area where the company is located
string
Company - State/Province
state
The state or province where the company is located
string
Company - Country
country
The country where the company is located
string
Company - Postal/ZIP Code
zip
The postal or ZIP code of the company
string
Company - Phone Number
phone
The main phone number of the company
string
Company - Industry
industry
The industry the company operates in
enumeration
Aerospace & Defense
Air Freight & Logistics
Airlines
Automotive
Banks
Company - Number of Employees
employees
The estimated number of employees at the company
number
Company - Annual Revenue
annualRevenue
The estimated annual revenue of the company
string
Company - Founded Year
foundedYear
The year the company was founded
string
Company - Lifecycle Stage
lifecycleStage
The current lifecycle stage of the company
enumeration
Prospect
Opportunity
Lost Opportunity
Customer
Company - LinkedIn URL
linkedin
The LinkedIn company page URL
string
Company - Syft Account URL
syft_account_url
The URL of the company in Syft
string
Company - Matched ICPs
syft_icp
Syft ICPs that match this company
string
Company - Matched Personas
syft_persona
Syft Personas of the visitors from this company
string
Lead Object
Contact - Email
email
The email address of the contact
string
Contact - First Name
firstName
The first name of the contact
string
Contact - Last Name
lastName
The last name of the contact
string
Contact - Gender
gender
The gender of the contact
string
Contact - Phone Number
phone
The phone number of the contact
string
Contact - Street Address
address
The street address of the contact
string
Contact - City
city
The city where the contact is located
string
Contact - Metropolitan Area
city_metro_area
The metropolitan area where the contact is located
string
Contact - State/Province
state
The state or province where the contact is located
string
Contact - Country
country
The country where the contact is located
string
Contact - Postal/ZIP Code
zip
The postal or ZIP code of the contact
string
Contact - Website
website
The personal website of the contact
string
Contact - LinkedIn URL
linkedin
The LinkedIn profile URL of the contact
string
Contact - Job Title
title
The job title of the contact
string
Contact - ID Confidence
syft_enrichment_confidence
Confidence level of the ID data (Very High, High, Medium, Low)
string
Contact - Matched Personas
syft_persona
Syft Personas that match this contact
string
Contact - Salesforce Contact ID
salesforce_contact_id
The Salesforce Contact ID of the contact
string
Contact - Salesforce Lead ID
salesforce_lead_id
The Salesforce Lead ID of the contact
string
Contact - HubSpot Contact ID
hubspot_contact_id
The HubSpot ID of the contact
string
Contact - Apollo Contact ID
apollo_contact_id
The Apollo ID of the contact
string
Contact - Outreach Contact ID
outreach_contact_id
The Outreach ID of the contact
string
Contact - All Email Addresses
emails
All email addresses associated with this contact
string
Session Object
Session - Active Time
active_time
Duration of active time spent during the session
number
Session - Matched Signals
signals
List of signals/intents matched during the session
string[]
Session - Pages Visited
pages_visited
List of unique pages visited during the session
string[]
Session - Referrer
referrer
The referrer source for this session
string
Session - Address
address
The address of the geographic location information of the session
string
Session - Purchase Intent
syft_purchase_intent
Purchase intent determined for this session
string
Very High
High
Medium
Low
Session - Enrichment Confidence
enrichment_confidence
Confidence score for the enriched session data
string
Very High
High
Medium
Low
LinkedIn Object
LinkedIn - LinkedIn Action
action
Type of action performed on LinkedIn
string
Like
Comment
Sent Message
Received Message
LinkedIn - LinkedIn Post ID
post_id
Identifier of the LinkedIn post
string
LinkedIn - LinkedIn Post URL
post_url
URL of the LinkedIn post
string