# ClickUp task creation and removing duplicate **URL:** \ **Category:** Questions\ **Tags:** error, google-sheets\ **Created:** [May 9, 2025, 11:48pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927 "2025-05-09T23:48:37Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 9, 2025, 11:48pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/1 "2025-05-09T23:48:38Z")
![IMG_20250510_072348](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/c/fcb1c724e3da755e95c6b040c288bf702178a0e1.jpeg) 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. ---
**Author:** ![Jonathan\_Quarics](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jonathan\_Quarics](https://community.make.com/u/Jonathan_Quarics)\ **Post date:** [May 10, 2025, 12:18am UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/2 "2025-05-10T00:18:37Z")
Hi @[Ann\_marie\_Ledesma](https://community.make.com/u/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 ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 10, 2025, 5:30pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/3 "2025-05-10T17:30:49Z")
Can you please share with me how to get the webhooks? im really new to this. Webhook for clickup and google ---
**Author:** ![Jonathan\_Quarics](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jonathan\_Quarics](https://community.make.com/u/Jonathan_Quarics)\ **Post date:** [May 10, 2025, 5:54pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/4 "2025-05-10T17:54:39Z")
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 ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 10, 2025, 6:16pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/5 "2025-05-10T18:16:04Z")
When you mentioned “add” what module do you mean here? ---
**Author:** ![Jonathan\_Quarics](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jonathan\_Quarics](https://community.make.com/u/Jonathan_Quarics)\ **Post date:** [May 10, 2025, 6:19pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/6 "2025-05-10T18:19:08Z")
The **“Watch Changes”** module ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 10, 2025, 6:24pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/7 "2025-05-10T18:24:16Z")
okay i’ll try this on my end ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 11, 2025, 4:56pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/8 "2025-05-11T16:56:49Z")
Hi i coudnt find the watch changes module in google sheets module ---
**Author:** ![Jonathan\_Quarics](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jonathan\_Quarics](https://community.make.com/u/Jonathan_Quarics)\ **Post date:** [May 11, 2025, 5:09pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/9 "2025-05-11T17:09:28Z")
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 ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 11, 2025, 5:20pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/10 "2025-05-11T17:20:11Z")
saw it!! thank you working on it now ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 11, 2025, 5:33pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/11 "2025-05-11T17:33:33Z")
for this one, should i add another module? and another that triggers when the **“Status”** column is updated using the **“Watch Changes”** module. ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 11, 2025, 5:55pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/12 "2025-05-11T17:55:58Z")
Also what apps script are you referring here? ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 11, 2025, 5:56pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/13 "2025-05-11T17:56:58Z")
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. ---
**Author:** ![Jonathan\_Quarics](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jonathan\_Quarics](https://community.make.com/u/Jonathan_Quarics)\ **Post date:** [May 11, 2025, 9:35pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/14 "2025-05-11T21:35:25Z")
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. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [May 12, 2025, 6:41am UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/15 "2025-05-12T06:41:15Z")
Welcome to the Make community! Yes, that is possible. You’ll probably need a minimum of five modules: ![Screenshot 2025-05-12 143900](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/1/21425b9eed3ddf316838d09a523dcb3930747740.png) 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](https://academy.make.com) will save you lots of time and frustration using Make! [—](https://samliew.com/make-discord-invite) @samliew ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 12, 2025, 6:17pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/16 "2025-05-12T18:17:35Z")
Thanks, i’ll try this one ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 12, 2025, 6:37pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/17 "2025-05-12T18:37:16Z")
Hey Jonathan, i tried doing it, but the script i created is getting this error. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/4/64b418e5c460ff8bb4ab0289ad5ba53fadd3848c.png) ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 12, 2025, 6:40pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/18 "2025-05-12T18:40:35Z")
Can you provide the filters you used here? ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/c/2c8c039dfccd6f7c4f78bfb476d66f9e8832d83d.png) ---
**Author:** ![Jonathan\_Quarics](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jonathan\_Quarics](https://community.make.com/u/Jonathan_Quarics)\ **Post date:** [May 12, 2025, 6:56pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/19 "2025-05-12T18:56:49Z")
[Ann\_marie\_Ledesma](https://community.make.com/u/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 ---
**Author:** ![Ann\_marie\_Ledesma](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Ann\_marie\_Ledesma](https://community.make.com/u/Ann_marie_Ledesma)\ **Post date:** [May 12, 2025, 7:04pm UTC](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927/20 "2025-05-12T19:04:10Z")
Yep i created the trigger as well. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/8/08c4b5520fa74af9b83a550b81a1cab9d9828485.png) [Next page](https://community.make.com/t/clickup-task-creation-and-removing-duplicate/81927.md?page=2)