The Scenario
The quarterly security review is three days out. Your data engineering lead has been told to produce a full inventory of every Hex project in the workspace — all 60 of them — including project name, owner, last modified date, and publication status. The output needs to land in an Excel workbook so the security team can work through it without logging into Hex.
There is no export button in Hex that does exactly this. There is an API. You could write a script, authenticate it, paginate through the results, parse the JSON, and paste the values into the workbook. That's a morning of work you don't have this week.
The bad version:
- Open the Hex API docs, find the list-projects endpoint, figure out the authentication model.
- Write a script or build a Power Automate multi-step to paginate through all projects.
- Parse the response, extract the four fields, handle pagination, format the output, paste it into the workbook manually.
The security review is on Thursday. This is Tuesday afternoon. Writing and debugging an API script is a different Tuesday's problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It can read your workbook structure and talk to the Hex API to pull exactly the data you need — no scripting, no pagination logic on your end.
Open the SheetXAI sidebar and paste this prompt:
List all Hex projects and write project name, owner, status, and creation date into columns A through D of my sheet — one project per row, starting from row 1.
SheetXAI calls the Hex API, handles pagination across all 60 projects, extracts the four fields, and writes them into your workbook. Column headers land in row 1, data starts in row 2.
What You Get
- Column A: project name as it appears in Hex.
- Column B: owner email address.
- Column C: publication status — typically "published," "draft," or "archived."
- Column D: creation date in ISO 8601 format.
- All 60 projects, paginated automatically — you don't see the API calls, you see a full worksheet.
What If the Data Is Not Quite Ready
You only need published projects, not drafts
The security team only cares about projects that are live and accessible to users — drafts are out of scope.
Fetch all Hex projects filtered by published status and write their title, owner email, and last run date into my sheet — one row per project, starting from row 1.
You need to flag projects with no owner assigned
Some projects in older workspaces were created by a user who has since been deactivated, leaving the owner field blank.
List all Hex projects and write name, owner email, and status into columns A through C. In column D, write "No owner" if the owner field is empty, otherwise leave it blank.
You need to join the project list against an internal roster
You have a list of team members in a separate worksheet ("Roster", column A = email) and you want to flag any Hex project owned by someone not on that roster — a sign of a stale or unauthorized project.
List all Hex projects and write name and owner email into columns A and B of my sheet. For each owner email, check the Roster worksheet column A. If the email is not found there, write "Not on roster" into column C. Otherwise write "OK."
Pull the full inventory, flag stale projects, and sort by last-run date in one pass
You want every project, with a flag for anything not modified in the last 90 days and the list sorted so the most recently run projects appear first — so the security team can triage from the top.
Fetch all Hex projects and write name, owner email, status, creation date, and last modified date into columns A through E. In column F, write "Stale — review" for any project where the last modified date is more than 90 days ago, otherwise write "Active." Sort the output by last modified date descending before writing.
One prompt handles the pull, the flag logic, and the sort — the workbook arrives ready for the security team to work through.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your Hex project inventory for an audit or governance review. For the next step in a compliance workflow, see Audit Hex Workspace Users and Flag Inactive Accounts or the Hex integration overview.