Back to Sentry in Google Sheets
SheetXAI logo
Sentry logo
Sentry · Google Sheets Guide

Export All Sentry Projects and Teams to a Sheet for an Observability Audit

May 11, 2026
4 min read
See the Excel version →

The Scenario

You are a DevOps manager who joined the company three weeks ago. You have been given full Sentry access. Nobody has given you a map.

You need to know: how many projects are in the organization, which teams own which projects, what platforms they are running, and where the DSNs are. You have an observability review with the CTO in two days and you need this in a spreadsheet so you can annotate it.

The slow version:

  • Open Sentry Settings, navigate to Projects
  • Start reading project names and clicking into each one for platform and team info
  • Open a separate tab for Teams, check which projects each team owns
  • Try to cross-reference, realize the UI does not give you this in one view
  • Copy rows into a Google Sheet manually
  • You get through twelve projects and run out of time.

The fast version is one prompt.

The Easy Way: One Prompt in SheetXAI

SheetXAI reads your Sentry organization and writes the full project map into the sheet, so you do not have to click through the settings UI.

Open the SheetXAI sidebar and type:

List all Sentry projects in organization 'my-org' and write each project's name, slug, platform, team, and date created into this sheet, one row per project. Add a header row. Sort alphabetically by team name.

SheetXAI calls the Sentry projects API, pulls every project with its team assignment and platform, and writes the full list into the sheet. Twenty, forty, sixty projects, it does not matter. The whole thing lands in under two minutes.

What You Get

A structured project directory with one row per Sentry project:

  • Project name — the display name in Sentry
  • Slug — the API identifier, useful for follow-up API calls
  • Platform — javascript, python, go, ruby, whatever each project uses
  • Team — the owning team slug
  • Date created — how old the project is

Add an "Annotated Owner" column next to the team column and start filling in the humans behind each team slug. That is the artifact for the CTO review, a living directory, not a screenshot of the Sentry settings page.

What If the Data Is Not Quite Ready

Infrastructure audits always surface questions the original pull cannot answer. SheetXAI handles the follow-ups in the same sheet.

When team names in Sentry are slugs and you want display names

Sentry returns team slugs like backend-infra and fe-platform. You want the display names for the CTO deck.

List all Sentry teams in organization 'my-org' and write each team's slug and display name into a lookup tab called Teams. Then update the main project list: for each project's team slug in column D, look up the display name from the Teams tab and write it in column E.

When you want to see which projects have no team assigned

Orphaned projects are a common finding in new-joiner audits.

List all Sentry projects in 'my-org'. For each project, write the name, slug, platform, team, and date created. In a column labeled Status, write 'unowned' if the team is blank and 'owned' if a team is assigned. Sort so unowned projects appear at the top.

When the CTO also wants the team membership count per team

The review question is: which teams are under-resourced relative to how many projects they own?

List all Sentry teams in 'my-org'. For each team, write the team name, slug, number of projects assigned, and number of members. Sort by number of projects descending.

When you need the full picture: projects, teams, DSNs, and a risk flag in one pass

The CTO wants to know which projects are active and which look dormant based on when they were created.

List all Sentry projects in 'my-org'. Write project name, slug, platform, team, date created, and DSN into columns A through F. In column G, write 'active' if the project was created in the last 12 months and 'review' if it is older than 12 months and has no recent issues. Add a summary row at the top showing total project count, active count, and review count.

The pattern: one prompt gets you the map. Follow-up prompts in the same session get you the analysis on top of it.

Try It

Get the 7-day free trial of SheetXAI and ask it to list your Sentry projects and teams before your next infrastructure review. The Sentry integration is included in every plan. See also how to audit Sentry alert rules or the Sentry in Google Sheets overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more