The Scenario
You're a solutions architect at an agency that builds Make AI-mapping workflows for clients. You have ten new scenarios scoped out, and each one uses an LLM model step. The question your director asked this morning, before the 9 AM review: which model tier should these scenarios use, and what's the cost differential across 10 scenarios running 5,000 operations each per month?
To answer that you need Make's full LLM model catalog — model name, provider, tier (small / medium / large), and pricing coefficient. The documentation has partial information. The API has the rest. You have about 40 minutes before the review starts.
The bad version:
- Search the Make documentation for the LLM model catalog, find it partially documented
- Call the Make API endpoint for AI models, parse the JSON, and copy the model names and tiers into a sheet by hand
- Try to reconstruct the pricing coefficients from a support article that was last updated eight months ago
Walking into that review with incomplete or stale data is not the way.
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 the full LLM model catalog — tiers, providers, coefficients — in one pass.
In a blank sheet, run:
Fetch all available Make LLM models and their builtin tier classifications and fill this sheet with model name, tier, provider, and pricing coefficient — one row per model
What You Get
- One row per model with model name in column A, tier (small / medium / large) in column B, provider in column C, and pricing coefficient in column D
- All three tiers represented so you can filter by tier and compare within each
- Pricing coefficients appear as numeric values so you can build a cost formula directly in the sheet
- Any model without a pricing coefficient listed gets a blank cell rather than a zero
What If the Data Is Not Quite Ready
What if I want to see only the small-tier models to narrow the cost-conscious options?
Fetch all Make LLM models and filter to only small-tier models — write model name, provider, and pricing coefficient into this sheet
What if I want a separate tab for each tier?
Fetch all Make LLM builtin tiers with their associated models and create a separate tab for each tier — small, medium, and large — with model name, provider, and pricing coefficient in each
What if I want to add a monthly cost estimate column based on 5,000 operations per scenario?
Fetch all Make LLM models with their tiers and pricing coefficients into this sheet, then add a column showing estimated monthly cost for 5,000 operations per scenario calculated as coefficient times 5000
What if I need the full model catalog plus a recommendation column flagging the cheapest model per tier that's available from a specific provider?
Fetch all Make LLM models with their tiers, providers, and pricing coefficients, then add a "Cheapest in Tier" column marking the lowest-coefficient model from OpenAI in each tier
The approach: pull the catalog and compute the recommendation in one prompt rather than pulling first and building formulas after.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next architecture review, then ask it to pull the full Make LLM model catalog. Also useful: exporting Make pricing plan details for contract renewals, or pulling enum reference tables for provisioning templates — both covered in the Make integration overview.