![]() ![]() You may want to add that as precautionary rule, but that is up to you. To solve for this we have a 'Remove leading and trailing whitespace' rule which will remove all of that for you. In some cases, we will have some extra whitespace or new line characters surrounding our final output. With this rule, the parsing engine will locate the first instance of 'Last Name:' and parse all the text before that match. We do this by creating a 'Capture all before the match' rule and using the keyword 'Last Name:' as the input. Now we want to create a rule that will capture all the data before the 'Last Name' value. The parsing engine will find the first occurrence of ‘First Name’ and parse out all text following that match, just like the rule says. To accomplish this we first create a 'Capture all after the match' rule, which will take the input, in our case 'First Name'. ![]() We start with the raw text at the top and we ultimately want to end up with just the first name data point extracted. Hit save and let’s move on to building the parsing rules. Next we will keep the body selected for the content type since the data that we are looking to extract is found in the body of the email. The label of the ruleset is going to be the key of the key value pair that we end up creating, so in our case we want the label to be “firstname”. Let’s walk through how to do that by showing how to set up the first name key value pair. So for example we want to create a payload that looks like the below. The output of each ruleset is a key, value pair, where the key is the label of the rule and the value is the extracted value from your email, based on the parsing rules you setup. ![]() We will build that data structure through these rulesets. For every parsed email you want some output of data to send to Airtable. This next page is where you will be building the structure of the data that you want to convert your emails into. Go ahead and click on “Parsing” in the nav bar. Now that we have a request, we need to setup our parsing rules. Then go ahead and refresh and you should see a new request in the sidebar, it should be your ingested email. Once you’ve sent your test email, give a minute for it to be received and ingested by the HostedHooks platform. For the sake of this demo, we are going to do a very lightweight parsing example, but the same process would be used for your implementation. This email should be similar to what you want to eventually parse as you’ll need to make parsing rules that match. On your new HookHelper, grab the custom email address (see above) and go ahead and send yourself a test email. There you’ll create a new HookHelper, which will act as your inbox for the emails that you want to parse. Once that is complete you want to head to your HookHelpers. We’ll assume you’ve already signed up for HostedHooks and created your free account ( if not you can do that here). The first part of sending your email data requires us to have some parsed email data to send, so let’s walk through how to setup email parsing. We will be taking our email data and every time a new email comes in, it will get parsed, a webhook will be sent to Airtable and the email data will be automatically inserted in to a new row. It’s quickly turning in to something more than that, but for the sake of simplicity it is essentially google sheets on steroids. This specific post will be showcasing how to send our emails to Airtable, which if you’re unfamiliar with, is a web based spreadsheet product. We will be running through many examples that show how to send your parsed email data to different third party platforms. Once the third party receives the webhook, it will ingest that data and do something with it. The first step is to send your parsed email data to the third party platform via a webhook. There are tons of examples, but they all work the same way. In some cases that might be analyzing it on a spreadsheet, others may be some sort of automation that takes out the manual work. They will use their parsed email data and connect it with some other site that will allow them to do something with it. One of the key reasons that businesses start parsing emails is to use that email data on third party platforms. ![]() How To Send Your Parsed Emails to Airtable ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |