Send responses to Airtable

The Airtable integration adds a record to an Airtable table for every response. When someone edits their response, the record is updated.

Create a token

Airtable connects with a personal access token, which only you can create.

1. Open airtable.com/create/tokens and click Create token.
2. Give it a name, like StrawPoll.
3. Add the scopes data.records:write, schema.bases:read and schema.bases:write.
4. Under Access, add the base you want to use.
5. Create the token and copy it. Airtable shows it only once.

Set it up

1. Open the table the responses should go to and copy the address from your browser. It looks like https://airtable.com/app…/tbl….
2. In StrawPoll, open Integrations, click Add an integration and choose Airtable.
3. Paste the token and the table link.
4. Choose the poll and whether to send new responses, changed responses or both, then save.
5. Click Send test. A test record shows up in the table.

A new, empty table works best. Its first column is filled with the respondent’s name.

What a record looks like

StrawPoll adds the columns it needs: Response ID, Poll, Submitted at, Updated at, Respondent, Email, Phone, one column per question and Comment. Columns you already have with those names are reused. When you add a question to a poll later, its column is added with the next response.

Edited responses

When a respondent changes their response, the record with the same Response ID is updated instead of a new one being added. Keep the Response ID column for this to work.

When a respondent deletes their response, its record is deleted too. To keep such records, turn off Response deleted.

Change the token

To use a new token, edit the integration and paste it. Leave the field empty to keep the saved token.

If records stop arriving

Open the integration and look at Recent deliveries for the error. Most often the token was deleted, expired or lost access to the base. Create a new token with the scopes above and paste it into the integration.