More than 100 zaps have been created for you to connect Dealfront to your other applications and tools that you use the most! You can check them all out here. 

In this article we will being looking at the Zap: Add new Dealfront identified companies to Google Sheets as rows

STEP 1: The first step in using this integration, is to connect your Google Account and create a Google Sheet for the identified companies to be sent to.

This will be matched by "Spreadsheet" and "Worksheet".

If there is an issue finding the Spreadsheet the sheet ID may be used for identification. That ID is found in the url.

For example in: https://docs.google.com/spreadsheets/d/1rF4TmUylXJpCTvVPyelWJwmKzjqW8RaSS3GTfSs*****/edit#gid=0
​
"1rF4TmUylXJpCTvVPyelWJwmKzjqW8RaSS3GTfSs****" is the Spreadsheet Name, and the Worksheet name is in the worksheet tab.

STEP 2: The second step would be to set up the sheet with the proper headers for the data you want (Row 1 above), named in a way that fits your needs and is understandable.

You will match your header names with the fields available from Dealfront.
​
​STEP 3: When setting up the Zap you will be guided through matching up the Headers you created in your sheet, with the information you want to see in those columns.
​
​In the example above we only use eight of the available fields:

The fields that Dealfront makes available are the following:
Company Name
City
Website Url
Region
Industry
Country
ID
Created At
Dealfront App URL
Pageviews
State Code
Country Code

Business ID
Summary
LinkedIn URL
Location Display Name
Visit Depth
Source /Medium
Visit Length
Keyword
Page Title
Page Path
Page URL
Time On Page
Time
Hostname
Previous Path Page
Pageviews ID
City State Country Code
Landing Page
Last Visit Date

Visit country

Visit country code

Visit region

Visit city

Visit state code

Visit city, state code, country code

Visit location display name

Tags (comma-separated values)

Phone

Revenue

Employee count

You can use any or all of these fields in your Google Sheet.
​
This list of fields is an example of what many of the Zapier integrations use. The process is similar regarding matching and typically the same fields are available from Dealfront.

Please note: Zaps for recurring companies will overwrite the data in Hubspot fields, if you have any. For example sending tags from Dealfront to Hubspot fields will update and delete the tag already existing in the Hubspot field. Please remember that it will be triggered only with the first visit during the day (all the other visits that day will be disregarded).
​

--

Questions, comments, feedback? Please let us know by contacting our support team via the chat or by sending us an email at support@dealfront.com.
​
​RELATED: