Hey guys, Make is not properly updating data pulled from a Google Sheet connected via webhook. The session was successfully tested but now for some reason it is showing the data and returns an error when I try to run it.
I built a session to pull data from updated rows in a Google Sheet (watch for changes in D column) to create a new ClickUp task with data from the row where the change was made.
This allows our email calendar to be built out and then for the days that have a campaign, a task is built in ClickUp. The trigger is the change in the âClient Approvedâ column (also looking for ways to only update when it is changed to âYesâ)
Before, the row values would show values from the sheet, now they are all blank. It used to show them and a task was created but now it wonât refresh google sheet data (Iâm guessing that is the issue?)
Webhook was properly connected (it worked before):
There could be several things at the minute. The error that is running claiming that there is no parameter for ânameâ could mean that the column you listed as the same of the item on your Google Sheet is blank and therefore unable to determine the row it is on. That will cause make to not be able to determine which value in the D columns was updated correctly.
An easy way to refresh the connection could just be going to the connection in your scenario, removing it, and connecting it again. Or go to your connections page, delete it, and set it up again.
Without being able to see the whole scenario and each of its components, it makes it slightly challenging to tell exactly what is wrong but what I mentioned hopefully is of some help.
Thanks for the response @Nathan_Kind Its not an empty cell issue, its that it randomly stops pulling all data. None of the data shows up in Row Values (usually there would be the Date Column A, etc but it is all just blank). I reordered one of the columns since making my post and it showed up briefly, then disappeared again
Make support said the problem is that the webhooks update sometimes, other times not so its a sheets issue and to check the logs on google sheets but didnt say how to do it. Anyone know how?
"This could be due to the type of updates you are making in the Sheet, or maybe due to the column being updated. If you want to check why it is sometimes triggered empty, I would recommend checking with Google support.
To avoid errors in your scenario, I would recommend adding a filter so only if there is a task name in Column E, the ClickUp module will run, like this:"
Id like this session to only update when column D âClient Confirmedâ is changed to âYesâ
