Google Sheets

Connect Google Sheets to deliver call data to a spreadsheet, one row per call, with no coding. It is a two-part setup: connect your Google account, then attach the sheet as a post-call delivery destination on your agent.

Step 1 always happens here in the dashboard, once. Step 2 you can do here, or from your own code over the API.

Step 1: connect your Google account

Open the integrations page

Go to the Integrations page (or your agent's Integrations tab) and find the Google Sheets card.

Connect

Enter an integration name, click Connect with Google Sheets, and authorize access in the Google popup.

Step 2: deliver calls to a sheet

Open the agent's Post-Call tab

On your agent's edit page, open the Post-Call tab and add a delivery configuration.

Choose Google Sheets

Set Delivery method to Google Sheets, then select the Google account you connected in step 1.

Point it at a spreadsheet

Paste the spreadsheet URL or ID and connect it, then pick the worksheet (defaults to Sheet1).

Choose what to include

Optionally include the summary, full conversation, sentiment, and extracted variables. Save the configuration.

What lands in the sheet

Each completed call appends one row. Columns always include the call id and date, phone numbers, agent name, direction, status, duration, whether the call was transferred, and the recording link. If you enabled them, the row also carries the summary, sentiment, extracted variables, and full transcript. For bulk campaigns, campaign name and retry count are added too.

The header row is managed for you: it is created from the first call's fields, and new columns are added automatically if later calls include new fields.

Set it up over the API

You connect Google once, in the dashboard (Step 1). From then on, your code can add the sheet to any agent with two ids: the connection's integration_id and the sheet's spreadsheet_id.

Find the connection's id

API reference: List integrations

curl "https://omnidim.io/api/v1/integrations" \
  -H "Authorization: Bearer YOUR_API_KEY"

Pick the entry whose integration_type is google_sheets and note its id. Keep it: the same id works for every agent.

Add the sheet to an agent

API reference: Add a post-call action

curl -X POST "https://omnidim.io/api/v1/agents/158910/post-call-actions" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "type": "google_sheets",
    "integration_id": 812,
    "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
    "worksheet_name": "Calls",
    "include": ["summary", "extracted_variables"]
  }'

The spreadsheet_id is the part of the sheet's link after /d/. The tab defaults to Sheet1 if you leave out worksheet_name. The agent's other post-call actions are not touched.

Repeat for other agents

Send the same request with another agent's id. You don't connect Google again.

If Google access expires or is revoked, new Sheets actions are refused with "The Google Sheets connection needs to be reconnected." Reconnect it in Step 1, look up its id again, and retry.

For changing and removing actions, see Post-call actions over the API.

Was this page helpful?

Google Sheets

On this page