Hi everyone, I need some help with my workflow.
Here’s a quick overview of what I’m trying to achieve:
I have a spreadsheet where data is being pulled in and updated regularly—especially the status column.
Whenever a new row is added to the spreadsheet, a new task should be created in ClickUp.
When the status of a row is updated in the spreadsheet, the corresponding task in ClickUp should also be updated accordingly.
As an alternative setup, I also tried this approach:
Every time a new row is added to the spreadsheet, a task is created in ClickUp immediately, and any previous/duplicate task related to that entry is deleted.
This approach is shown in the image above.
Can anyone please help? I’ve been trying to get this working for a week now without success.
1 Like
Hi @Ann_marie_Ledesma,
To update the ClickUp task every time there’s a change in the ‘status’ column, you need to use the ‘Watch Changes’ module along with Google Apps Script. First, grab the webhook link provided by the module. Then, go to Google Apps Script and create a function that triggers whenever there’s a change in the sheet. If the changed row and column match the one that you’re interested in, you need to send the data as a JSON payload to the ‘Watch Changes’ via the Apps Script function with the webhook URL as the address
1 Like
Can you please share with me how to get the webhooks? im really new to this.
Webhook for clickup and google
1 Like
If you’re new to Make and Apps Script, this scenario will be more complex than a basic one.
What you can do is create two scenarios: one that triggers when a new row is added using the “Watch New Rows” module, and another that triggers when the “Status” column is updated using the “Watch Changes” module.
For the second scenario, you’ll need to click “Add” to create a webhook and use the webhook URL to send data from the Apps Script function whenever there’s a change in the sheet or the “Status” column.
Once Make receives the data from Apps Script, you can use it to update the ClickUp task or whatever you need to do with it.
Looking at the image again you are wasting a lot of operations, be careful with that
1 Like
When you mentioned “add” what module do you mean here?
1 Like
The “Watch Changes” module
2 Likes
okay i’ll try this on my end
1 Like
Hi i coudnt find the watch changes module in google sheets module
1 Like
Delete the first module (the one with the clock) and then click “+” and search it there, the “Watch changes” module only appears when you use it as the first module (the same happens with the Custom Webhook and Mailhook modules
3 Likes
saw it!! thank you working on it now
1 Like
for this one, should i add another module?
and another that triggers when the “Status” column is updated using the “Watch Changes” module.
1 Like
Also what apps script are you referring here?
1 Like
Apologies for being so absent minded, I’m really new to this kind of stuffs and I’m really eager to learn it and be able to see what i did wrong to the scenarios im creating.
1 Like
Of the things that you want to do (add and edit a ClickUp task) the only thing that can be done with Make alone is to add a task every time you add a new row (just make sure all the fields you need for the ClickUp task are filled with a filter).
Now, to update a task you need to use Google Apps Script to make a function that activates every time you make a change to the “status” column and send the row number of the sheet, the ID of the task, and the new task “status” to the “Watch Changes” module and then update the task.
1 Like
Welcome to the Make community!
Yes, that is possible. You’ll probably need a minimum of five modules:
This is just an example. Your final solution may or may not look like this depending on your requirements.
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
— @samliew
Thanks, i’ll try this one
Hey Jonathan, i tried doing it, but the script i created is getting this error.
Can you provide the filters you used here?
Ann_marie_Ledesma That’s not working because that function is supposed to run every time you edit a cell in the Spreadsheet, you have to set up a trigger (in the clock that you see on the image) that runs “On edit”, in Choose which function to run select your function
Yep i created the trigger as well.
