# 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](/docs/integrations/overview.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://midbound.ai/docs/integrations/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.