Help me extracting value from Google Sheet using Manychat

Chiuso Pubblicato 5 anni fa Pagato alla consegna
Chiuso Pagato alla consegna

Hello,

I'm creating a chatbot using manychat.

I'm trying to extract data from a Google Sheet but I can't manage to get it working.

Everytime a user select his date and time, a new row is generated in my google sheet. This new row changes the value of the cell C2 that I want to extract. (see picture)

The second row of my google sheet is fixed and only the value of C2 will change.

I set the value of my custom field "one" to equals 1.

What am I doing wrong ? Because it isn't working.

So in one of the picture you can see I say lookup Column should be "User ID" and lookup value should be "one" (which equals 1), so that it selects the second row, and then I ask it to take the value under the "Value" column and copy it in the manychat custom field named "valeur".

However, when I try to use the "valeur" custom field in the following message, nothing will show up.

I guess I'm doing something wrong but I can't figure out what.

Thank you in advance for your help.

Google Cloud Platform Mobile App Development

Rif. progetto: #18592525

Info sul progetto

Progetto a distanza Attivo 5 anni fa