Automatizar CLICKUP

Questions
,
1

image
image462×302 8.25 KB

I’m building an automation using n8n + ClickUp, and I need to fetch multiple completed tasks from a specific date onward — this part works fine. These are tasks that were already completed, and their data needs to be inserted into Excel.

The problem is that when the workflow runs again, I can’t prevent duplicate records from being added to Excel.

Additionally, I don’t want to manually select folders or lists in ClickUp. Instead, I want to fetch all tasks from an entire Space or Group, rather than selecting each list individually.

For example, I want to retrieve all tasks from the whole group/space, not list by list.

What is the best way to:

  1. Avoid inserting duplicate rows into Excel when the workflow runs again?

  2. Fetch all tasks from a group/space without manually selecting folders or lists?

Any guidance or best practices would be greatly appreciated.

2

Looks like you’re running into the common problem of avoiding duplicates when pulling data from ClickUp.

1. **Avoiding Duplicates:** Before writing to Excel, use a “Filter” node to check if the task ID already exists in your Excel sheet. You can read the Excel sheet into n8n, then compare IDs.

2. **Fetch all tasks:** Use the ClickUp node and set the “Search Type” to “Search Tasks”. You can then use the “space_ids” parameter to specify the Space or Group you want to retrieve tasks from, instead of selecting lists individually.

Let me know if this works!