Creating new Clickup tasks from new rows on Google sheet

How To
1

Hi all! I’m trying to do a simple integration between Google sheet - to Clickup tasks.
Every time a new row is added to the sheet → add a new task in the specific list.
I read of using the Swithc function in order to insert the priorities - and it doesn’t work.
What am I doing wrong?
image

How can I add the priority, based on the priority selected in the sheet?

2

Please map the priority variable from google sheet to the expression position (first position) of the switch function.
also, make sure the priority values from the google sheet are in same case of the values(2nd, 4th, 6th and 8th positions)in the switch function.

1 Like
3

Thanks Fasil!
I mapped the priority, it still doesn’t work -
image