Google Sheets
The Google Sheets integration lets your bot read from a spreadsheet — handy for price lists, inventory, FAQs or anything you already maintain in Sheets. You connect once with Google, choose what to expose, and the bot answers from it.
Connecting#
Open the Google Sheets tab
Go to Integrations → Google Sheets.Authorize with Google
Sign in and grant access. VirtuOps uses OAuth — your credentials are never stored, and you can revoke access from your Google account at any time.Pick a sheet
Connect an existing spreadsheet or create a new one to fill in.
Choosing what to expose#
After connecting, configure how the bot reads the sheet:
- Visible columns — select which columns the bot can see, so internal notes stay private.
- Data range / format — set where the data lives so retrieval stays accurate.
Headers matter
Clear column headers help the bot understand each field. Treat the first row as labels the AI will reason about.Linking tables#
You can link one table to another so a single AI action updates both at once — for example an Orders sheet linked to an Inventory sheet, so every new order also decreases stock. The linked table can be another Google Sheet or a Notion database.
Pick a linked resource
In the sheet's settings, open Linked resource (optional) and choose the table to link.Auto-link with AI
Describe the rule in plain words — e.g. “when a new order is added, decrease product stock by quantity” — and click Auto-link. The AI proposes the column mapping for you to confirm or adjust.Match by & Apply amount
Set Match by (the field that joins the two tables, e.g. product name or SKU) and Apply amount (the number to change), then pick+or−for the operation.
One action, two tables
Once linked, the bot exposes a single composite action that finds the matching row in the linked table and applies the change there automatically.Test & attach#
Run a test query to confirm the bot reads the right values, then attach the integration to a bot from its Tools & integrations settings. Edits you make in the sheet are picked up on the next read — no re-upload needed.