Sheets & databases
Send responses to Notion
Add every response as a row to a Notion database, with a column for every question.
The Notion integration creates a database inside a Notion page you choose and adds a row for every response. When someone edits their response, the row is updated.
Set it up
- Open Integrations in your dashboard, click Add an integration and choose Notion.
- Click Connect Notion. Notion asks which pages StrawPoll may use: pick the page the database should go in.
- Back in StrawPoll, choose that page and give the database a title.
- Choose the poll and whether to send new responses, changed responses or both, then save. StrawPoll creates the database in the page.
- Click Send test to add a sample row.
The page isn’t in the list? Click Share another page, and Notion lets you pick more pages for StrawPoll.
What a row looks like
| Column | What’s in it |
|---|---|
| Respondent | The respondent’s name, their email if there’s no name, or Anonymous |
| Submitted | When the response was sent |
| Email and Phone | Contact details, if the poll asked for them |
| Poll and Poll link | The poll’s name and address |
| One per question | The answer as text |
| Comment | The respondent’s comment |
| Response ID | StrawPoll’s ID for the response |
| Test | Ticked for rows added by Send test |
Each question becomes its own text column the first time it’s answered, so questions you add to a poll later get a column too.
Edited responses
When a respondent changes their response, StrawPoll finds the row with the same Response ID and updates it instead of adding a new one. Keep the Response ID column for this to work.
When a respondent deletes their response, its row moves to Notion’s trash. To keep such rows, turn off Response deleted.
Make the database your own
- Rename the database, add views, filters and your own columns. StrawPoll leaves columns it doesn’t fill alone.
- Rename the Respondent column if you like: StrawPoll always writes the name to the database’s title column.
- Filter out test rows with a view that hides rows where Test is ticked.
- If you change the type of a column StrawPoll fills, for example a question’s column to a select, StrawPoll writes that answer to a new text column instead of failing.
Your workspace stays private
StrawPoll can only see the pages you picked when connecting. It can’t open anything else in your workspace.
To take that access back, open Integrations, find your Notion workspace under Connected accounts and click Disconnect. You can also remove StrawPoll under Settings → Connections in Notion. The database stays in your workspace; integrations that used the connection stop sending until you reconnect.
If rows stop arriving
Open the integration and look at Recent deliveries for the error. Most often the database was deleted, or the page holding it is no longer shared with StrawPoll. Click Share another page to share it again, or delete the integration and add a new one.