Google Sheets
Use a spreadsheet you already keep, like a menu, a price list or a class schedule, as your site's data. Each tab is a collection, and the tab's first row holds the column names.
Connect
Google Sheets is a data source, so it connects through the Data panel. A project has one data source at a time.
- Open Settings > Connectors, click Google Sheets, then Connect. The Data panel opens on Google Sheets.
- Click Continue with Google, sign in and allow access.
- Pick one spreadsheet.
Only the spreadsheet you pick is shared with WebTwizz, and it stays private.
One Google account can serve both Google Sheets and Google Analytics, but each asks for its own permission the first time. If you signed in for Analytics first, the dashboard's Google Sheets page shows the account as Not allowed yet, with Allow Google Sheets.
What you see
Open sheet next to the connector's name opens the spreadsheet in Google Sheets.
- Overview: the spreadsheet's name, Each tab is a collection with the number of tabs and when it was last edited and by whom, and every tab with its row count. Tabs open in the Data panel. Open Data opens the panel, Open sheet opens the spreadsheet. Warnings show here when something needs you:
- Code and sheet don't match: your site's code uses tabs or columns the sheet no longer has. Ask the AI to update opens a new chat where the AI changes the code to the sheet's current names.
- Problems in a tab's first row, like a column with no name, a name used twice or an empty first row, and what each does to the site.
- Public link: anyone with the link can see, comment on or edit the sheet. The site doesn't need the link, so Make private turns it off: click Make private again to confirm. People you shared the sheet with by email keep their access.
- Latest in your first tab: its newest rows, from the bottom of the tab up, each with its row number. Click a row to see every column, named by the first row. Show more loads 10 more, and Open tab opens it in Google Sheets.
- Settings:
- Spreadsheet: the one this project uses. Pick another opens Google's picker, and asks first: click Use this sheet. Create a new sheet takes an optional Sheet name, your site's name if you leave it empty, and Create and use makes it in your Google Drive and switches to it. Either way, the old spreadsheet stays in your Google Drive.
What the AI can do
The AI treats your tabs like any other data: it builds pages from them and reads and writes rows through the Data panel's tools. Adding a column adds a header cell to the tab's first row.
Secrets
GOOGLE_SHEETS_REFRESH_TOKEN: lets your site read and write the spreadsheet, server-side only
Good to know
- Connecting another data source replaces Google Sheets in this project. Your spreadsheet stays as it is.
- Removing Google Sheets from a project stops the site using the spreadsheet. Nothing in Google Drive is deleted.