I need your assistance here I would like to create the following email.
When I receive an email I receive it Via Email or Webhock connection in make.com.
I would like to extract all of the text in the email and capture all the data either by creating a mapping for future use such as Google Sheets, responding email to an inquiry, placing the date in CRM, and future email campaigns
I have tried all options and can’t get it to work. So, I am providing an example of the incoming email lead can anyone suggest to me which app to use? and which app needs to be 1st 2nd 3rd Etc… so here is the incoming lead thank you for anyone with a quick response
First Name: Test
Last Name: Me
Email: test@gmail.com
Phone: 222-444-5555
Address: 123 NE 7 Ave
City: Miami
State: FL
Zip: 33179
Your Itinerary:
KFXE Fort Lauderdale Executive Airport [] KTEB Teterboro Airport Teterboro, US 2024-08-27 05:57 PAX: 2
KTEB Teterboro Airport Teterboro, US ![] KFXE Fort Lauderdale Executive Airport Fort Lauderdale, US 2024-08-28 12:00 PAX: 2
To confirm, is this a problem of unstructured text → structured data (and then saved to Google sheets)? Would AI help here? Eg OpenAI module or Groq module (the JSON chat completion one)
When reaching out for assistance with your regex pattern for a Text Parser module, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.
Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster. So, help us help you by sharing those text snippets.
To do that, please provide the output bundles of the email module from the scenario History tab, then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
A. Upload as Text File
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
B. Insert as Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:
Method 1: Type code block manually
Add three backticks ``` before and after the content/bundle, like this:
``` content goes here
```
Method 2. Highlight and click the format button in the editor
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
This will allow others to better assist you. Thanks!
Hope this helps! Let me know if there are any further questions or issues.
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
I have tried json but could not get it to work I’m not sure if an unstructured one. The lead is coming from my WP I use the Ninga form so I can capture it Via Webhook or right from my email
I need to extract the flight itinerary and use only part of the text. any suggestions?
Can you show me the app to use to : 1st is my email, 2nd regex the order is always the same, 3rd aggregated the bundles to map. can you show me the app image ?
] KTEB Teterboro Airport Teterboro, US 2024-08-27 05:57 PAX: 2
