Hey guys!! Does anyone know what code to put in the execute code so that when I insert a webhook from zapier inside the execute code, it can be able to pull all the information that has been said from the chatbot to that point to google sheets. For context, I want that to happen each time the bot doesn’t have an answer for a question from the knowledge base so that it can be sent to the support rep.

You can try using Zapier to send info to a Google Sheet.

That’s exactly what I am planning to do. Only problem is I don’t know what code to put inside the execute code block.

what trigger we will be using in zapier to save responses in google sheet, do we need to write customize code, any tutorial for botpress wih zapier?

You can use a webhook trigger that connects to Google Sheets. Then you can post to that webhook URL like below:

js
axios.post('https://hooks.zapier.com/hooks/catch/YOUR-URL-HERE/', { text: 'Hello' }).then((response) => {
  workflow.zapData = response
})

Replace the URL with your own Zapier webhook URL. In Zapier you can configure which rows of what speadsheet get returned. This data will be available in

workflow.zapData

.