The Scenario
A RevOps engineer on your team is building a Make org-provisioning template in Excel. The template will let the ops team spin up new client organizations by filling in a row and running a script — but one of the script's failure modes is submitting an invalid region or timezone string to Make's API and getting a 422 back. That's been happening three times a week.
The fix is a set of data-validation drop-downs sourced from Make's actual accepted values. You've been handed that task. The Make API has enumeration endpoints for regions, timezones, countries, and languages. They need to live in the workbook as drop-down sources — but first someone has to get them there.
The bad version:
- Find the Make API documentation for each enumeration endpoint, write or run an API call for each, parse the JSON response, and manually copy the values into separate worksheets
- Realize the timezone list has 600 entries and paste them in chunks
- Discover on the third endpoint that the response shape is different and you have to reparse the output
You're supposed to be building the provisioning template, not acting as a data entry contractor for enumeration lists.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Make's API and can fetch all enumeration types in one request, routing each list to its own worksheet.
In the provisioning workbook, run:
Pull the full list of Make timezones into column A and their IANA codes into column B of this Excel sheet so I can use them as a data-validation source
Or for all enumerations at once:
Fetch all valid Make regions with their region IDs, all supported timezones with IANA codes and UTC offsets, and all supported countries with ISO codes — write each group to a separate worksheet in this workbook
What You Get
- A "Timezones" worksheet with timezone name in column A and IANA code in column B, ready for data-validation drop-down configuration
- A "Regions" worksheet with region ID and region name in columns A and B
- A "Countries" worksheet with country name and ISO code in columns A and B
- Each worksheet is immediately usable as a named range source without reformatting
What If the Data Is Not Quite Ready
What if I need only the timezone list filtered to UTC offsets between -8 and +2?
Fetch all Make supported timezones with IANA codes and UTC offsets, filter to only timezones with UTC offset between -8 and +2, and write the results to a worksheet called "Approved Timezones"
What if I also need the languages enumeration on its own worksheet?
Fetch all valid Make regions, timezones, countries, and languages and write each group to a separate worksheet named after the enum type
What if I want the IANA code in column A and the display name in column B for the drop-down configuration?
Fetch all Make supported timezones and write IANA code into column A and display name into column B of this worksheet
What if I need all four enum types plus a "Validation" worksheet that shows the count of valid values for each type so I can confirm the pull was complete?
Fetch all Make enumerations — regions, timezones, countries, and languages — write each to a separate worksheet, then create a "Validation" worksheet listing the enum name and the count of rows pulled for each
The pattern is to ask for the full pull and the completeness check in one prompt, so you can hand off the provisioning workbook without a second verification pass.
Try It
Get the 7-day free trial of SheetXAI and open the provisioning workbook in Excel, then ask it to populate your Make enumeration worksheets. Also useful: pulling the Make LLM model catalog for AI planning, or exporting module and variable type enums for administration templates — both covered in the Make integration overview.