The Scenario
You inherited a Google Sheet from a developer who left last month. Column A has fifteen Ninox database names — the ones the integration scripts are supposed to talk to. But the scripts need database IDs, not names.
You have Ninox access. You could open it, find each database, copy the ID from the URL or the settings screen, and paste it into column B. Fifteen times.
The bad version:
- Open Ninox, navigate to the first database in column A, find the ID somewhere in the settings or the URL, copy it.
- Switch back to the sheet, find the right row, paste the ID into column B.
- Repeat fourteen more times — and wonder halfway through whether the database name in row 7 matches a database you already looked at, or a different one with a similar name.
You're not a developer. You were handed this sheet because the developer left. The scripts are supposed to go live next week and nobody else knows what database IDs they need.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data already in the sheet and can query Ninox through its built-in integration — looking up each database by name and writing the matching ID back into the cell you specify.
Column A has Ninox database names — look up each name in Ninox and write the matching database ID into column B
What You Get
- Column B filled with the database ID for each name in column A
- Rows where the name doesn't exactly match a Ninox database get a note in column C so you can investigate rather than shipping a blank ID to the integration script
- The lookup runs across all teams you have access to — you don't have to specify which team each database lives in
What If the Data Is Not Quite Ready
Some names in column A have trailing spaces or inconsistent capitalization
Column A has Ninox database names — some may have extra spaces or mixed case. Normalize each name, look up the matching database ID in Ninox, and write the ID into column B
The list spans A2 through A15 and you want errors flagged in column C
A2:A15 contains Ninox database names — look up each one in Ninox, write the database ID into column B, and write "not found" into column C for any that don't match
You need the team name alongside the database ID for the integration config
Column A has Ninox database names — for each one, write the database ID into column B and the name of the team it belongs to into column C
You want the full lookup plus a readiness check for the integration
A2:A15 has Ninox database names — look up each one in Ninox, write the database ID into column B, flag "not found" in column C for misses, and add a formula in column D that marks rows as "ready" only when column B has an ID
Every one of those is a single prompt. The pattern of combining the lookup with the cleanup and the flagging means you get a usable, validated output in one pass rather than three.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your Ninox database names, then ask it to match each one to its ID. For related tasks, see Export All Ninox Teams and Databases Into a Google Sheet or the full Ninox integration overview.