I’m trying to retrieve the final calculated cleaning price from Google Sheets based on a unique quote_id, which is matched in column AE. Each sheet calculates the price for a specific service (e.g., “ON DEMAND EXPRESS CLEAN”), and the price is stored in column AD. The goal is to pull the price from the correct row and return it to Landbot via webhook so I can eventually build logic for other service paths.
Steps taken so far
- I already have a separate Make scenario that successfully collects all customer data and inserts it into the Customer Data sheet, which later adds the data to each service sheet to calculate the price.
- In Landbot, I generate a
quote_idand send it via a Webhook block to a second Make scenario. - This scenario includes:
- Custom Webhook (receives the quote_id),
- Router (to support other services later),
- Search Rows in “ON DEMAND EXPRESS CLEAN” → finds the row by
QUOTE ID (AE)and reads thePRICE (AD), - Webhook Response returns:
json
CopyEdit
{ "price": "{{2.PRICE}}" }
- In Landbot, I show this value with:
"Your price is $@price"
However, the final Landbot message still shows: “No JSON response”, even though the customer row is created and quote_id matches correctly in Sheets.
