Google Sheets

What It Does

Appends a row of visitor data to a Google Sheet each time a workflow fires. The sheet is automatically set up with headers the first time data is written.

Authentication

OAuth2. When adding Google Sheets as a connection step in an automation, click Connect and authorize Midbound to access your Google account. A new Google Sheet is automatically created for you during setup.

Columns

Each row contains 24 columns of visitor data. Headers are automatically created in row 1:

#	Column	Description
1	Person ID	Unique Midbound identifier
2	Name	Visitor's full name
3	Workspace ID	Your workspace identifier
4	Email	Work email (fallback: personal)
5	Phone	Work phone (fallback: personal)
6	LinkedIn URL	Visitor's LinkedIn profile
7	Company Name	Current employer
8	Job Title	Current role
9	Company Industry	Industry classification
10	Company Headcount	Number of employees
11	Company Revenue Min	Lower revenue estimate
12	Company Revenue Max	Upper revenue estimate
13	Company LinkedIn URL	Company's LinkedIn page
14	Total Sessions	Number of visits to your site
15	Total Pageviews	Total pages viewed
16	Total Time on Site	Time spent in seconds
17	Last Seen At	Most recent visit timestamp
18	UTM Source	Traffic source
19	UTM Medium	Traffic medium
20	UTM Campaign	Campaign name
21	Entry Path	First page viewed
22	Active Audiences	Comma-separated audience names
23	Visited Pages	Comma-separated page paths (up to 10)
24	Timestamp	When the row was written (ISO format)

Key Behaviors

• Auto-creates headers — Headers are written to row 1 automatically. This is safe to run concurrently — the same headers are written to the same cells each time.

• Appends, never overwrites — Data rows are appended after the header row. Existing rows are never modified.

• Supported URL formats — Standard Google Sheets URLs work, including /edit and /edit#gid=0 variations.

• Visited pages limit — Only the first 10 visited pages are included to keep cells manageable.

Using with Workflows

1. Add Google Sheets as a connection step in your automation

2. Authorize your Google account — a new sheet is created automatically

3. Build a workflow that pushes visitor data to the sheet

4. Each matching visitor adds a new row automatically

Related

• Integrations Overview