The Scenario
You're the RevOps manager at an agency managing 12 client Make accounts. Your director asked you for an org-and-team inventory last Thursday. It's now Monday morning, and the workbook still doesn't exist — because the moment you logged into Make and started clicking through organizations, you realized there were 47 teams spread across 12 orgs, and copying each one by hand was going to take the better part of your morning.
The bad version:
- Open Make, navigate to Organization 1, copy the org ID and name into the workbook, then switch to the Teams tab and copy each team ID and name row by row
- Repeat for all 12 organizations — switching tabs, copying values, reformatting the columns to match the structure you promised the director
- Come back the next day to fix the three rows where you accidentally pasted the wrong org's team data
This inventory is going to leadership. Going in with 47 rows of manually re-entered values — any of which could be wrong — isn't where you want to be.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Make directly and can pull structured data across all your organizations and teams in one request — no clicking through the Make UI, no tab switching.
Open the workbook where you want the inventory and run:
Build a full Make org-and-team inventory in Excel — one row per team with columns for org name, org ID, team name, and team ID
What You Get
- One row per team, with org name, org ID, team ID, and team name filled in across columns A through D
- Organizations appear as labeled groups with their teams nested below them
- Any org with no teams still appears as a row so nothing is silently skipped
- Values land as plain text, ready for filtering and pivot tables without reformatting
What If the Data Is Not Quite Ready
What if I want each org on its own worksheet instead of stacked in one sheet?
List all Make organizations I have access to and create a separate worksheet for each org named after the org — then in each worksheet, list all teams with their team ID and team name in columns A and B
What if the org IDs are already in column A and I just need the team data filled in?
For each Make organization ID in column A, fetch all teams in that org and write each team ID in column B and team name in column C — add multiple rows per org as needed
What if I only want orgs from a specific timezone region?
List all Make organizations and filter to only those with a timezone containing "America" — write org name, org ID, and timezone into this workbook
What if I need the full inventory plus a count of how many teams each org has, in one pass?
List all Make organizations with their org ID, name, and timezone, then for each org list all teams with team ID and team name — add a summary column next to each org row showing the total team count for that org
The approach is to ask for the inventory shape and the derived calculation together, so you're not running the pull and then writing a COUNTIF formula after.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull your Make org-and-team inventory. Also useful: pulling 30-day usage data per org, or exporting pricing plan details — both linked from the Make integration overview.