Custom Tool to Read a Google Sheet
# prompt-tip
l
I want to read a customer's name from a Google Sheet, the name read should be determined by the number that's calling in. I can do this with Make, but I have a large volume of calls and would rather not increase my expenses if I don't have to. The Google Sheets tool in VAPI can only add rows to a Google Sheet. Anyone have a custom tool or understand how to make one?
r
Hi Logos, If you're looking to set up the Google Sheets integration with your Vapi assistant, you can follow these steps: 1. Connect Your Google Sheets Account: - Go to the Vapi Dashboard and navigate to Providers Keys > Tools Provider > Google Sheets. - Click Connect and follow the authorization prompts. 2. Create and Configure the Sheets Tool: - In the Dashboard, click on Tools, then Create Tool. - Select Google Sheets, choose the Add Row Tool, and complete the configuration with your
spreadsheetId
and
range
. 3. Add the Tool to Your Assistant: - Go to the Assistants page, select your assistant, then under the Tools tab, add the Google Sheets tool and publish your changes. For detailed steps, please refer to the full [Google Sheets Integration documentation](https://docs.vapi.ai/tools/google-sheets).