Guide: Routing Data to Google Sheets with Botpress and Make.com

Have you ever wondered how to send data from a chatbot to a single Google Sheet, but distribute it to separate tabs in the sheet? If you're using Botpress and Make.com, you're in luck! This article will guide you through the process step by step.

The Problem

Let's say you have a real estate bot that captures Buyers and Sellers details separately in the flow. You want to send this data to a single Google Sheet, but you want to send it to separate tabs in the sheet. You've tried using a router, but you're not sure how to use it or if it's the right tool for the job.

The Solution

Good news! You can indeed send data to separate tabs in a single Google Sheet. You just need to set up two filters after the router. This way, buyers will take one path, and sellers will take the other path. If you don't set up these filters, any bundle generated by the trigger will take both paths and both modules will execute.

To set up the filters, follow these steps:

Click on 'Set up a filter' between the router and Google Sheet.
Apply the condition for buyers on one path and for sellers on the other path.

That's it! Now your data will be routed to the correct tabs in your Google Sheet.

Troubleshooting Tips

If you're having trouble setting up the filters, make sure you're applying the correct conditions for buyers and sellers. Also, remember to check that your router is set up correctly. If you're still having issues, don't hesitate to ask for help in the Make.com community.

Summary

In this article, we've learned how to send data from a chatbot to separate tabs in a single Google Sheet using Botpress and Make.com. By setting up filters after the router, we can ensure that buyers and sellers data are sent to the correct tabs. Happy automating!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.