Setting up an integration with Airtable
If your attendee or speaker list lives in an Airtable base, the Integration Hub can send it to your EventMobi People library, so you never import a CSV again. One scenario does it all: you run it once to bring across the records you already have, then switch it to real time so every new record follows automatically.
How it works
The same scenario runs in two modes, one after the other. Before writing anything, it searches EventMobi by email: if the person exists it updates them, otherwise it creates them. So running it more than once never creates duplicates.
|
1. Data migration |
2. Real time |
|
|---|---|---|
|
When |
Once, at setup |
From then on, for the life of the event |
|
Which records |
Records already in your table, from a period you choose |
Records created after you switch it on |
|
When it stops |
By itself, at 100% |
When you turn it off |
What to know before you start
- Trigger: The scenario starts whenever a record is created in your Airtable table.
- Email is the key: The Hub uses the email address to check whether the person already exists in EventMobi. Every record needs a valid, unique email.
- New records only in real time: In real time, the scenario reacts to new records. Edits to existing records are not sent on their own. To push edits, rerun the migration (see Troubleshooting).
- One table, one row per person: Keep the list in a single table, with clear column names such as First Name, Last Name, Email, Company and Title.
- Custom fields come first: Any custom field must exist in EventMobi before you can map an Airtable column to it.
Step 1: Install the Airtable solution
- In Experience Manager, open the Integration Hub. It opens on the Marketplace tab.
- Type "Airtable" in the Enter app name box, or scroll to the Airtable card.
- Click Install on the Airtable card.
- On the Select integration scenarios page, click Install next to the Airtable scenario.
Important: Install Airtable from the Marketplace. Don't add it as a separate app connection. The Marketplace scenario comes already built, so you only connect your accounts, map your fields and start it.
Step 2: Grant access to Airtable
- Open the scenario. On Step 1, Record created, click Grant Access.
- Sign in to Airtable in the popup if asked.
- Click Add a base and choose the base that holds your people.
- Click Grant access.
- Click the settings icon next to the connection and choose the base and table.
- On each EventMobi step, check your EventMobi organization is selected. Use the same one on all of them.
Tip: Airtable only shares the bases you add here. If you can't find a base later, edit the connection and add it.
Step 3: Create your custom fields in EventMobi
Skip this step if you only sync standard fields such as name, email, company and title.
If your Airtable table has extra columns you want in EventMobi, such as "Dietary Restrictions" or "Member Tier", create a matching custom field for each one first. Only fields that already exist in EventMobi appear in the mapping dropdown.
- In Experience Manager, open your event's People library and create a custom field for each extra Airtable column. See Creating and Managing Custom Fields in the Knowledge Base for how.
- Give each field a name that's easy to match to its Airtable column, for example the same name.
- Match the field type to the data. For example, use a dropdown in EventMobi only if the Airtable column holds the same fixed options, spelled the same way.
Tip: If you add a custom field after you've opened the scenario, reload the EventMobi step so the new field appears in the dropdown.
Step 4: Map your fields
The scenario's six steps are already built. You map your Airtable columns in two places: Update a Person and Create a New Person.
[embed: node/a8c0c550-d609]
Break stops the run after an update, so a person who already exists is never created a second time.
- Step 2, Search Person: Check the Email search field is mapped to your Airtable Email column. Most of this step is pre-mapped.
- Step 4, Update a Person: Map your standard fields:
- First Name → First Name
- Last Name → Last Name
- Email → Email
- Company → Company
- Title → Title
- Custom fields, same step: Your EventMobi custom fields appear in the dropdown. Pick each one and map its Airtable column.
- Step 6, Create a New Person: Map exactly the same standard and custom fields again.
- Steps 3 and 5, Router and Break: Leave these as they are.
Tip: Map the same fields in Update and Create. Otherwise a person looks different depending on whether they were new or already in EventMobi.
Step 5: Migrate your existing records
Skip this step if your Airtable table is still empty and go straight to Step 6.
- At the top of the scenario, open Automation timing and select Data migration.
- Choose Once.
- Under Trigger data receiving mode, choose to process each record separately, so each record becomes its own person.
- Choose the period: all account data, a number of days back, or a date range. Dates must be in the past.
- Start the scenario. A progress bar shows how far it has got.
- Wait until it shows Migration completed 100%. The migration then stops by itself.
Step 6: Switch to Real time and go live
- Open Automation timing again and select Real time.
- Start the scenario.
From now on, every new record in your Airtable table is sent to EventMobi. Leave the scenario running for the life of the event.
Important: Don't forget this step. After the migration, the scenario stays in Data migration mode, and new records won't reach EventMobi until you switch to Real time.
Test your integration
Test with one record before you rely on it. You can also use the Test button on each step to check its output as you set it up.
- Add a test record in Airtable. Fill in every mapped column, custom fields included.
- Wait about 1 to 2 minutes.
- Check EventMobi. In Experience Manager, open People and search for your test person. Check that the name, email, company and custom fields arrived as mapped.
- Check the history. In the Integration Hub, open the scenario's History to see every run and spot errors.
Troubleshooting
|
Problem |
Likely cause |
Fix |
|---|---|---|
|
New records don't reach EventMobi |
The scenario is still in Data migration mode |
Switch Automation timing to Real time and start it (Step 6) |
|
Edits in Airtable don't show in EventMobi |
In real time, the scenario only reacts to new records |
Switch to Data migration, click Reset Progress, and run it again. Existing people are updated, not duplicated |
|
A custom field is missing from the dropdown |
The field doesn't exist in EventMobi yet, or was added after you opened the step |
Create it in the People library, then reload the EventMobi step |
|
A custom field arrives empty or is rejected |
The Airtable value doesn't fit the EventMobi field type, such as a dropdown option spelled differently |
Match the options and spelling in both places |
|
A person appears twice |
The email differs between the two records |
Fix the email so both match, then delete the duplicate |
|
A run fails in History with a validation error |
A field EventMobi requires, such as Email or Last Name, is empty |
Fill it in Airtable, then rerun the migration for that period |
|
I can't find my base or table |
The base wasn't added when you granted access |
Edit the Airtable connection and click Add a base |
Need help? Contact EventMobi support with the scenario name and a screenshot of the failed run from History.