Clickup | List all custom fields available options to Google sheets

[Aviel]

Hi all,
I’m fairly new at this and could not find examples that i could follow and make them work.

I have a list with 52 custom fields, some are drop-down and some are labels.
I would like to create a google sheet with:

1. A list of all custom fields, name, id, type and orderIndex.
2. For each custom field that is of “Label” or “drop-down” type, i would like to list all the options for that custom field. name/value, id, order index.

Any help will be appreciated.
Thanks in advance

[samliew]

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of five modules:

Perhaps it might be easier if you manually create the spreadsheet document first.

Give it a go and let us know if you have any issues!

I would suggest completing the Make Academy before jumping into building a complete scenario.

If you need specific assistance when you are building a scenario it’s easier to help you then.

Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate
• Discord Server – join us in a community-run live chat

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make

samliew – how can I help you?

Join the Make Fans Discord server to chat with other makers!