Google Sheets
Read and write data to Google Sheets.
Google Sheets is one of the most useful integrations. AI agents can look up rows to answer questions and add rows for orders or leads, and workflows can read or append rows.
Setup
The Google tools use your own Google Cloud OAuth app:
Important: "Access blocked" or a 403 error means the app is in testing and your email is not a test user. Add it, or publish the app.
- 1. In the Google Cloud Console, enable the Google Sheets API and the Google Drive API.
- 2. Set up the OAuth consent screen and add your Google email as a test user.
- 3. Create an OAuth client ID of type Web application and add the redirect URI from the setup guide exactly as written.
- 4. In Raqi, open Integrations & API, click Connect on Google Sheets, paste the Client ID and Client Secret, then sign in with Google.
Giving the Sheet to an Agent
Add the sheet as an Integration knowledge source on the agent. Set the Spreadsheet ID (from the sheet URL), the tab name and an optional read range (A1:Z100 by default). With Write turned on, describe when the agent should save a row and the column order.
Use Cases
Popular use cases for Google Sheets:
- Product catalog: products, prices and stock that the agent reads when customers ask.
- Order log: the agent or a workflow adds a row for each confirmed order.
- Lead tracking: save new leads with their details and channel.
- FAQ: questions and answers the agent can look up.
Was this article helpful?