How to extract values from Kommo to Google Sheets

Hello community, this is my first post and I come with a concern that I cannot resolve by reading previous posts, I hope you can help me solve it, thank you!
I need to take these values from Kommo ​​and place them in Google Sheet

Input Bundle.txt (135 Bytes)
Output Bundle.txt (3.9 KB)

Welcome to the Make community!

If you need further assistance, please provide the following:

Please provide the output bundles of the modules shown in your screenshot by running the scenario (or 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.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles 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 input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

2 Likes

I edited the post with the files, thank you

You can use the built-in function map

e.g.:

{{ map(1.custom_fields_values; "values.1.value") }}

Screenshot_2024-06-11_220659

Output:

Screenshot_2024-06-11_220611

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

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

Help Center Basics

Articles & Videos

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

3 Likes

Thank you very much!!!

2 Likes