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

  1. Open Integrations in your dashboard, click Add an integration and choose Notion.
  2. Click Connect Notion. Notion asks which pages StrawPoll may use: pick the page the database should go in.
  3. Back in StrawPoll, choose that page and give the database a title.
  4. Choose the poll and whether to send new responses, changed responses or both, then save. StrawPoll creates the database in the page.
  5. 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

ColumnWhat’s in it
RespondentThe respondent’s name, their email if there’s no name, or Anonymous
SubmittedWhen the response was sent
Email and PhoneContact details, if the poll asked for them
Poll and Poll linkThe poll’s name and address
One per questionThe answer as text
CommentThe respondent’s comment
Response IDStrawPoll’s ID for the response
TestTicked 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.

Related articles