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 document 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 sheet, 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 Google Sheet. 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 sheet where you want the inventory and run:
List all Make organizations I have access to and write organization ID, name, and timezone into this sheet, then for each org list all teams and add them as rows below with org name, team ID, and team name
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
- The timezone column populates for each org so you can spot accounts that need scheduling adjustments
- Any org with no teams still appears as a row so nothing is silently skipped
What If the Data Is Not Quite Ready
What if I want each org on its own tab instead of stacked in one sheet?
List all Make organizations I have access to and create a separate tab for each org named after the org — then in each tab, 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?
List all Make organizations and filter to only those with a timezone that matches "America" — write org name, org ID, and timezone into this sheet
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 Google Sheet, 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.