Export All Ninox Teams and Databases Into a Google Sheet

The Scenario

You're three days out from a company-wide platform migration and someone finally asks the question that should have been answered two weeks ago: does anyone have a complete list of every Ninox team and every database inside each team?

Nobody does.

You have Ninox access. You open it, click through one team, then another. There are seven teams. Some have two databases, some have twelve. You start copying names into a sheet.

The bad version:

1. Open each Ninox team one at a time, write down the team name and whatever ID you can find in the URL or the settings panel.
2. Click into each database, record its name and ID manually — then realize you missed two databases in the third team and have to go back.
3. Format the sheet by hand — column headers, consistent ID formats — before you can share it with the migration lead.

Three hours of your time, for a data structure that Ninox could surface via API in seconds. The migration is in three days and this was supposed to be the easy part.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands the context, and through its built-in Ninox integration it can query your Ninox workspace and write the results directly into the sheet. No exports, no manual ID hunting.

List all Ninox teams I have access to, then for each team list all databases, and write team name, team ID, database name, and database ID into columns A through D

What You Get

• Column A: team name for each row
• Column B: team ID
• Column C: database name
• Column D: database ID
• One row per database — teams with multiple databases produce multiple rows, each with the team fields repeated
• Any teams you don't have access to are skipped silently; SheetXAI notes in the sidebar if any were excluded

What If the Data Is Not Quite Ready

The sheet already has some teams listed but you need to fill in missing IDs

Column A has team names and column B is blank — look up each team name in Ninox and write the team ID into column B where it's missing

You need the output sorted by team name before sharing

List all Ninox teams and databases into columns A through D, then sort the results alphabetically by team name before writing them

You need to filter to only databases within a specific team

List all databases inside the Ninox team named "Finance Ops" and write the database name and database ID into columns A and B

You need the full inventory plus a count of databases per team

List all Ninox teams and their databases into columns A through D, then add a summary in column F that shows each team name once with the count of databases it contains

Asking for cleanup, filtering, and summary together in one prompt is the pattern that saves the most time here — one round-trip instead of four.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet you're using to plan a Ninox migration or audit, then ask it to pull the full team and database inventory. For related tasks, see Document a Ninox Workspace Configuration Into a Google Sheet or the full Ninox integration overview.