Sync a widget with Google Sheets
You can use Google Sheets two ways with a widget: send responses into a sheet, or show a sheet's live data inside the widget. Each uses a different connection, so pick the one that matches what you want.
Before you start
- A widget open in the editor.
- A Google account that can access the spreadsheet.
- Your browser allowed to open pop-ups from Embeddable. Google sign-in appears in a pop-up window.
Connect Google (to send responses)
- Open your widget in the editor.
- In the chat, ask the assistant to send your widget's responses to Google Sheets. You can also open the Integrations panel in the sidebar and select Google Sheets.
- A Google Sheets connection card appears in the chat. Click its connect button.
- A Google pop-up opens. Choose your Google account and approve the access request. The access Embeddable asks for is the ability to write to your sheets.
- When the pop-up closes, the card shows that Google Sheets is connected.
If the card shows a failure instead, check that your browser didn't block the pop-up, then try connecting again.
Choose a sheet
For sending responses, once Google is connected, keep chatting with the assistant and say which spreadsheet and tab the responses should go to, and which fields should become columns. The assistant sets up the mapping for you.
For showing data, you choose the sheet by publishing it first. Publishing is done in Google Sheets, not in Embeddable:
- In Google Sheets, open the spreadsheet you want to display.
- Go to File, then Share, then Publish to web.
- Under the publish options, select the tab you want to use and choose Comma-separated values (.csv) as the format.
- Click Publish and copy the link Google gives you.
Each published link points to one tab. If you want data from a different tab, publish that tab and use its link.
Sync data
Send new responses
After the connection and sheet are set up, new responses from your widget are sent to the sheet you chose. To check it, submit a test response through your widget, then open the spreadsheet and look for the new row.
Read live data
- In the editor chat, ask the assistant to show data from a Google Sheet in your widget. A connection card appears for the Sheets integration.
- Paste the published link you copied into the field labeled Google Sheets CSV/published URL, then save it. The link is stored as a credential, and you can show or hide it while typing using the eye icon.
- Tell the assistant how to display the data, for example as a list, a table, or a set of cards.
The widget fetches the data from your published sheet, so changes you make to the sheet appear in the widget without you editing the widget.
Reading data does not require signing in to Google. Anyone with the published link can see what the sheet contains, so don't publish tabs with private information.
Expected result
- Sending responses: each new response appears as a row in your spreadsheet.
- Showing data: your widget displays the current contents of the published tab.
Change or remove a connection
Once connected, the card in the chat shows controls to edit or delete the connection. Use edit to paste a new published link, for example if you published a different tab. Use delete to disconnect the sheet from the widget.
Did this answer your question?
Your feedback helps us improve.
