Skip to content
OrbContext
19 pages

Guide

Google Sheets

Connect a price list, stock or menu so answers follow your edits.

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

  1. 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.

  2. Check that the first row has column names

    Row 1 should name each column, such as Item, Price and Stock. Your data goes in the rows below. See how to lay it out for what works best.

Connect the sheet

  1. 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.

  2. 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.

  3. 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.

  4. 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".

  5. 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.