Retrieve data from zapier
# 🤝help
b
Hello The response i get from this Zap is the following: { attempt: '018949cc-912f-59a9-b5f2-93a4d341b875', id: '018949cc-912f-59a9-b5f2-93a4d341b875', request_id: '018949cc-912f-59a9-b5f2-93a4d341b875', status: 'success' } When i see the response in Zapier itself, it is the following: id 374 row 374 COL$A Fiat COL$B 500 COL$C Fiat 500 COL$D Hatchback COL$E Normal COL$F € 19.000,00 _zap_data_was_found true How can i make sure that i can extract these fields from my response instead of just seeing if the zap is successfull or not? The code to make the request is the following: workflow.zapierSuccesss = false; const leadData = { carbrand: workflow.carBrandModel }; const zapierWebhookUrl = 'https://hooks.zapier.com/hooks/catch/XXX/?_format=json'; try { const response = await axios.post(zapierWebhookUrl, leadData, { headers: { 'Content-Type': 'application/json', 'Accept': 'application/json' } }); console.log(response.data); if (response.data.status) { workflow.zapierSuccesss = true; } else { workflow.zapierSuccesss = false; } } catch (error) { console.error(error); } Many Thanks Miguel
w
I am using this code below and its working fine for me : workflow.zapierSuccess = false const leadData = { name: workflow.name, email: workflow.email, contact_number: workflow.contact_number, help_category: workflow.packages, user_query: workflow.user_query } // Replace YOUR_ZAPIER_URL_HERE with your zapier webhook url try { const response = await axios.post('YOUR_ZAPIER_URL_HERE', leadData) console.log(response.data) workflow.zapierSuccess = true } catch (error) { console.error(error) }
b
yes but I need to get back data from Zapier. The post request is fine and is succesfull. Its the response that doesn't include the data that i need. What is your log of your response?
w
b
Hello @wonderful-kilobyte-12079, thanks for the quick response. What you send me i do achieve aswell. I perfectly get the data to Zapier via the API call. But in Zapier, i'm going to search then for a google sheets row. Once zapier found the row, I need the data from that complete row send back to Botpress so i can store the values of that row into variables in Botpress.
w
Do you want to see this data in google sheet and you want to know how thats done ?
b
@wonderful-kilobyte-12079 no I want the data i receive in google sheets to get send back to botpress so i can use it into my conversation. What i found is that there is a zapier integration of botpress. It gives you a webhook that you can talk to. Anybody knows what you can do with this webhook?
s
I have the same concern with Make; I using the Qa document template of Stack AI, but the problem is that it use uploaded document and i want the document to be auto updated. So I decided to move to Make, and use google sheet for document so I can integrate auto update later. The problem is that my system works well but I need a system where the message generated by gpt goes back to botpress and I'm struggling to find a solution. There is a Botpress webhook?
I resolved my problem. I dont know how works Zapier, but in make I had to add the "Webhook" feature again, and when you add it a second time it's for set the response given to webhook (default it's "Accepted"). I just had to set the response for GPT. Eureka !
given by webhook*
95 Views