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.
Troubleshooting: "This App is Blocked" Error
If you encounter a "This app is blocked" error when trying to connect to Google Spreadsheets, this is due to Google's security settings. Admins can enable the third-party app in the Google Admin console.
Before starting, ensure you have administrator privileges for your Google Workspace account.
Step 1: Navigate to API Controls
Log in to your Google Workspace Admin console. In the left-hand navigation menu, click on "Security", then locate and click on "API controls."
Step 2: Manage Third-Party App Access
On the API controls page, click on MANAGE THIRD-PARTY APP ACCESS.
Step 3: Configure New App
Under "Configured apps," click on the Configure new app button.
Step 4: Search for Syft Data
In the search bar, enter the following Client ID:
640418593024-p1r79rpca6befn8jpirr96d8dkc7tjer.apps.googleusercontent.com
Click Search, then select "Syft Data" from the results.
Step 5: Define Scope of Access
Select "All in [your organization] (all users)" and click Continue.
Step 6: Set Access to Google Data
Select the "Trusted" option (or "Specific Google Data" if preferred) and click Continue.
Step 7: Review and Finish
Review all settings and click Finish. The Syft Data app should now appear under "Configured apps."
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
Company - Total Sessions
syft_sessions
Total number of sessions from this company
number
Company - Unique Visitors
syft_visitors
Number of unique visitors from this company
number
Company - First Seen
syft_first_seen
First time when someone from this company visited the website
datetime
Company - Last Seen
syft_last_seen
Last time when someone from this company visited the website
datetime
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 - Job Title
title
The job title 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 - 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 - First Seen
syft_first_seen
First time when the contact visited the website
datetime
Contact - Last Seen
syft_last_seen
Last time when the contact visited the website
datetime
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 - UTM Source
utm_source
UTM source parameter tracking the traffic source
string
Session - UTM Medium
utm_medium
UTM medium parameter tracking the marketing medium
string
Session - UTM Campaign
utm_campaign
UTM campaign parameter tracking the marketing campaign
string
Session - UTM Channel
utm_channel
Derived traffic channel (e.g., Direct, Paid Search, Organic Social)
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
Session - Start Time
start_time
Start time of the session
datetime
Session - End Time
end_time
End time of the session
datetime
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
LinkedIn - Timestamp
timestamp
Timestamp of the LinkedIn interaction
datetime