Google Sheets

The Google Sheets integration turns a spreadsheet into a live data source for your agents. Look up offers, prices, or customer records mid-call, write each call’s outcome to a log sheet, and add contacts to an agent whenever a row is added.

Connect Google Sheets

Find Google Sheets in the App Center

Open App Center, search for Google Sheets, and click +.

Enter a Connection Name, click Connect, and sign in with the Google account that can access your sheets. On the Google consent screen, click Allow to grant access to Drive files and Sheets spreadsheets.

Google Sheets connection window with a Connection Name field and Connect buttons — Name the connection and click Connect

Confirm the connection

Google Sheets shows a check mark under Connected Apps.

The connection can only see sheets the Google account can open. Share the sheets you need with that account. For sheets in a shared drive, turn on Include Shared Drives (under Advanced) in the action.

Available actions

Most actions come in two forms with the same name, for example two Find Rows or two Add Row entries. One picks the Spreadsheet and Worksheet from drop-downs; the other takes a Spreadsheet ID and Worksheet ID as text, which is handy when the IDs come from variables. Both do the same thing. This page describes the drop-down form.

Rows

Action	What it does
Find Rows	Finds rows where a column matches a value. This is the main lookup action.
Find or Create Row	Looks up a row by column value and creates it if nothing matches
Get Row by Number	Gets one row by its row number
Get Next Rows / Get Next Rows (Paginated)	Reads rows in batches, continuing where the last run left off
Get All Rows	Reads every row in a worksheet
Add Row / Add Multiple Rows	Appends rows
Add Row at Top	Inserts a row just below the header row
Update Row / Update Multiple Rows	Overwrites rows by row number
Delete Row / Delete Multiple Rows	Deletes a row, a range of rows, or a list of row numbers
Clear Row(s) / Clear Cell Range	Clears cell contents without removing the rows
Format Row(s) / Format Cells	Applies colour and text styling

Cells & ranges

Action	What it does
Read Data Range / Read Cell Range	Reads cells by A1 notation, for example `A1:D10`
Write Cell Range	Writes a 2D array of values at an A1 range
Append Values (Raw)	Appends rows of values after the last row with data
Insert Rows/Columns / Delete Rows/Columns / Append Rows/Columns	Adds or removes blank rows or columns, shifting the rest
Create Column / Add Column	Adds a column with a header name
Auto-Resize Columns/Rows / Resize / Hide Rows or Columns	Sizes, hides, or unhides rows and columns

Spreadsheets & worksheets

Action	What it does
Create Spreadsheet	Creates a blank spreadsheet
Get Spreadsheet Info	Returns a spreadsheet’s title and its worksheets
Find Spreadsheet(s) / Find Spreadsheets	Finds spreadsheets by name
Create Worksheet / Add Worksheet / Find or Create Worksheet	Creates a tab, or finds one by title and creates it if missing
Find Worksheet(s) / Find Worksheets	Finds tabs by title
Copy Worksheet / Rename Worksheet / Delete Worksheet	Manages tabs
Update Worksheet Properties	Sets frozen rows and columns, tab colour, or hidden state
Clear Sheet	Clears all rows, keeping the worksheet
Export Worksheet / Export Worksheet (CSV/TSV)	Exports a tab as CSV or TSV
Custom API Call	Calls any Google Sheets API endpoint with your connection

Available triggers

Trigger	Type
New Row Added	Instant
New or Updated Row	Instant
New Spreadsheet	Scheduled
New Worksheet	Scheduled

Use New Row Added to add a contact to an agent each time a row is added, for example from a web form that writes to a sheet. New or Updated Row also fires when an existing row changes; set Trigger Column to fire only when one column changes. Instant triggers rely on Google’s change notifications, so delivery can lag by a few minutes. See Triggers.

Use Google Sheets in an agent

Look up data during a call (Find Rows)

Add Find Rows as an in-call action to fetch data while the contact is on the line.

