Find Jobs
Hire Freelancers

Help me extracting value from Google Sheet using Manychat

$10-30 USD

Closed
Posted about 5 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 18592525

About the project

Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of BELGIUM
Harze, Belgium
4.8
17
Payment method verified
Member since Apr 18, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.