Search click up tasks by google sheet and add new task for ones that are missing

How To
,
1

Make creates new clickup tasks from google sheet, but all of the names on the google sheet is not in clickup. How do I search clickup for tasks that are on the google sheet but not in click up and add the task to clickup if it isnt there

I don’t use clickup task ID. The clickup task name is column F on the google sheet (a person’s name). If the name is on the google sheet but not clickup task name under any status in the list, I would like make to add a new task. trying to avoid duplicate imports here since there are over 700 names. Thanks!

4

Hi @Raveena_Ramnauth ,

Since their ClickUp modules don’t have any Search type module, I’d suggest using this below as a workaround. Please note that the “Create - Set Variable module” represents as the Click Up Create a Task module, same as well with the Update - Set variable module in which it’s the Edit a task module.

image
image2645×1484 457 KB

For the update module, since it will ask for the task ID, it will look like this below. The logic is "Get the Task ID from the Array Aggregator if the Task Name from the trigger is “XYZ”.
image

I hope this helps!

3 Likes