Connect Google Sheets to Infograph
What it brings in: worksheets.
What you need
- A Google account that can open the spreadsheet, as its owner or with at least view access.
- A Google Sheets file. Each tab you sync needs its column names in the first row and at least one row of data below them.
Steps
Open Google Sheets in Infograph
Choose Google Sheets and press Connect Google Sheets. The first time, a Google sign-in window opens.
Sign in and allow access
Sign in with the Google account that can open the spreadsheet, then press Allow. Infograph only reads the spreadsheets you choose in the next step, not the rest of your Drive.
Choose a spreadsheet
Google's own file picker opens on your spreadsheets. Pick one. It becomes its own connection in Infograph, named after the file. To sync another spreadsheet, connect Google Sheets again and pick that one.
Pick the tabs to sync
Infograph reads the spreadsheet's tabs and lists them. Pick the ones you want and each becomes a table. The first row of a tab becomes the column names, and numbers and dates keep their types. A tab can hold up to 500,000 rows and 5,000,000 cells.
What it syncs
Each becomes a table in Infolake that you can chart, report on or ask about. You choose which to sync.
- Worksheets
worksheets Each tab in the spreadsheets you pick becomes its own table, with the first row as column names and numbers and dates kept as numbers and dates. Refreshed in full on every sync.
Ask: “Which salesperson in our pipeline sheet has the most open deals?”
Troubleshooting
Each entry is the message Infograph shows when a connection fails. Open it for the fix.
Your browser blocked the sign-in window. Allow pop-ups for this site, then try again.
Infograph opens the sign-in in a small window, and your browser stopped it. Allow pop-ups for app.infograph.ai from the icon in the address bar or in your browser's site settings, then press Connect again. An ad blocker or privacy extension can block the window too: pause it for app.infograph.ai and try again.
Access was not allowed, so nothing was connected. Connect again and choose Allow.
The sign-in was answered with Cancel or Deny, so nothing was connected and Infograph holds no access. Press Connect again and choose Allow. Infograph uses the access only to read and sync your data.
Your account cannot read this data. Ask an admin of the account for access, then connect again.
Google would not let your account read the spreadsheet. Usually the owner removed you from it or changed who it is shared with. Ask the owner to share it with your Google account again, at least as a viewer, then connect again and pick the file.
Infograph's access was removed or has expired. Re-authenticate to resume syncing.
Infograph can no longer use your Google sign-in. Someone may have removed Infograph's access in your Google Account, your password changed, or your organisation's admin blocked the app. It also shows when Google keeps refusing a spreadsheet you lost access to. Press Re-authenticate, sign in with the same Google account and press Allow.
Common problems
These happen in Google Sheets itself, where Infograph cannot see them.
The spreadsheet is not in the picker
The picker lists Google Sheets files the account you signed in with can open. If the file is an Excel workbook stored in Drive, open it and choose File, then Save as Google Sheets, and pick the copy. If it belongs to someone else, ask them to share it with that Google account.
You signed in with the wrong Google account
Google uses whichever account it picked in the sign-in window, so the picker shows that account's files. Press Use a different account in Infograph and choose the right one.
Your organisation blocks the app
If Google says access is blocked or the app is not approved, your Google Workspace admin restricts third-party apps. Ask them to mark Infograph as Trusted in the Admin console, under Security, Access and data control, API controls, Manage App Access.