Help & Guides
Publishing a Google Sheet
- Open your Google Sheet.
- Go to File → Share → Publish to web.
- Choose the sheet/tab you want to publish and click Publish.
- Copy the link it gives you and paste it into SheetDash AI.
Finding a sheet's gid
The gid identifies a specific tab. Open the tab you want, and look at the browser address bar — the number after #gid= is the tab's gid. SheetDash AI extracts this automatically when you paste a normal sheet link.
Creating an OpenAI API key
Sign in at platform.openai.com, open API keys under your account, and create a new secret key. Paste it into the AI step of the dashboard wizard or into Settings → OpenAI. Your key is encrypted before it's stored and is never shown again in full.
How dashboard generation works
AI only runs when you explicitly generate or improve a dashboard. It receives your column names, detected types and a small sample of rows — never your entire spreadsheet — and returns a dashboard layout, which is validated before it's saved. Opening or filtering a saved dashboard never calls AI.
Why AI isn't used on every view
Dashboards read live data straight from your Google Sheet every time they're opened, using the configuration AI (or you) already saved. This keeps dashboards fast, free of unnecessary AI costs, and consistent for everyone viewing them.
How public sharing works
From a dashboard's Share menu you can make it Public (anyone with the link can view) or Password-protected. Shared dashboards never expose your email, sheet URL, API key or internal IDs — only the widgets you chose to publish.
Fixing invalid spreadsheet data
SheetDash AI automatically trims spaces, strips currency symbols and commas from numbers, and recognizes common date formats. If a column still looks wrong, open the dashboard's Data Review step and correct its type manually.