Custom Dashboard Automation via Spreadsheet Import: When the Data Doesn’t Live on a Connected Platform
Why "connected sources only" leaves real reporting data out
A marketing dashboard tool built only around OAuth-connected ad and analytics platforms handles a real slice of reporting need, but leaves out anything that does not happen to live on one of those platforms — a client’s own internally tracked numbers, a metric nobody has built a connector for, data manually compiled because the source system has no API at all. Centriu Dash’s spreadsheet import exists specifically to bring that data into the same dashboard as the connected sources, instead of leaving it in a separate, disconnected file.
How the underlying problem shows up before you fix it
A client’s own internally tracked metric has no home in the dashboard because it does not come from a connected ad or analytics platform.
A team maintains two separate reporting artifacts — a connected dashboard and a manually updated spreadsheet — because the tool cannot combine them.
A data source with no OAuth connector at all is simply left out of the dashboard entirely.
Updating the spreadsheet-based numbers means manually re-explaining them to a stakeholder outside the dashboard the rest of the team already trusts.
A one-off metric a client asks about occasionally does not justify building a dedicated connector, but still needs a place to live.
Why this keeps happening without a spreadsheet-import option
Dashboard tools built purely around OAuth connectors are structurally limited to whatever platforms have a connector built for them — anything else has no path into the dashboard at all. Without a way to bring in CSV, TSV or a live spreadsheet link using the same widget system as connected sources, that data stays permanently separate, in its own file, disconnected from the reporting the rest of the team relies on.
How Centriu Dash builds a dashboard from spreadsheet data
Dash accepts manual import of CSV or TSV files, or a live Google Sheets link, and builds widgets from that data the same way it does from a connected platform — a KPI, line, bar, donut or table widget tied to a source and a metric, created by form, not drag-and-drop. That means a spreadsheet-sourced metric sits in the same dashboard, built with the same template-based tools, as data pulled from Google Ads or GA4 — not a separate, disconnected artifact.
Updates from a spreadsheet import happen on the schedule the data is refreshed or re-imported — like every source in Dash, this is periodic reporting, never described as real-time.
What is actually built today
Manual import of CSV or TSV files into a dashboard.
A live Google Sheets link as a data source.
The same template-based widget system (KPI, line, bar, donut, table) for spreadsheet-sourced data as for connected platforms.
Spreadsheet-sourced widgets combined in the same dashboard as OAuth-connected sources.
An agency reporting on a client’s internally tracked sales figures (illustrative scenario, not a real client)
A client tracks a specific internal sales figure in their own spreadsheet — a number with no connected platform to pull from automatically. The agency links that spreadsheet as a live Google Sheets source in Dash and builds a line-chart widget from it, sitting in the same dashboard as the client’s Google Ads and GA4 widgets.
When the client updates their spreadsheet weekly, the widget reflects the refreshed data on Dash’s periodic update schedule — the agency is not manually re-explaining a separate file to the client outside the dashboard the rest of the reporting lives in.
A different, one-off metric the client occasionally asks about gets a quick CSV import rather than requiring a dedicated connector be built for a single infrequent question.
What changes operationally
The structural change is spreadsheet-sourced data sitting inside the same dashboard as connected platforms, instead of living permanently in a separate, disconnected file. What that is worth in reporting clarity depends heavily on how much of a team’s reporting data actually lives outside connected platforms — Centriu does not attach a specific figure that would generalize.
When this is not the right fit
A team whose entire reporting need is covered by Dash’s connected platforms, with no spreadsheet-sourced data at all, will not need this specific capability — though it remains available if that ever changes.
Two disconnected reporting artifacts vs. one dashboard covering both
When a dashboard tool only handles connected platforms, any spreadsheet-sourced metric ends up living in a separate file the rest of the team has to check independently. Centriu Dash’s spreadsheet import brings that data into the same dashboard, built with the same widget system as everything else.
Related systems
Main system: Centriu Dash.
What it does NOT do
- Does not update spreadsheet-sourced widgets in real time — like every Dash source, updates are periodic, on a refresh or re-import schedule.
- Does not build a widget automatically from an unstructured file — the data still needs to be organized as CSV, TSV or a structured Google Sheet.
- Does not connect to a spreadsheet without the appropriate access being granted — a live Google Sheets link requires the sheet to be shared appropriately.
- Does not merge dashboard or spreadsheet data across different accounts using Dash — each account only sees its own dashboards.
Security and governance
Each account using Centriu Dash only sees its own dashboards and connected or imported data sources — nothing is shared across accounts. Data brought in through spreadsheet import follows Brazil’s LGPD (Law No. 13,709/2018). Full detail on access control and audit trails lives at /governanca and /iso.
Pricing and contracting
Available by monthly subscription, with tiered plans. Values and terms come from the official pricing table at /precos (Centriu's central source — never restated here).
Frequently asked questions
Can Dash build a dashboard from data with no OAuth connector?
Yes — by importing a CSV or TSV file, or linking a live Google Sheet.
Does spreadsheet-sourced data use the same widgets as connected platforms?
Yes — KPI, line, bar, donut and table widgets are built the same way, by form, regardless of the source.
Does a Google Sheets link update in real time?
No — like every Dash source, updates happen periodically, on a refresh or re-import schedule.
Can spreadsheet data and connected-platform data sit in the same dashboard?
Yes — both use the same underlying widget system, side by side.
What does Centriu Dash cost?
It is sold by subscription with a published starting price — exact current values are on the central pricing page.
See how Centriu Dash builds dashboards from spreadsheet data
Reach our commercial team directly, or leave your details below — we'll follow up with guidance for your case.