Im new to zapier so forgive my ignorance. I want to create the following scenario:
An update to a google sheet rows happens every 2-3 days. The rows are updated in bulk, meaning that at any given second there could be at least 20 rows updated.
- I need to create a single ClickUp list for every single bulk rows being added. One of the columns has the name, in every row, for the list name. I think I need to add a filter here to prevent a list being created for every single row being updated. I don't know what my criteria should be?
- Then I need to add all the new rows as tasks, each row being an individual task within the newly created list. Im struggling to figure out if this should be a second zap or keep it on the same zap and ensure that the list ID is correctly connected to the new tasks?
Im stuck at the beginning of this and would like someone to just guide me through the whole process.
Thanks so much
Donald