What is your goal?
I’ve been having a huge problem for like the past two days and haven’t been able to find a solution online so i decided to ask
Basically I have two scenarios
For the first one it’s a calendly initial, it’s meant to pull the info from a meeting book and update it in a google sheets spread AND also use twilio to send a message to that number
And a second scenario where twilio looks through the messages for a specific reply and updates the Google sheets if that reply was sent
The problem is in the second scenario
I used search rows to extract the columns and used update rows to update a row when the twilio( watch messages) requirement was passed
But the problem is I only want it to update the info if it’s from that number, like it should update the row for the number that twilio receives the reply from
I don’t know what to do here
What is the problem & what have you tried?
In the Row number section I tried calling the row_number function. Didn’t work and printed an error
Hey there,
Can you show a screenshot of the error message you are getting? Cause you logic is correct → watch messages, search rows to find the matching number a d then update a row.
Sorry I’m just responding to this I wasn’t home
This is the second scenario (the one with issues)
I used a webhook to simulate the twilio interface I’d swap it out later
This are the values i put in the module and this is the error I received
The first scenario is just about filling up the table at first
So the second module didn’t find any matches?
I think so
I’ve been stuck here for a while
Dunno what to do
Check your sheet → was it supposed to have found anything? If yes, then check the module configuration to see where the mismatch is. And if it wasn’t → add a filter after the module to stop the flow if nothing was found.
1 Like
Looks like this comes down to matching the Twilio webhook data to the correct row before updating it. I’ve seen this work smoothly once a unique ID, like phone number or message SID, is used to search the sheet first. After that, updating the row is straightforward. Without a lookup step, Make just doesn’t know which row to touch, so things silently fail.
I’m sorry but could you please explain a bit more. I’m kinda new to this
In the search row module i did add a filter to check if the phone column = from (the webhook)
In the update a row module I just put row number as the row number function and put what it’s meant to do if it checked out
When I tried it by manually entering a row number like 6 it worked well
Can you share images of the bundles you’re getting from the webhook and the search rows modules?
You need to make sure you are actually reciving a phone number from the webhook and that the mapping in the search rows module is correct (the actual phone number).
Also, check that it is the same as in the spreadsheet.
This is what’s taken from the webhook
The from bundle is what’s meant to send the reply to the “To” bundle
It’s expected to check the rows for the number that aligns with the from bundle and update it
And are you able to get any results back from the search rows module?
If you expected to, but you don’t, it can also be due to a difference in data types (text, number,etc)
Ok sorry I haven’t been able to update in a while as I’ve been pretty occupied
But I don’t know if this is the problem
When Calendly puts the number on sheets, Google reads it as a formula and makes the error like this
So I think that’s why search rows can find a cell that matches
I also tried changing the filter from text operator “equal to” to numerical operator “equal to”. Did nothing
Hey @Melon_Works,
First of all, I see that the columns are drop-down lists, which is an issue if you’re not reusing the same data.
About the value from Calendly being inserted as a formula, it’s hard for me to help without more details.
