Store UTMs information in Google Sheets

I am connecting a form on my website using a Webhook.

I want to store UTMs. The Webhook is giving me the information.

The problem is when I want to transfer the information to a Google Sheets, because it does not take the UTMs as a variable.


Hi @FR and welcome to the Make Community!

The information seems to be in the formValues array in your first screenshot. Is that what you’re having trouble accessing?

L

Welcome to the Make community!

There are more than one way to do this, but the simplest would probably be:

You can use the built-in function toCollection in a Set Variable module first.

e.g.:

{{ toCollection(1.formValues; field; value) }}

For more information, see the toCollection function documentation in the Help Center.

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

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.