Integrate Google Sheets as a database with Botpress using Pabbly.

[DME Moti Packaging]

Dear Pabbly Team,

I hope this message finds you well.

I would like to integrate Google Sheets as a database in Botpress using Pabbly. Could you please guide me on how to build this workflow effectively?

Looking forward to your support.

 

[Preeti Paryani]

Hello @DME Moti Packaging,

Can you please elaborate on what do you refer to by "I would like to integrate Google Sheets as a database in Botpress"?

Also currently we do not have any integration with Botpress, either you can add a request on our integration board for the application with the required triggers and actions by using this link or you can use Webhook by Pabbly for trigger(If botpress supports webhooks) and API by Pabbly for actions.

Please confirm if by Botpress you're to the following - https://botpress.com/.

 

[DME Moti Packaging]

I would like to integrate Botpress as a database where any query made is reflected in a Google Sheet. I believe this can be achieved using the Pabbly API. Could you kindly assist me with the setup or provide further guidance on this integration?

 

[Preeti Paryani]

Hello @DME Moti Packaging,

To trigger a workflow on any new query made in Botpress and add the data to Google Sheets, you can use Webhook by Pabbly. Here’s how you can set it up:

1. Webhook Trigger: Set up a Webhook in Botpress that will send the query data to Pabbly Connect whenever a new query is made.
2. Google Sheets Action: Once the webhook is triggered, use the Google Sheets: Add Row action in Pabbly Connect to insert the data into a Google Sheet.

To learn more about how to use Webhook by Pabbly, please refer to this tutorial -

.

Please note that API by Pabbly cannot be used as a trigger application in this case, as it is designed for performing actions, not for initiating workflows.

 

[DME Moti Packaging]

Thank you for your support

 

[Preeti Paryani]

Hello @DME Moti Packaging,

Thanks for the update, we'd love to hear your thoughts! If you have a moment, please rate us on Google. Your feedback helps us improve.