Connect Google SheetsBusiness plan
On My Data → Add data → Connect a warehouse or database, choose Copy — bring it into Cognizon, then Google Sheets. You share the spreadsheet with Cognizon's address, and Cognizon copies the named tab into your workspace once a day — it never writes back to the sheet.
Before you start
- In Google Sheets, choose Share and add Cognizon's service account address as a Viewer. (The exact address is shown in the connect form's access note — Cognizon's own access has no inherent reach into any spreadsheet; it can only read what you explicitly share with it.)
- Prefer to use your own Google service account instead? You can paste its JSON key in the form rather than sharing with Cognizon's address.
- Connecting Google Sheets requires a plan with connectors enabled (Business or Enterprise).
Steps
- On My Data, open Add data → Connect a warehouse or database, then choose Copy — bring it into Cognizon.
- Set Source type to Google Sheets.
- Fill in Name, Spreadsheet link (paste the URL from your browser), Tab (optional — leave blank to use the first tab), and, only if you'd rather use your own identity, Service account key (JSON) (optional).
- Click Test connection. Cognizon opens the spreadsheet, reads the named tab's header row and a sample of rows, and reports the column count, a row estimate, and when the sheet was last edited.
- Click Connect source. Cognizon copies the tab into your workspace and refreshes it once a day; a manual refresh action is also available afterwards.
Good to know
- Every refresh is a full replace of the tab's rows, not an incremental append — a spreadsheet is edited in place with no stable row key, so appending would duplicate corrected rows and miss deletions.
- A worksheet is capped at a maximum row count per copy; a sheet beyond that belongs in a database, not a spreadsheet tab.
- The first row of the tab must name the columns — a tab with no header row, or an empty tab, fails the test.
- A given spreadsheet can only be connected into one workspace at a time.
- Connecting Google Sheets requires a plan with connectors enabled (Business or Enterprise).
FAQ
Does Cognizon ever write back to my spreadsheet?
No. Cognizon only reads the tab you name; it copies rows into your workspace and never modifies the sheet.
How often does the copy refresh?
Once a day automatically, plus a manual refresh action whenever you want the latest edit sooner.
My spreadsheet has several tabs. Which one does Cognizon read?
Whichever one you name in the Tab field. Leave it blank and Cognizon uses the first tab.
What if I don't want to share my sheet with Cognizon's address?
Paste your own Google service account's JSON key in the connect form instead, and Cognizon reads as that identity rather than its own.
Can two workspaces connect the same spreadsheet?
No — a spreadsheet can only be connected into one workspace at a time, which closes off a former teammate's old connection reaching your current data.