Extract text from a standardized email to a google sheet

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”.
Screenshot_2023-10-06_141025

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:
    Screenshot_2023-10-02_191027

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

  1. Use Regex for different type of pattern of data.
  2. 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:

Screenshot_2023-12-19_091207

2 Likes