Skip to main content
Solved

Google sheet error

  • November 6, 2024
  • 6 replies
  • 71 views

saradakrony

If you have the time and energy to help me that would be great ❤ 

I have set my steps well after following tutorial, but still gives me this error {{cuf_12023943}}

 

 

Best answer by Gustavo Boregio

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.

View original

Gustavo Boregio
Forum|alt.badge.img+6

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.


saradakrony
Gustavo Boregio wrote:

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

 


Gustavo Boregio
Forum|alt.badge.img+6

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

 


saradakrony
Gustavo Boregio wrote:

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

i’ve followed the instruction, when i tested the code doesnt display :’(

 

 


Sami Mahin
  • Channel Explorer
  • February 1, 2025

did you fix this ?


saradakrony
Sami Mahin wrote:

did you fix this ?

yes i did, do u have the same problem?

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings