SquidSupport
Product reference / Settings

Google Sheets

In the app: Settings → Google Sheets

Needs the 'View Integrations' permission.

The list of Google spreadsheets Squid can read for your organization, and what the AI may do with each one. The list is shared by every store. The connection to Google itself is made on Settings → Integrations; this page only appears in the Settings menu once that connection is set up.

My Sheets

"My Sheets" lists every spreadsheet Squid knows about, sorted by name. A "Set up" badge next to the page title means Google Sheets is connected, through a connected Google account, through sharing with Squid's service account, or both.

Each row shows:

  • the spreadsheet's name, which opens the spreadsheet in Google in a new tab;
  • its "Slug" and its "AI visible" checkbox;
  • its worksheets (tabs), after "Worksheets:". Tabs that are hidden in Google are left out. A warning sign after a tab's name means the tab has more than 100,000 rows. The AI reads at most that many rows in one lookup, so matches further down can be missed. Split the tab into smaller ones.

A row with an amber background and the text "Access was removed. Restore access and refresh to use this sheet again." is a spreadsheet Squid can no longer open in Google, for example because sharing was withdrawn. Its "AI visible" checkbox is disabled until access is back.

"Refresh" asks Google again which spreadsheets Squid can open and updates names, worksheets and access. With a connected Google account, the spreadsheets in that account's Google Drive are found automatically on a refresh. Spreadsheets shared with the service account are only checked, never searched for. A refresh keeps each slug, "AI visible" choice and description. If part of the refresh fails, the message says which part, for example that the Google account needs reconnecting.

When Google Sheets is not connected, the page shows "Google Sheets isn't connected" with a "Set up on Integrations" button. When the status cannot be read, it shows "We couldn't load your spreadsheets" with "Try again"; that message says nothing about whether Google Sheets is connected.

Seeing this page needs the 'View Integrations' permission. Every change on it needs the 'Edit Integrations' permission; without it the controls are disabled.

Adding a spreadsheet

Needs the 'Edit Integrations' permission.

How a spreadsheet gets on the list depends on how Google Sheets was set up.

With a connected Google account, nothing needs adding: the account's spreadsheets appear after "Refresh".

With service-account sharing, each spreadsheet is added by hand:

  1. In Google, share the spreadsheet with the address shown after "Share the spreadsheet with", as Editor. The copy button next to the address copies it.
  2. Paste the spreadsheet's link, or its ID, in the field and click "Add sheet" or press Enter.

Squid then checks that it can open the spreadsheet. It refuses when:

  • the link is not a Google Sheets link or ID;
  • the spreadsheet is not shared with the service account, or is in the bin;
  • another Squid workspace has already registered the same spreadsheet through service-account sharing.

A new spreadsheet starts with a slug made from its name and with "AI visible" off.

When the list is empty the page says "No spreadsheets yet. Connect Google, or share a sheet with the service account and register it by link above."

Slug and AI visibility

Needs the 'Edit Integrations' permission.

"Slug" is the short name the AI uses to ask for this spreadsheet. It is saved when you leave the field. Squid rewrites what you type to lower-case letters, digits and underscores, at most 80 characters. If nothing usable remains, the slug becomes "sheet". Two spreadsheets cannot have the same slug; a duplicate is refused with "Sheet slug must be unique" and the old slug comes back.

"AI visible" decides whether the AI may use the spreadsheet. It is off for every new spreadsheet and is saved as soon as you tick or untick it.

When it is on, the AI is told about the spreadsheet, its slug and its worksheets, and can:

  • look up rows: it picks one worksheet and one column header from row one, and gets back every row where that column equals the value it is looking for, such as an order number. Matching ignores upper and lower case and spaces around the value. At most 25 matching rows come back per lookup;
  • add a row to a worksheet, but only when Squid has edit access to the spreadsheet. The new row must supply every named column from row one and must not include unknown columns; otherwise it is refused.

Both also need the matching AI tools to be switched on in the AI's configuration. "AI visible" on its own does not make the AI use a sheet.

When it is off, the AI does not know the spreadsheet exists. Other features that you point at a spreadsheet elsewhere, such as an outbound template, keep working.

"When should AI call this sheet?" appears when "AI visible" is on and Squid can open the spreadsheet. Describe in up to 500 characters what the spreadsheet holds and when the AI should look in it, for example "Contains current out-of-stock product information." It is saved when you leave the field.

Out-of-stock sheet

Needs the 'Edit Integrations' permission.

The "Make out-of-stock sheet" button marks one spreadsheet as the organization's out-of-stock sheet. The marked spreadsheet shows an "Out-of-stock sheet" badge instead of the button.

Only one spreadsheet can carry the mark. Marking another one moves it. There is no button to remove the mark without choosing another spreadsheet.

The button and the badge only show for organizations where the AI's out-of-stock offers are available, and only on spreadsheets Squid can open. The AI reads this spreadsheet to see which ordered items are out of stock before it makes an out-of-stock offer. It is read whether or not "AI visible" is ticked. This mark also identifies outbound templates that use this spreadsheet as out-of-stock templates, so Squid can recognise earlier offers and prevent repeat out-of-stock emails.

Removing a spreadsheet

Needs the 'Edit Integrations' permission.

The bin button on a row ("Remove from Squid") takes the spreadsheet off the list at once, without asking for confirmation. The AI no longer sees it and it stops being used as the out-of-stock sheet. Existing outbound templates and return or refund log destinations can still use it: removing it here does not clear those settings or revoke access in Google.

It does not change anything in Google. The spreadsheet, its contents and its sharing stay as they are.

A spreadsheet that was added by link comes back when you add its link again, with the slug and settings it had. A spreadsheet that came from a connected Google account does not come back on "Refresh".