Skip to main content

​
Why did some of my Google Sheets columns get renamed in Adriel?

Column headers are sanitized when the sheet is imported, so a field name in Adriel can differ from the header in the sheet. Several rules apply during import:
  • Special characters that are not allowed in field names are stripped or replaced.
  • A header that collides with a reserved internal name is given a suffix to keep it distinct.
  • Duplicate headers are de-duplicated with a numbered suffix, so a second Revenue header becomes Revenue (2).
  • An empty header cell is named column_1, column_2, and so on, by position.
  • A very long header is shortened and given a short hash suffix to stay within the storage limit.
Where possible, the original header is still shown in the widget builder, and Adriel maps between the displayed header and the stored field automatically. Renaming a column in the sheet updates the matching field after the next refresh.

​
Why don’t my latest sheet edits appear on the dashboard right away?

The connector reads a cached snapshot of the tab rather than the live sheet, so a newly-typed value is not immediate. Edits appear after the next scheduled refresh. To pull the latest values sooner, a manual refresh is available from the data-source settings. For the refresh schedule, see the Google Sheets data reference.

​
Why do rows I deleted in the sheet still show on my dashboard?

Each refresh replaces the entire cached copy of the tab in one step rather than merging changes row by row. A row removed from the sheet is still part of the previous snapshot, so it remains on the dashboard until the next successful refresh rebuilds the cache without it. The same applies to a renamed column: the field updates only after the next refresh. A manual refresh brings the cache back in line with the current sheet.

​
How can I report on more than one tab from the same spreadsheet?

Each data source imports a single tab. To bring in a second tab, connect it as an additional data source and point the connection at that tab. The same Google authorization covers every spreadsheet and tab the authorizing account can read, so a second tab does not require a separate sign-in. Once both tabs are connected, their fields can be combined on the same dashboard through separate widgets.
The connector reads Google Sheets format only. A spreadsheet in XLSX, ODS, or another format has to be opened and saved as a Google Sheet first, so that it can be read through the Google Sheets API.

​
Why did my sync fail with an invalid date error?

When a column is mapped as the date field during setup, every cell in that column is checked against the expected date format on each refresh. If a cell does not match the format, the sync stops and reports the column, the offending value, and the format it expected, so the cell can be corrected in the sheet. Common spreadsheet error markers in the date column — for example #NUM! or #VALUE! — and blank cells are skipped rather than failing the sync. A tab with no mapped date column is treated as a single snapshot with no date-range filtering, so date validation does not apply. For the general checks that apply to any type-related sync failure, see Column type mismatch.

​
Why did my Google Sheets data source disconnect?

A Google Sheets data source disconnects when Adriel can no longer reach the exact tab it was bound to, or when its access to Google is lost. The common causes are:
  • The selected tab was deleted. Renaming the tab is handled automatically and does not disconnect the data source, but deleting it does.
  • The authorizing account lost permission to open the spreadsheet.
  • The Google authorization was revoked or expired, or a Google Workspace admin policy now blocks it.
Reconnecting restores the data source. For the reconnection steps, see How to connect Google Sheets. If a sync still fails after reconnecting and the sheet, tab, and access all look correct, email support@adriel.com with the spreadsheet URL, the tab name, and the affected dashboard URL.

​
Common issues

Google Sheets values are inferred as text whenever the cell format contains a symbol Adriel can’t parse — the % symbol, or numbers stored in scientific notation like 3.13E+10. Widgets that expect a numeric metric then error or fall back to no data.
  • For percent columns, set the data type to parsedPercentage on the data source and configure the aggregation method (for example, weighted average). Percent-type fields are not automatically aggregated across breakdowns.
  • For number columns, the entire column must contain valid numeric values.
  • If no date column is mapped on the Google Sheets data source, Adriel doesn’t know which column to filter on and cannot apply the dashboard date range.
For the general checks that apply to any type-related import problem, see Column type mismatch.
The Google Sheets API only reads native Google Sheets.
  • Files stored in Google Drive as XLSX have to be opened and re-saved via File > Save as Google Sheets, then the converted sheet connected.
  • When creating the connection with write access, every referenced sheet must be shared with the connecting user as Editor. If any sheet is view-only, the permission conflict prevents the sync from succeeding — either create the connection without write access, or upgrade the user’s permission on every source sheet to Editor.
Google Sheets data sources need to complete their first sync before rows appear. If a sheet is empty in Adriel right after connecting, waiting for the initial sync usually resolves it with no configuration change needed.
Google Apps Script OAuth errors come from the customer’s own Google Cloud or Workspace OAuth configuration, not from Adriel. Things to check on the customer side:
  • Apps Script OAuth scopes and appsscript.json permissions.
  • The linked Google Cloud project’s OAuth consent screen (Audience, Publishing status, Test users).
  • Workspace admin app access controls.

How to connect Google Sheets

Connect a spreadsheet and tab, and reconnect after an authorization loss.

Google Sheets data reference

Import model, field type mapping, refresh schedule, and limits.

Refresh strategies

How cached data sources refresh and when new values appear.

Data history and retention

How much historical data Adriel stores and for how long.