Webhook Make.com to Bot
# 🤝help
p
Hello everyone! I am new to bot creation and in fact I have, at the beginning of my workflow, a choice asked to the user: if he is new or if he is an existing user : - if it's a new user, the whole workflow is done, right down to the insertion of some information in a Google Sheet. Works fine ! - On the other hand, if he's an existing user, I'd like him to fill in his nickname and e-mail address (a bit like a primary key) and, depending on what he enters, this will fetch the line with all the information entered in the same Google Sheet. On the screenshot of 2 workflow components, we can see that the user is asked to enter these 2 pieces of information, which are stored in 2 variables, and that an Axios code is then executed from the bot to retrieve said line. Here is the axios get request in it :
Copy code
const url = 'https://hook.eu1.make.com/aqzipdup5iq68epkjbwrij0bwvjekt4o'
const payload = {
  userNameInput: workflow.userNameInput,
  userEmailAddressInput: workflow.userEmailAddressInput
}

const response = await axios.get(url, { params: payload })
The URL is that of the Webhook created in Make.com, of which I've also posted a screenshot. Basically, the first component determines the data structure and provides the call URL. The 2nd component, that of Google Sheet, retrieves the line with the double condition (attached). I also put in what it received with my fake data (we're not making fun of my example, are we!) and now I'd like to send this line back to my bot. The 3rd component is the answer and I've tried to return the fields in the body but it doesn't work. I've installed the "Webhook" module from the Integration Hub so that it can receive the said line and display in my standard node: "Hello {{workflow.userNameOutput}}" but so far it's not working at all. If you have any experience in this area, I'd be happy to learn 😄 Thanks for your attention and help everyone !
f
Hey there Devmik has a lot of great tutorials on how to use Make.com https://discord.com/channels/1108396290624213082/1181662097046786118 https://discord.com/channels/1108396290624213082/1194161232052244521 https://discord.com/channels/1108396290624213082/1180929476624912394 You can learn a lot by just seeing what he did. Let me know if you need help with understanding any of them.
p
@fresh-fireman-491, all in all, a great help (thank you, by the way!). On the other hand, I think there's still one thing missing: I'd like the user to enter his e-mail address and his pseudonym, and the combination of the 2 would return the relevant line. Except that at the moment, for the address entered, I've unchecked "Search in all KB" and as soon as he enters his pseudonym (and I check the aforementioned box), it returns directly what concerns this pseudonym and not the combination of the 2. Do you know of a way to do this please?
f
It returns it from the Google Sheet?
p
From the GoogleSheetTable which is my KB on Botpress
f
I unfortunately don't have a lot of experience with Google Sheets. Botpress might not be the ideal place to ask about this, since its more Make.com and Sheets related, if I understand correctly.
The problem is with Searching the rows on Google Sheets in your Make.com scenario right?
2 Views