Question about Text Parser when setting up email reminder

How To
, ,
1

Hi, I followed the instructions on this page: https://www.make.com/en/help/apps/productivity/google-calendar#trigger-a-specified-amount-of-time-before-an-event.

The scenario is setup as Mailhook - Text Parser - Gmail. I have a separate scenario in which when a Google Calendar event is created, it updates the event by adding two email notifications.

webhook scenario
webhook scenario1445×636 35.9 KB



Basically, the way it’s supposed to work is: (1) I create an event in my Google Calendar and add a guest to the event. (2) Two email notifications are added to the event. (3) When the email notifications are received, a webhook sends the email data to Make. (4) Text Parser sorts the data for Event Name (Summary), Start Date and Time, and Guest Email. (5) Gmail sends an email reminder to the event guest based on the data collected from the Text Parser module.

QUESTION: What should go in the “Pattern” field of the text parser?

The webpage gives this example: . But I can’t seem to figure out how to get it to collect the summary, start date/time, and guest email.

Thanks!

2

Welcome to the Make community!

It depends on what you are receiving from the webhook, and what you want to match.

For assistance with Text Parser modules, you need to provide an actual example.

Please provide the output bundles of the Webhook module (get 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!

— @samliew

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!

1 Like
3

Hi, thanks for your help.

Here’s the input:
Input Bundle.txt (17.4 KB)

The output just shows .

4

Welcome to the Make community!

Yes, that is possible. You’ll need a Groq module to extract details from the HTML email content:

Screenshot_2024-08-26_110840
Screenshot_2024-08-26_110840878×651 66.1 KB

Output

Screenshot_2024-08-26_110801

This is just an example. Your final solution may or may not look like this depending on your requirements.

Module Export - quick import into your scenario

You can copy and paste this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above.

  1. Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the right of the code, which looks like this:

  2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the editor.

  3. Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections.

JSON module export — paste this directly in your scenario

{"subflows":[{"flow":[{"id":282,"module":"groq:createJSONChatCompletion","version":1,"parameters":{"__IMTCONN__":2370769},"mapper":{"model":"llama-3.1-70b-versatile","systemPrompt":"You will receive event details and extract them into JSON.\n\nThe JSON should look like:\n\n{\n  \"title\": \"My Meeting\",\n  \"summary\": \"You have been invited to attend a meeting on Zoom\",\n  \"url\": \"https://zoom.us/abcdefg\",\n  \"formatted_start_date\": \"26/08/2024 10:55pm\",\n  \"formatted_end_date\": \"26/08/2024 11:55pm\",\n  \"time_range\": \"10:55pm - 11:55pm\",\n  \"start_date_ms\": \"1724640951812\",\n  \"end_date_ms\": \"1724644551812\",\n  \"guest_email\": \"test@example.com\"\n}","userMessage":"{{stripHTML(281.value)}}"},"metadata":{"designer":{"x":2611,"y":-1060},"parameters":[{"name":"__IMTCONN__","type":"account:groq","label":"Connection","required":true}]}}]}],"metadata":{"version":1}}

Note: Did you know you can reduce the size of blueprints and module export code like the above, using the Make Blueprint Scrubber?

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

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!