Mailparser can be connected directly to Airtable with a direct integration. Once connected Mailparser can automatically update your Airtable with new records.
To begin, navigate to the inbox you need to connect and click on Integrations on the left side of the screen, then click the Add New Integration button.
Next you will need to choose the Airtable integration and use the first drop-down to select "Add Account".
After selecting "Add Account" you will be redirected to Airtable to grant Mailparser permission where you will need to select a base and grant access.
Before granting access you will need to select "Add a base" to choose the table that you are granting Mailparser permission to send data to. Next, click Grant Access and you will be redirected back to Mailparser with the connection information already populated.
The next step is to use the drop-down to match your parsing rules to each of the columns in your Airtable. If you haven't already created the rules, go back to the Rules screen and add parsing rules (your integration will be there when you are ready to connect).
As soon as the parsing rules are matched to the columns click Save & Test and Mailparser will send the fields from your latest email directly to your Airtable.
All future emails will send automatically!
Feel free to reach out to our support team if you have any questions!
FAQ
Does Airtable have any rate limits?
Yes, Airtable has a limit of 5 requests per 1 second for each base. If too much data is sent through, emails may be directed to the failed webhook queue as Airtable will reject these.
To resolve this simply wait a few minutes then;
- Navigate to your Failed Webhooks tab
- Select your failed emails
- Click Perform Action Move to Dispatch Queue.
My Airtable base has changed, do I need to do anything?
Yes! If any changes are made to your Airtable base the integration will need to be updated or recreated to re-map your parsing rules with the columns in Airtable.
My Airtable base contains blank rows?
Keep in mind that Airtable will create blank rows by default when creating a new base. Mailparser's Airtable integration is designed to append data to the next new row. To resolve this manually delete the blank rows in your Airtable base.
What data types can be sent to Airtable?
When calling Airtable APIs, we will set the TypeCast flag to TRUE so that Airtable API does its best effort to automatically convert data from String values.
Still, there are some cases where you need to pay attention to the type of the data that you send through the integration:
- Date Values: Parsed Date value should be in ISO-8601 format (YYYY-M-D). For example, 27 September, 2023 will be represented as 2023-09-27. Please use Format Date Filter to format dates if the received date is in a different date format.
- Single-Select Values: Sometimes, parsed data for a column should be selected from a set of values. For example, Marital Status column can contain only one of these values: {Single, Married, Divorced, Widowed}. In this case, sending any other value will generate an exception and the API call will fail.
- Read-only columns in Airtable: There are columns such as Created By and Created Time that are read-only and cannot be modified by you. That's why when setting up an integration between Mailparser and Airtable, these fields will not be displayed because no value can be sent to these columns.You will find more information about data types available in Airtable and what values can be sent to them in this article : https://airtable.com/developers/web/api/field-model#select