Everyday i recieve an email from a website to organize daily collection.
I want to create a scenario :
- Find the new mail
- Extract different elements from this email
- Add a new row to my Google Sheet
- Add the extraction to differents collumn
I don’t know which module to use to extract different elements
Here is an exemple of the email
Welcome to the Make community!
Is the email always in the same format? If yes, please provide the following:
Please provide the output bundles of the modules by running the scenario with a new email (or going to the scenario History to get one), then click the white speech bubble on the top-right of each module and select “Download output bundles”.
A.
Save the bundle contents in your text editor as a bundle.txt
file, and upload it here into this discussion thread.
Uploading it here will look like this:
bundle.txt (12.3 KB)
B.
If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:
-
Either add three backticks ```
before and after the code, like this:
```
input/output bundle content goes here
```
-
Or use the format code button in the editor:
Providing the 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!
2 Likes
Hi @MBE2698_Colmar
Welcome to Make Community!
Please use “Watch Emails” from Email/Gmail module. To extract the fields, use Regex (“Match Pattern” module from text Parser) after email module. Then use “Add a row” from google sheet.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel
2 Likes
Hey @MBE2698_Colmar
Welcome to the Make Community
You can use two things
- Use Regex for different type of pattern of data.
- Use ChatGPT to extract data from email.
Thanks,
Sachin Shrivastava
growwstacks.com
2 Likes
I need help with extracting text from emails body
For example I need it to extract
Names
Number
And language
Then put the data name number language it extract in a Google spreadsheet
With columns
Name
Number
Language
@francky_delissaint
Welcome to the Make community!
That looks like a new question, could you please create a separate topic for this?
While it’s tempting to hop onto an existing thread, a more effective approach would be to start a new topic just for your question. It helps community experts find and respond to your query quicker, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.
The “New Topic” link can be found in the top-right of the header:
2 Likes