Clickup tasks with subtask to google sheets. the main task row gets updated with subtask

Questions
1

ClickUp task created along with subtask to Google sheet. it creates execution for each task and subtask. the subtask row sometime overwrite the main task row. thought the google sheet is in append mode.
have shared the work flow. if someone can let me know how to sort this issue it would be great.

image
image1485×339 20.8 KB

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.61
  • **Database (default: SQLite):**Default
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**Default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**Docker
  • Operating system: Linux
2

Hey @Vinod_Kanted , the loop looks strange. I suspect you meant it to be like below instead. Otherwise it plays no role and is redundant meaning no delays are introduced between records appends. Hence, the rows might get overridden.

3

The issue is when a recurring task which has a subtask is completed, and a new recurring task is created by system along with the subtasks, the google sheet row gets overwritten.
Say we have 1 main task and 5 subtasks, and when the new task is created by system we are supposed to have 5 new rows of data in the google sheets where as it is just 4. The main task row is overwritten by subtask row. This happens too fast, have added wait time still.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.