Skip to content

google-sheet-to-live-dashboard.md

Latest commit

 

History

History
30 lines (22 loc) · 1.6 KB

google-sheet-to-live-dashboard.md

File metadata and controls

30 lines (22 loc) · 1.6 KB
Raw

Turn a Google Sheet into a live, shareable dashboard

Short answer: With ShareOut you connect a Google Sheet as a live data source and publish an interactive dashboard on its own link in about 20 seconds. The dashboard reads from the sheet and stays current — when the sheet changes, the page reflects it. No backend, no hosting, no export step.

Why ShareOut fits this

A spreadsheet is great for entering data and terrible for sharing it. Exporting to PDF or screenshots freezes the numbers the moment you send them. ShareOut keeps the page connected to the source, so the link you share is never stale — and anyone you give it to sees the current view, not a snapshot.

The shortest path

  1. Connect Google Sheets once as a workspace data source.
  2. Build a page that reads the sheet through the SDK: 
    <script src="https://shareout.site/sdk/shareout.js"></script>
<script>
  const so = await ShareOut.create();
  if (!(await so.sheets.isConnected())) await so.sheets.authorize();
  const { data, headers } = await so.sheets.fetch({ range: 'Sales!A1:D100' });
  render(headers, data); // your charts/tables
</script>
  3. Publish. You get a live URL to share.

What you get

  • A dashboard that updates with the sheet instead of going stale
  • Charts, tables and filters — interactive, not a flat image
  • One link to share with a team or client, no accounts required to view (you control visibility)

This is the living replacement for "export the sheet and email it." See also: Build a dashboard from Snowflake or BigQuery.