The Scenario
A RevOps engineer on your team is building a Make org-provisioning template in Google Sheets. 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 sheet 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 one, parse the JSON response, and manually copy the values into separate tabs in the sheet
- Realize the timezone list has 600 entries and paste them in chunks until the columns are full
You're supposed to be an engineer, not a data entry contractor.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Make's API and can fetch all enumeration types in one request, routing each list to its own tab.
In the provisioning workbook, run:
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 tab in this sheet
What You Get
- A "Regions" tab with region ID and region name in columns A and B
- A "Timezones" tab with timezone name, IANA code, and UTC offset across three columns
- A "Countries" tab with country name and ISO code in columns A and B
- Each tab is ready to use as a named range source for data-validation drop-downs without any reformatting
What If the Data Is Not Quite Ready
What if I only need the timezone list and want it as a single column for a drop-down source?
Pull the full list of Make timezones into column A of this sheet so I can use it as a data-validation source
What if I also need the languages enumeration on its own tab?
Fetch all valid Make regions, timezones, countries, and languages and write each group to a separate tab named after the enum type
What if I need the timezone list filtered to only UTC-offset zones between -8 and +2?
Fetch all Make supported timezones with their IANA codes and UTC offsets, then filter to only timezones with a UTC offset between -8 and +2 and write the results to a tab called "Approved Timezones"
What if I need all four enum types plus a "Validation" tab 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 tab, then create a "Validation" tab listing the enum name and the count of rows pulled for each
The pattern is to ask for the full pull and the summary check in one prompt, so you can verify completeness without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open the provisioning workbook, then ask it to populate your Make enumeration tabs. 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.