Hey @saradakrony try to run the preview on the channel you’re building for (Messenger, Instagram, etc). You can setup a keyword trigger (something like ‘testcoupon’ to run it in a real scenario.

The Preview functionality in Manychat does not show the values of User Fields and will display them the way you’re seeing it.

If that still doesn’t work, then you have something wrong in your setup. Send us an image of the Google Sheet you’re testing with and the value of ‘user_coupon_id’ for the user and we’ll be able to see what it may be.

Thank you for your help, i appreciate  it.

the code appear as empty, check the screenshot below

and this is the google sheet i’m working with

and the user_coupon_id created as a text user field - didn’t add value

Ok, are you setting the user_coupon_id to a value (so you can do the search).

It has to have a value of your column A (1, 2, 3, etc), so the lookup works and can find the right data to capture the coupon code.

Check the documentation here:

https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration

Note how you have a Bot Field that keeps the count for the ID, and a User Field that tells which coupon code to assign to the user.

If you need help setting this up, check the Troubleshooting Call option on my site https://gusboregio.com