Field	What to enter
Spreadsheet / Worksheet	The sheet and tab to search
Column Name	The column to search. The list shows the headers in the header row.
Search Value	The value to match. Accepts variables, for example `{{ account_id }}`. Leave empty to return rows in order.
Exact Match	On: whole-value match. Off (default): partial match.
Number of Rows	How many matching rows to return. Default `1`; raise it if you want several matches.
Header Row	The row with the column names. Default `1`.
Starting Row	Optional (under Advanced). Start searching from this row number.
Use Column Names	On by default: keys each row by column name instead of A, B, C.

The response uses your column headers as keys, and each match includes its row number:

0
  row: 51
  values:
    package_code: 12140451
    price: 320
    data_cap_gb: 80
1
  row: 52
  values:
    ...

A reliable pattern for live lookups:

Capture the search value

Before the action, make sure the agent has the value to search for, either as a contact variable or as a value the AI extracts from the conversation (a Variables Extracted with Prompt field on the action).

Run Find Rows with a short fallback phrase

For example, “Let me check that for you.” The contact hears this while the lookup runs.

Tell the agent how to use the result

In the next step, add an instruction that says which row to pick and what to say, for example “Offer the cheapest plan with more data than the customer’s current plan.”

Handle no results

Add a scenario or branch for when nothing matches.

Log every call (Add Row)

Add Add Row as a post-conversation action. Choose the Spreadsheet and Worksheet, turn on First Row Contains Headers to enter values by column name, then map each column under Values to a contact variable, a post-call analysis answer, or call data such as the outcome. Leave the outcome filter empty to log every call, or filter to log only some outcomes. To keep one row per contact instead of one per call, use Find or Create Row with the phone number as the Search Value: it returns the existing row or appends a new one.

Best practices for lookup sheets

One row per item, headers in row 1. The headers become the response keys.
Short, consistent header names in snake_case, for example data_cap_gb, price.
Clean values. Store numbers as numbers (no units in the cell) and dates in ISO format (2026-10-26).
A dedicated lookup tab with only the columns the agent needs.
Keep it small. Large sheets make in-call lookups slower. Filter to the rows that matter.

Troubleshooting

My spreadsheet isn't in the list

The connected Google account can’t access it. Share the sheet with that account, or turn on Include Shared Drives if it’s in a shared drive.

Find Rows returns nothing

Check that the column header matches and that the search value has the same format as the cell (for example, a phone number with or without +). Turn off Exact Match to test partial matches.

Find Rows returns only one row

Number of Rows defaults to 1. Raise it to get more matches.

Rows are written to the wrong columns

The sheet’s headers changed after you set up the action. Reopen the action, reselect the worksheet, and remap the columns.

Lookups are slow during calls

Reduce the sheet size or search a smaller tab, and use a fallback phrase so the contact isn’t left in silence.

Actions overview

Where each action runs and what data it can use.

Actions

Configure in-call action settings.

Triggers

Add contacts from new rows.

App Center

Manage connections.

Catalog

App Center

Telephony

Apps

Connect Google Sheets

Available actions

Rows

Cells & ranges

Spreadsheets & worksheets

Available triggers

Use Google Sheets in an agent

Look up data during a call (Find Rows)

Log every call (Add Row)

Best practices for lookup sheets

Troubleshooting

Actions overview

Actions

Triggers

App Center

​Connect Google Sheets

​Available actions

​Rows

​Cells & ranges

​Spreadsheets & worksheets

​Available triggers

​Use Google Sheets in an agent

​Look up data during a call (Find Rows)

​Log every call (Add Row)

​Best practices for lookup sheets

​Troubleshooting

​Related

Actions overview

Actions

Triggers

App Center

Connect Google Sheets

Available actions

Rows

Cells & ranges

Spreadsheets & worksheets

Available triggers

Use Google Sheets in an agent

Look up data during a call (Find Rows)

Log every call (Add Row)

Best practices for lookup sheets

Troubleshooting

Related