Help me extracting value from Google Sheet using Manychat
$10-30 USD
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.
Rif. progetto: #18592525