The Scenario
You are a DevOps lead. The billing review is next Tuesday and your finance director has asked you to identify idle Supabase projects to pause before the next cycle.
Your company runs twelve Supabase projects across three teams. You know the project names, but not which ones are active. You need: project name, ref, region, status, and creation date — in a sheet, before the meeting.
The slow version:
- You log into the Supabase dashboard
- You click through each project one by one
- You open a Google Sheet and type the details in by hand
- You mistype one ref ID and have to go back
- You cannot find the creation date for three projects — it is not on the project overview page
- You walk into the billing review with an incomplete inventory and get asked to follow up.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Supabase account directly and writes the full project inventory into the sheet, so you do not have to click through the dashboard or type anything by hand.
Open the SheetXAI sidebar and type:
List all my Supabase projects and write project name, ref ID, region, status, and creation date into this sheet — one row per project. Highlight any projects with status 'inactive' in yellow.
SheetXAI calls the Supabase API, retrieves all twelve projects, writes the inventory with the conditional formatting applied.
What You Get
A complete project inventory in the sheet:
- One row per project — name, ref, region, status, creation date
- Inactive projects highlighted in yellow — visible at a glance for the billing discussion
- All twelve projects — no dashboard clicking, no manual entry
You walk into the billing review with the full picture. The finance director can see which projects are idle. The conversation is about decisions, not about where to find the data.
What If the Inventory Needs More Context
A raw project list is a starting point. SheetXAI can enrich it in the same prompt.
When you need to flag projects older than 90 days with no recent activity
Creation date alone does not tell you whether a project is actually used.
List all Supabase projects and write name, ref, region, status, and creation date into this sheet. In column F, flag any project created more than 90 days ago with status 'inactive' as "PAUSE CANDIDATE."
When you want projects grouped by team
Your twelve projects belong to three teams and you want to see the split.
List all Supabase projects and write name, ref, region, status, and creation date into this sheet. Add a Team column based on the project name prefix: projects starting with "alpha-" are Alpha Team, "beta-" are Beta Team, "shared-" are Shared Infra. Sort by team then by creation date.
When you need to count projects per region for capacity planning
You are deciding which region to standardise on for new projects.
List all Supabase projects and write name, ref, region, and status into this sheet. Then in cell F1, write a summary showing how many projects are in each region.
When you need the full picture: inventory, region breakdown, and pause list in one shot
List all Supabase projects and write name, ref, region, status, and creation date into the Inventory tab. In the Summary tab, write a region breakdown showing project count per region. In the Pause Candidates tab, list only the projects that are inactive or were created more than 6 months ago and have never been the most recently updated project in their region.
The pattern: the prompt does the filtering and annotation, so the sheet is ready to share, not just ready to review.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull your Supabase project inventory. The Supabase integration is included in every SheetXAI plan. For related workflows, see how to audit database branches for stale environments or the Supabase in Google Sheets overview.