Keep your prices, stock or menu in the Google Sheet you already use. Connect it once, and when you change a cell your bot's answers follow, usually within the hour. It takes about two minutes, and you don't sign in to anything or give us access to your Google account.
Before you connect: get your sheet ready
Put your data in a Google Sheet
Open Google Sheets and use the sheet that holds your price list, stock or menu. If yours is an Excel file, open it in Google Drive and choose File → Save as Google Sheets. Google explains how. Once it's converted, edit the Google Sheet from then on.
You should see: your data in a normal Google Sheet, with a title at the top.
Check that the first row has column names
Row 1 should name each column, such as
Item,PriceandStock. Your data goes in the rows below. See how to lay it out for what works best.
Connect the sheet
Open the Knowledge tab and copy our address
In the OrbContext dashboard, open your bot and choose Knowledge. In the Google Sheet box, press the copy button next to the OrbContext Google address.
You should see: the address, ending in
iam.gserviceaccount.com, and a "Copied" confirmation. If the box isn't there, Google Sheets isn't switched on for your OrbContext yet. Contact support.Share your sheet with that address
Go back to your sheet and choose the green Share button at the top right. Paste the address, change the role to Viewer, untick Notify people (nobody reads that mailbox), and choose Share. Google's own guide to sharing files shows the same dialog.
You should see: the address listed under "People with access" as a Viewer. If Google warns that the address is outside your organisation, choose Share anyway. If your company blocks sharing outside the domain, ask your Google Workspace admin to allow it for this address.
You don't need to make the sheet public. Leave "Anyone with the link" off if the data is private.
Copy your sheet's link
Copy the link from your browser's address bar. It looks like
https://docs.google.com/spreadsheets/d/…/edit. To read only one tab, open that tab first, so the link ends in#gid=…. To read every tab, use the link as it is.Paste it into OrbContext and connect
Paste the link into the Google Sheet box and choose Connect sheet.
You should see: the sheet appear in your knowledge list as Google Sheet, with a status that goes from Queued to Ready within a minute or so. The name then shows the number of rows read, such as "Cafe menu · 42 rows".
Test it
Open the Playground and ask something your sheet answers, such as "How much is the margherita?". Then change that price in your sheet, choose the refresh icon on the sheet in your knowledge list (Sync now), wait for it to say Ready, and ask again.
You should see: the new price in the answer.
Set your sheet up so answers are good
Each row becomes one fact, written with its column names. So a row like Margherita | ₹299 | In stock is read as Item: Margherita; Price: ₹299; Availability: In stock.
- Put column names in the first row (Item, Price, Stock). They are what your bot uses to understand each value.
- One thing per row. Avoid merged cells, and repeat the name on each row instead of leaving it blank below.
- Write units where they matter (₹, kg, per month), since your bot repeats what it reads.
- Keep the sheet tidy. A tab can have up to 5,000 rows and 52 columns, and each sheet reads up to 8 visible tabs. Hidden tabs are skipped, so use one for notes you don't want shared with customers.
- Formulas show their current values, as you see them in the sheet. Charts and images are ignored.
How fresh are the answers?
OrbContext checks each connected sheet every hour. If nothing changed, it stops there, which costs nothing. If something changed, your bot's knowledge is rebuilt beside the live version and swapped in when it's ready, so your bot is never without an answer.
- To see a change right away, choose the refresh icon on the sheet in your knowledge list (Sync now).
- To pause checking, set Re-sync to Off on the sheet.
- A change costs credits like any other document, based on the sheet's size. A sheet that didn't change costs none.
Questions
- Is it free? Connecting is free. A change to the sheet uses credits like any other document, based on its size. A sheet that didn't change costs nothing.
- Can I connect more than one sheet? Yes. Each sheet is its own item in your knowledge list and counts toward your plan's document limit.
- Can customers see my sheet? No. Your bot only repeats what answers a customer's question. Don't put anything in the sheet you wouldn't want the bot to say. Keep private notes on a hidden tab, which is skipped.
- Do I have to keep the sheet shared? Yes. If you remove our address, the bot keeps the last version it read and shows an error under the sheet until you share it again.
- What if I rename or move the sheet? Nothing breaks. We follow the sheet, not its name or folder. The name in OrbContext updates the next time it changes.
Troubleshooting
- "We can't open this sheet." The sheet isn't shared with the OrbContext address yet, or it was shared with a different one. Share it again as Viewer and connect.
- "That isn't a Google Sheets link." Use the link from a sheet's address bar. Excel files stored in Drive, Docs and folders aren't supported. Open an Excel file in Google Sheets and choose File → Save as Google Sheets first.
- Answers show an old value. Choose Sync now. If the sheet shows an error under it, it stopped being shared or was deleted. Your bot keeps answering from the last version it read until you fix it.
- "This sheet has no rows to read." Put column names in the first row and your data below it.
- The sheet is too big. Link a single tab with fewer than 5,000 rows, or split the data across several sheets.
Disconnect
Delete the sheet from your knowledge list and your bot stops answering from it. To also revoke access, remove the OrbContext address from the sheet's Share settings.