Currently trying to have the AI record information as values to input into Google Sheets with the tool. There's no Value section for the Dashboard though, it just asks for a SheetID and for a Range, but there's no way to edit the parameters or what it should be recording in each column. That code currently looks like this: { "id": "1176d4af-d822-4316-a262-0dcf983693ed", "createdAt": "2025-09-30T18:12:09.726Z", "updatedAt": "2025-09-30T18:14:18.864Z", "type": "google.sheets.row.append", "function": { "name": "quote_intake_submit", "description": "Use this tool to record a completed rental quote request from a customer into the Google Sheets “Quote Submissions” spreadsheet.\n\nCollect all required information from the customer first — including full name, phone, email, equipment type, lift height, rental start date, rental duration, jobsite ZIP, whether delivery is required, and the source channel. Optional details such as company name, model requested, capacity, fuel type, terrain, address, urgency, referral source, budget notes, and special delivery constraints can also be included.\n\nOnly invoke this tool once all required fields have been confirmed with the customer. The tool will then append a new row with all these values to the Google Sheet. Do not use this tool for reading or modifying existing data — it is for adding new rows only.\n\nAlways confirm the data with the customer before submitting, and thank them for providing their details.", "parameters": { "type": "object", "properties": {}, "required": [] } }, "messages": [ { "type": "request-start", "blocking": false } ], "metadata": { "spreadsheetId": "1oILmK0hL1iWY5dZwS8xbTZhKTsFuKmQVP8nEFQ6Jmto", "range": "Quote Submissions!A:Z" }, "orgId": "4a55f79e-5729-427d-a231-8c7c7b172c7b" }

Hi jrdnEquipmentGiant, To integrate your Vapi assistant with Google Sheets for adding new rows, follow these steps: 1. **Connect Google Sheets Account**: Navigate to the Vapi Dashboard, go to

Providers Keys > Tools Provider > Google Sheets

, and click the Connect button. Follow the prompts to authorize Vapi. 2. **Create and Configure Sheets Tool**: - Go to the Dashboard, select the Tools page, and click

Create Tool

. - Choose

Google Sheets

and select

Google Sheets Add Row Tool

. - Configure it with: - `spreadsheetId`: Found in the URL of your Google Sheet. - `range`: Specify as sheet name (e.g., "Sheet1") or with a range (e.g., "Sheet1!A:Z"). 3. **Add Tool to Assistant**: - Go to

Dashboard > Assistants

, select the relevant assistant, and open the

Tools

tab. - Select your configured Google Sheets tool and click

Publish

. This process allows your assistant to add new rows to your spreadsheet automatically. For more details, you can reference the [Google Sheets Integration documentation](https://docs.vapi.ai/tools/google-sheets).

Every time I connect to google sheets, it sort of does nothing.

There's no Provider Keys

There have been some changes to the UI Dashboard recently and the provider keys section has been moved to the Build section of the navigation panel, under the ellipsis (...) menu. You can find it here now -->