Hey, I want to get some data from a google sheet. I currently use Zapier to search for a specific order number which the user inputs into the bot in a google sheet. How can I pass back the data from the whole row with the order number in the sheet (name, date etc.) to botpress? I would appreciate some help 🙂

Hey @thankful-processor-79226, Have you already connected Botpress to the Zap you created?

Current workflow is: Botpress bot stores the confirmation code in the variabel "code" this variable "code" is being passed to Zapier successfully. Then Zapier searches my google sheet for the row with the code and extracts the other data like date, name etc. I need to pass this information to the bot now.

Okay! You can create another workflow variable, say

row

of type Object, and in the execute code assign the response to it

workflow.row = response

You will then be able to access all the information using

@workflow.row.XYZ

Let me try to understand this and I will give you feedback, ty for the fast response.

Oh, I see Zapier webhooks don't seem to return a result. Will have to combine that with a Trigger I believe. I need to dig around; I'll get back to you.

Thank you!

Hi! I'm back. Took me a bit, but figured it out 😅 Okay, so the Zapier Webhook simply replies back with an http 200 code to acknowledge the reception of your request and closes the connection. So, it's an asynchronous call. That means, we need to get your Zap to make a request back to Botpress as the last step. So. This only works in a published bot (does not work in the emulator). Each step in a screenshot. Step 1. Be sure to pass in the

event.conversationId

when you call the Zapier Webhook for Zapier to pass it back to Botpress later so that Botpress may link the webhook request to the right user conversation. Step 2. Enable the Botpress Webhook integration on your chatbot. Step 3. Setup the POST Webhook action in your Zap that uses the Botpress Webhook URL and pass back the conversationId as well as all the other properties you want Botpress to receive. Step 4. In your bot, create a Webhook Trigger (You need access to the Triggers Beta), and link that to an Execute Code card. In the Execute Code card assign the conversationId from the webhook to the event conversationId. This ensures the webhook continues the user conversation. Step 5. Assign other webhook response properties to your workflow variables for use in your user conversation.

Thank you Ill try this tonight and let you know.

Mornin'! You can find out about them in this thread: https://discord.com/channels/1108396290624213082/1121833577659768893 And drop in a request for access using this form: https://docs.google.com/forms/d/e/1FAIpQLSe3RG8KLvszMtjSVskqHi0XOgFnfmzp15TA1WvnUYyqMpVwWg/viewform

Filled out!

Hey mate, you probably entered a wrong email address. I shall be adding a new batch today!

@early-train-33247 filled out again

Hi there! I’m also interested in joining. I have already filled out the form

me too, i've filled the form

Hey there, I'm interested in exploring this feature as a way to import a Google spreadsheet that is constantly updated using web hooks from Zap as a knowledge base object for the bot to use. Is that possible?

We don't have dynamic knowledge bases yet, but you can easily integrate with Zapier! Check out this tutorial by a community member: https://discord.com/channels/1108396290624213082/1136369863317786745

This is great! Thanks so much for the reply. However, I'm actually hoping to do that the other way around. For example, if we had a constantly updated spreadsheet that listed clock in and clock out times for employees, could the bot utilize the data from that spreadsheet to allow a project manager to inquire about specific employees in a natural language set up?

This is something im interested in as well!

Hello folks, sorry for the late reply. We have two upcoming updates that will help you: 1. Being able to upload CSVs to use as KB sources. @average-oyster-99594, it will still require a bit of work to upload it again everytime there is an update. 2. Tables will be available as KB sources, so there would be no need to use external spreadsheets!

@early-train-33247 I hope you are fast with tables as kb source update, my real estate client is waiting for it, long time now -.-

Coming soon! KBs are a relatively new feature, and Tables are a very new feature, but we are working on it 😉