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 workbook 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 Excel workbook. It connects to Make's API and can fetch the full LLM model catalog — tiers, providers, coefficients — in one pass.
In a blank worksheet, run:
Pull the Make LLM builtin tiers (small, medium, large) with all associated models, providers, and cost coefficients into a comparison table in Excel
What You Get
- One row per model with model name, tier, provider, and pricing coefficient across four columns
- 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 workbook
- 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 only the small-tier models?
Fetch all Make LLM models and filter to only small-tier models — write model name, provider, and pricing coefficient into this workbook
What if I want a separate worksheet for each tier?
Fetch all Make LLM builtin tiers with their associated models and create a separate worksheet for each tier — small, medium, and large — with model name, provider, and pricing coefficient in each
What if I want to add an estimated monthly cost column based on 5,000 operations per scenario?
Fetch all Make LLM models with their tiers and pricing coefficients into this workbook, then add a column showing estimated monthly cost for 5,000 operations calculated as coefficient times 5000
What if I need the full model catalog plus a recommendation column flagging the cheapest model per tier 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 Excel workbook 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.