Botpress workflow variable extraction
# 🤝help
f
Is there a way to take values from a Google sheet via zapier and send it to botpress and store it into a workflow variable?
@flat-plumber-75402
f
thanks Muhammed V. give me a minute and I'll get back to you quickly on this.
Alright fortunatly for us both others have had similar questions. Review these two threads and let me know if you have any additional questions. https://discordapp.com/channels/1108396290624213082/1133465098468470834/1133845818407927829 https://discordapp.com/channels/1108396290624213082/1133491536890450041
f
Thanks! I'll let you know if I face any issues.
f
No worries. Glad to help.
f
Hey @flat-plumber-75402, I'm trying to get the webhook working but the webhook event card doesn't show up in the cards section. Any fix?
Also, when I send event.conversationId in Zapier, I'm getting convo-3 instead of a long string

https://cdn.discordapp.com/attachments/1139488698354913412/1140687287898865795/IMG20230814221256.jpg

https://cdn.discordapp.com/attachments/1139488698354913412/1140687288293138472/IMG20230814221306.jpg

https://cdn.discordapp.com/attachments/1139488698354913412/1140687288653844501/IMG20230814221331.jpg

f
Hey Muhammad V have you enabled the integration. Once you have connected the app and entered the secret you still have to click the enable integration toggle. I had the same thing happen to me, and then I went back and saw I forgot to enable it.

https://cdn.discordapp.com/attachments/1139488698354913412/1140738964479811675/image.png

The convo-3 is the designation its from the emulator
f
Shouldn't the conversation key be a long one?
I did as the thread said, but it doesn't work.

https://cdn.discordapp.com/attachments/1139488698354913412/1140986488998330378/Screenshot_40.png

https://cdn.discordapp.com/attachments/1139488698354913412/1140986489270976613/Screenshot_41.png

https://cdn.discordapp.com/attachments/1139488698354913412/1140986489749123233/Screenshot_43.png

Please let me know what I am doing wrong
f
The convesation ID is long unless you are in the emulator. Then you get the Convo-3.
Which channel are you testing this on?
f
When I test this on webchat, I am getting "the value is undefined"
The webhook is indeed recieved

https://cdn.discordapp.com/attachments/1139488698354913412/1141316194771664967/Screenshot_44_-_Copy.png

https://cdn.discordapp.com/attachments/1139488698354913412/1141316195094646875/Screenshot_45.png

@flat-plumber-75402 also, when I get this working, and I send through a bunch of values like name, email, telephone num, etc... How can I use them individually?
7 Views