Google Sheets Integration

The Google Sheets integration allows your Vapi assistant to interact with Google Sheets in a simple way:

1. Add new rows to existing Google Sheets

This enables your assistant to record information and add data to spreadsheets directly during phone calls.

Prerequisites

Before you can use the Google Sheets integration, you need to:

1. Have a Google Sheets account
2. Have access to the Vapi Dashboard
3. Have an assistant created in Vapi
4. Have a Google Sheet created and ready to receive data

Setup Steps

1. Connect Google Sheets Account

First, you need to connect your Google Sheets account to Vapi:

1. Navigate to the Vapi Dashboard
2. Go to Providers Keys > Tools Provider > Google Sheets
3. Click the Connect button
4. A Google authorization popup will appear
5. Follow the prompts to authorize Vapi to access your Google Sheets

2. Create and Configure Sheets Tool

After connecting your Google Sheets account, create and configure the tool:

1. Go to Dashboard > Tools page
2. Click the Create Tool button
3. Select Google Sheets from the available options
4. Choose the Google Sheets Add Row Tool
5. Provide a name and description explaining when it should be invoked
6. Configure the tool with the following required fields:
   • spreadsheetId: The ID of your Google Sheet
   • range: The sheet name or range (e.g., “Sheet1” or “Sheet1!A:Z”)

3. Add Tool to Assistant

Now, add the Google Sheets tool to your assistant:

1. Navigate to Dashboard > Assistants page
2. Select your assistant
3. Go to the Tools tab
4. In the tools dropdown, select the Google Sheets tool
5. Click Publish to save your changes

Tool Configuration

Google Sheets Add Row Tool

This tool uses the following fields to add data to your spreadsheet:

• spreadsheetId: The ID of your Google Sheet (found in the sheet’s URL)
• range: The range where the data should be added (e.g., “Sheet1” or “Sheet1!A:Z”)
• values: An array of values to be added as a new row

Example Usage

Here’s how the tool can be used in your assistant’s configuration:

1
{
2
  "model": {
3
    "provider": "openai",
4
    "model": "gpt-4o",
5
    "messages": [
6
      {
7
        "role": "system",
8
        "content": "You are a customer feedback assistant. After each customer service call, collect feedback using the following process:\n\n1. Ask the customer if they would like to provide feedback\n2. If yes, ask for their rating (1-5 stars)\n3. Ask for specific comments about their experience\n4. Ask for any suggestions for improvement\n5. Confirm the feedback before adding it to the spreadsheet\n\nUse the Add Row tool to record the feedback with the following columns:\n- Timestamp\n- Rating (1-5)\n- Comments\n- Suggestions\n\nAlways be polite and thank the customer for their feedback."
9
      }
10
    ],
11
    "tools": [
12
      {
13
        "type": "google.sheets.row.append",
14
        "name": "addFeedback",
15
        "description": "Use this tool to add customer feedback to the feedback spreadsheet. Collect all required information (rating, comments, suggestions) before adding the row."
16
      }
17
    ]
18
  }
19
}

Best Practices

1. Data Validation: Ensure all data is properly formatted before adding to the spreadsheet
2. Error Handling: Include fallback responses for cases where the tool fails
3. User Confirmation: Always confirm with the user before adding data to the spreadsheet
4. Sheet Structure: Be aware of the spreadsheet’s structure and column requirements