Sheets & databases
Send responses to Google Sheets
Add every response as a row to a spreadsheet in your Google Drive, and keep it up to date when responses are edited.
The Google Sheets integration creates a spreadsheet in your Drive and adds a row for every new response, with a column for every question. When a response is edited, its row is updated.
Set it up
- Open Integrations in your dashboard, click Add an integration and choose Google Sheets.
- Click Connect Google and sign in with the Google account whose Drive the spreadsheet should go in.
- Back in StrawPoll, pick that account and give the spreadsheet a title.
- Choose the poll and whether to send new responses, changed responses or both, then save. StrawPoll creates the spreadsheet in your Drive.
- Click Send test. A test row shows up in the spreadsheet.
The integration’s page links straight to the spreadsheet. You can rename it or move it to another folder in your Drive; responses keep arriving.
What a row looks like
| Column | What’s in it |
|---|---|
| Submitted (UTC) | When the response was sent, like 2026-11-08 14:05, in UTC |
| Respondent | The respondent’s name, their email if there’s no name, or Anonymous |
| One per question | The answer as text, the way it reads in your results |
| Comment | The respondent’s comment, added the first time someone leaves one |
| Response ID | StrawPoll’s ID for the response |
| Updated (UTC) | When the response was last edited, added the first time one is edited |
The first row holds the column names, in bold and frozen. When you add a question to a poll later, its column is added at the end with the next response. Two questions with the same text get separate columns, the second named like Question (2).
Answers are always stored as plain text. One that starts with = stays text and is never run as a formula.
Things to know
- Edits update the row. When someone edits their response, StrawPoll finds its row by the Response ID and overwrites the answers there. Columns you added yourself keep what you typed. Keep the Response ID column, or edits arrive as new rows. To leave rows as they were first sent, turn off Response changed.
- Deleted responses remove the row. When a respondent deletes their response, StrawPoll removes the row with its Response ID, including anything you typed in it. To keep such rows, turn off Response deleted.
- Test rows say (test) after the respondent’s name, so you can delete them or filter them out.
- Responses go to the first tab. Rename it if you like, but keep it first. You can add your own tabs after it, with charts or formulas that read from it.
- Columns are matched by name. You can add your own columns or reorder them. If you rename a column StrawPoll fills, it adds a new one with the original name next time.
- One spreadsheet per integration. To send several polls to separate spreadsheets, add an integration for each poll.
Your Drive stays private
StrawPoll asks Google only for access to files it creates itself. It can’t see, open or change anything else in your Drive.
To take that access back, open Integrations, find your Google account under Connected accounts and click Disconnect. The spreadsheet stays in your Drive; integrations that used the account stop sending until you reconnect.
If rows stop arriving
Open the integration and look at Recent deliveries for the error.
- The Google account was disconnected: reconnect it under Connected accounts.
- Google refused the request: you may have removed StrawPoll’s access in your Google account settings. Reconnect the account.
- The spreadsheet was deleted or moved to the trash: restore it from the trash, or delete the integration and add a new one, which creates a new spreadsheet.