Консоль
Integrations

Google Sheets

Write call results into Google Sheets through a service account

Status: Available in the Integrations catalog.

Google Sheets stores a team-level spreadsheet connection. After the service account is verified, AIVA refreshes tab metadata and lets you choose which headers an agent may fill.

What you need

  • the spreadsheet URL
  • the full Service Account JSON from Google Cloud
  • Editor access to the spreadsheet for the service account email

Prepare access

  1. Create a Google Cloud project and enable Google Sheets API.
  2. Create a service account and download its JSON key.
  3. Open the spreadsheet and grant the service account email the Editor role.

Add the integration

  1. Open Integrations -> Google Sheets -> Add integration.
  2. Fill in Title and Spreadsheet URL.
  3. Paste the full Service Account JSON.
  4. Save the integration.

If the connection can be checked immediately, the integration gets the Verified status.

After saving

  • Use Save connection after changing the spreadsheet URL or the JSON key.
  • Use Refresh metadata whenever you need AIVA to re-read the tabs and headers.
  • Choose the target tab for writing and enable only the headers AIVA should fill.
  • For each enabled header you can add an LLM instruction describing what to extract and how the final value should be formatted.
  • Save the field mapping.

Assign it to an agent

  1. Open the agent.
  2. In its integrations section, select the prepared Google Sheets integration.
  3. If the editor shows needs setup, finish the tab and field mapping in the integration detail page first.
  4. Save the agent.

Safe example

{
  "type": "service_account",
  "project_id": "aiva-docs-demo",
  "private_key_id": "demo-private-key-id",
  "private_key": "-----BEGIN PRIVATE KEY-----\nREDACTED\n-----END PRIVATE KEY-----\n",
  "client_email": "aiva-docs-demo@aiva-docs-demo.iam.gserviceaccount.com"
}
Spreadsheet URL: https://docs.google.com/spreadsheets/d/demo-spreadsheet-id/edit

If the spreadsheet cannot be verified

  • confirm the service account email was added to the exact spreadsheet
  • make sure you pasted the full JSON, not just the email
  • refresh metadata after changing headers in the first row