Hi there,
I have some data in a Google Sheet that I want to upload (create) into ClickUp via the function: Create Task (advanced).
In my Google Sheet I put in row 3 the custom field ID in ClickUp
and then the data from row 4 and below.
The Clickup function “Create Task (advanced)” can receive an array of custom fields with ID and VALUE.
As I have many fields to map, I don’t want to do it manually but instead, generate an array of id/value automatically with my columns where row 3 contains an identifier.
Any way to do it?