Using Update Row on Google Sheets to deduct quantity of item

How To
,
1

I am working on an automation project where I need to update a Google Sheets spreadsheet based on data received from a Botpress chatbot via a webhook. Here are the details of my setup and the issue I am encountering:

Project Overview:

  1. Botpress Chatbot:
  • Collects user inputs, including items and their quantities.
  • Sends this data to a Make.com webhook using a POST request.
  1. Make.com Scenario:
  • Webhook Trigger: Receives data from the Botpress chatbot.
  • Google Sheets: Retrieves rows from a specific sheet.
  • Iterator: Iterates over the items received from the webhook.
  • Google Sheets: Updates the corresponding rows by deducting the quantities.

I am trying to use the information sent through botpress to find an item or multiple items on Google Sheets and then deduct the quantity used. I have set up the following:

  • Webhook
  • Iterator
  • Google Sheets (Find Rows)
  • Google Sheets (Update Rows)

After I set this up, there have been no errors which show up, but the sheets are still not updating. Any help with this is appreciated

2

Hello, welcome to the Make Community!

Can you please take a screenshot of the data you get in your webhook module?
As well as some of the rows you want to update, the way you correlate data from the rows and from the item received in the webhook.
And finally, the calculation you do to deduce the value?

I think you won’t need an iterator, and that you’ll be able to use Functions to extract the relevant data that you deduce to each row… but I’m not sure until I get more details from you :blush:

2 Likes