Getting data from user's custom url

Hello guys, everytime my users register in my email system (everwebinar) I want to get the informations in the thankyou page url with Make, in order to send them a Whatsapp message (using Wati).

This is an example url: https://webinarcompany.com.br/confirmacao-de-webinario-904?wj_lead_email=324234gersonr123fr567756576567%40gmail.com&wj_lead_first_name=gersonpublis1123234hing3&wj_lead_last_name=&wj_lead_phone_country_code=&wj_lead_phone_number=&wj_room_password=&wj_lead_unique_link_live_room=https%3A%2F%2Fevent.webinarjam.com%2Fgo%2Flive%2F182%2Fnk2yyan9bnvu173a7v6&wj_event_ts=1722553200&wj_event_tz=America%2FSao_Paulo&wj_next_event_date=quinta-feira%2C+01+agosto+2024&wj_next_event_time=8%3A00+PM&wj_next_event_timezone=Rio+de+Janeiro%2C+Sao+Paulo+GMT+-3

I want to get these parameters:
wj_lead_email=
wj_lead_first_name=
wj_next_event_date=
wj_next_event_time=
wj_lead_unique_link_live_room=

How can I automate that?

Honestly, I think the easiest way here is using AI here. Unless someone else can use another method.

I used chat gpt here is my prompt:
I have a URL containing several query parameters, and I need to extract specific key-value pairs from it. Here is the URL: {{1.1}} Extract all keys starting with wj and their values. Provide the result in JSON format so I can use it with the JSON parse data module in Make. Only output the JSON, no other text.

make sure that output is in JSON

Parse the results and I got this - it works really well.

This only took 500 tokens

|Prompt Tokens|314| = $0.000150 / 1K input tokens
|Completion Tokens|190| = $0.000600 / 1K output tokens

So its really cheap any way one result is about $0.0001611
Over 6000 runs needed to get to one dollar. No too bad this is using 4o mini

But how can I implement in a way that all I get the data from all users that register? I need this to be running the automation in a way to capture the data and send that to another app.

Yes this keeps it dynamic any link that comes in it will break it down into the value and key. Assuming you use the same URL parameters every time. This will work dynamically once you map it once.

Welcome to the Make community!

You can also use another free Groq “Create a JSON Chat Completion” module.

Example

Here is a Groq example on how to specify the variables that you want to match from the text content. This setup is also similar to what you’d do with the OpenAI Structured Data module.

Output


(Google’s about page didn’t contain any Google email or phone numbers, so it was left empty)

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

You can also join us in the Make Fans Discord server to chat with other makers. Due to the evolving needs of this community, the Discord invite link can be found elsewhere on this forum. You can either search for it or message me to request an invite.

1 Like

I have written about another method here, which only involves one module and a single operation.

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

You can also join us in the Make Fans Discord server to chat with other makers. Due to the evolving needs of this community, the Discord invite link can be found elsewhere on this forum. You can either search for it or leave a message below to request an invite.

3 Likes

This is great!! @sam

1 Like

Thanks for replying, I’m still not sure how to configure it in my page.
I’m new to Make. Do I need to configure my page to send those info to Make?

I like your idea of using chatgpt to do it, but how would I configure the trigger for this dynamic url?

If you want to use AI, I provided a Groq AI example above.

Groq is free, OpenAI is not.

1 Like