From Google Sheet to ClickUp Custom Fields

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?