I’m trying to send data from Botpress using a webhook (in screenshot) to a single google sheet, the chatbot is a real estate bot so I am capturing Buyers and Sellers details separately in the flow.
Is it possible to send data to a single google sheet, but send it to separate tabs in the sheet?
I tried using a router but I dont know how to actually use it or if its what I should be using.
Hey @MaxW
As per your concern it is not possible to share data on different tabs with one module you have to use two different modules for data sending in two different tabs.
ok thanks, so I need to clone this work flow and create two unique web hooks?
Hi @MaxW
Welcome to the Make community!
It seems that there may be some miscommunication here. You can do that, just that you’ll have to set up the two filters after the router, so that buyers will take one path, and sellers will take the other path. If you don’t do that, any bundle generated by the trigger will take both paths and the top and bottom modules will both execute.
To learn more about Filters, see https://www.make.com/en/help/scenarios/filtering
Next time, could you please share screenshots of the module fields and filters in question? It would really help other community members to see what you’re looking at.
You can also export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Uploading it here will look like this:
blueprint.json (12.3 KB)
If possible, could you also please provide the input/output bundles of the modules by running the scenario, then clicking the bubble on the top-right of each module, taking screenshots of, and copying the contents into this discussion thread:
This will allow others to better assist you. Thanks!
I apologies for my mistake if that webhooks captures both buyers and sellers details then you can use router and give on path for buyer and on for seller by applying filter in both different tabs, you can do it in same scenario
Nice! how exactly can I do this?
In between router and google sheet you will find this one
Click on Set up a filter
Then after here you can apply condition
This process will be followed on both paths one for buyers and another for seller
I think I figured it out! I was able to use a variable at the start of the flow which defines the pathway based on the users choice e.g Buyer or Seller.
I then used a condition to check for each type:
And seems to work as intended now. Is it possible to capture the date the row was entered as well?
Excellent, glad you managed to figure it out!
In future, please create a new thread for each question. This makes it easier for others with the same problem to search for the answer. Thank you for your cooperation!
The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
To do this, simply click the checkbox at the bottom of the post:
