Sync Google sheets and ClickUp tasks based on an index field

Getting Started
,
1

I am new to Make, and I am an oldtimer at ease with SQL but a bit lost here, please bear with my newbee question:
I need to sync Google sheets and ClickUp tasks; So I need to change values in rows based on a given index field, for example email address.

  • But when using “Edit Task” (Click* Up) I need to provide the Task ID, and cannot use the email fetched from Google sheet with “Get range value”
  • When I use “Update a Row” (Google sheet), I need to provide Row number, not the email fetched from ClickUp with “List all tasks”

How can I “join” these two tables with the equivallent of a “where” clause? Are there detailed examples somewhere? I do not find relevant tutorial :confused:

2

Hey Emmanuel,

  • use the list filtered tasks module and set the condition that the email custom field must match the email provided. This will only give you tasks with the same email.
  • use the search rows module and search by the email coming from the clickup task’s email custom field. It will give you the row number you need for further processing.

And two alternatives:

  • add the clickup task ID to the google sheet and the google sheet row number as a custom field in the clickup tasks to avoid issues with two entries with the same email or entries with no email.
  • create a data store in make that has two columns → clickup task ID and google sheet row number and add a module in your scenario to search it to find the corresponding entries.