I am very new to AirTable. Here’s what I would like to accomplish. An email is sent to AirTable, which is then triggered/processed because it contains a specific subject of “Inventory”. AirTable then looks at the body of the email and looks for fields with thier values. For example, the email could look like:

Body:

Batch = 000012
User = Mary Jane
Usage Type = Discarded

I would then have a table in my database which contains columns named: “Batch”, “User” and “Usage Type”.

I would like the values (after the equal sign) to be added into their matching columns as a new record in the table.

I have a method for creating the emails, and I can have them formatted in anyway to get this to work correctly. I looked into Zapier which appeared to be my only solution, but even that I struggled with setting up.

Any kind of advice, tips, articles, videos, would be greatly appreciated!