What are the capabilities of the Hopin<>Airtable integration?
- Export registrations from Hopin → Airtable
- Export attendee status (would update the registrations with “Attended” status)
Which plans are the Hopin<>Airtable integration currently available on?
The Airtable Integration is available on all Hopin plans.
Setting up Airtable
To get started, you will need to connect your Airtable app to your Hopin Organization. You can access the app store by going to your Organization Dashboard and heading to the Apps tab. Then click on Discover More on App Store.
You can follow this link to go directly to the Airtable page in the app store.
1. Click Install app to add the Airtable app to your Organization:
2. Click Install at the next prompt:
3. Click New authentication:
4. At the next prompt name the authentication (we suggest using your organization's name) and enter your PTA (Personal Access Token) in the API key field; then click Create:
When creating the PAT (Personal Access Token) to use with the Airtable app please make sure you assign the 5 Scopes as shown in the below screenshot. In terms of Access the token should have access to the Bases and Workspaces you intend your Hopin event data to be synced to.
The Scopes should be:
- data.records:read
- data.records:write
- schema:bases:read
- schema.bases:write
- webhook:manage
5. Once the authentication is complete click Next:
6. Provide your Airtable 'Base ID' and click Next:
Note: a full breakdown of Airtable urls – including how to find Base ID, Table ID, etc can be found in this Airtable guide: Finding Airtable IDs. Below is more info on the required Airtable IDs:
7. Provide your Airtable 'Table ID' and click Next:
8. If you wish to export Hopin registrations to Airtable, type in the corresponding Airtable field names and click on Set to "your field name" as shown below. Once configured, click Next:
Note: These fields need to exactly match the headers in Airtable and need to be typed manually. Add the field names for all the fields you wish to sync, these will be populated on the provided table when someone registers for an event in Hopin.
If you wish to export attendee status from Hopin, add the corresponding Airtable field name and set it as explained above.
Note: if this field is a multi-select picklist field, at least one option will need the value Attended, see below for how it looks like in Airtable:
9. At the last step if you have mapped the Status field in step 8 then make sure the Attendee Status checkmark is selected. If you don't wish to sync attendees' status then leave the checkmark unselected:
10. Click Finish and you are done! The Airtable app is now installed.
Testing the Airtable Integration
We can now test the app's functionality. First, you can create a registration in Hopin to ensure it is pushed to Airtable. To do that, you can navigate to the Events tab, select an event, and use the Preview Registration button to access the registration page (this assumes the event has been published):
Open the registration page in the Incognito/Private browsing mode and register for the event with a test account:
Once you register for an event, it will be also pushed to Airtable. If this reservation already exists in the Airtable, it will get updated with new information. If the registrants attends the event the registration will get updated with status "Attended".
And that's how you integrate Airtable with Hopin!