The Scenario
You are a marketing ops analyst. It is the first week of Q3 and someone in leadership has asked a reasonable question: "How many Typeforms do we actually have, and when was the last time anyone looked at them?"
You know the account has been accumulating forms for three years. You have a rough sense there are sixty or more. You have no idea which ones are still active, which ones have never received a single response, or which workspace they are supposed to live in.
The audit is due by end of week.
The slow version:
- You open Typeform's admin panel and start scrolling
- You can see forms listed but not response counts at a glance
- You open each form individually to check the response count and last modified date
- You copy the title, ID, workspace, and response count into a spreadsheet by hand
- Sixty forms, three to four minutes each, you are still doing this on Friday
- The audit goes out late, half-done, with a note that you "couldn't get to all of them."
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your Typeform account directly, so you do not have to click through sixty admin pages.
Open the SheetXAI sidebar and type:
List all Typeform forms in my account and write form title, form ID, total response count, workspace name, and last modified date into this sheet starting in row 1. Add a column called Status — if a form has zero responses, mark it "Unused." If it has not been modified in over 12 months, mark it "Stale." Otherwise mark it "Active."
SheetXAI pulls the full form list from your Typeform account, writes every form into the sheet, and applies the status logic. You have a complete audit table in minutes, not days.
What You Get
A structured audit table, ready to sort and act on:
- Form title — column A
- Form ID — column B, useful if you need to take action on specific forms later
- Total response count — column C
- Workspace — column D
- Last modified — column E
- Status — column F, one of Active, Unused, or Stale
Sort by Status and you see all the Unused and Stale forms at the top. Paste the list into a Slack message to your team and let them decide what to archive.
If leadership wants a summary count by workspace, ask for that too. SheetXAI adds a pivot-style summary tab showing how many Active, Unused, and Stale forms exist per workspace.
What If the Data Is Not Quite Ready
Typeform accounts have quirks. SheetXAI handles them in the same prompt.
When form names are inconsistent across teams
Three teams have been naming forms differently: "Q2 Survey," "Q2-Survey," and "Q2Survey." You want them normalized before the audit goes to leadership.
List all Typeform forms in my account with title, ID, response count, workspace, and last modified date. Normalize the form titles in a new column called Clean Title by removing hyphens and extra spaces, then apply the Active/Unused/Stale status logic.
When you only want forms from a specific workspace
The audit is scoped to the Marketing workspace only. You do not need to see the Dev or Support forms.
List all Typeform forms in the Marketing workspace only. Write title, ID, response count, and last modified date into this sheet and apply the Active/Unused/Stale status logic.
When you need to flag forms that are missing a description
Your team's naming convention requires every form to have a description. You want to know which ones are missing it.
List all Typeform forms in my account. For each form, check whether it has a description set. Write title, ID, response count, workspace, last modified date, and whether a description is present (Yes/No) into the sheet. Flag forms missing a description in the Status column as "Needs Description."
When the audit needs to drive an archival action immediately
You do not just want a list. You want SheetXAI to archive the Unused forms in the same operation.
List all Typeform forms in my account. Write title, ID, response count, workspace, and last modified date into this sheet. Apply the Active/Unused/Stale status logic. Then delete all forms where response count is zero and last modified date is more than 18 months ago — write "Archived" in the Status column for each one you delete.
The pattern: the audit and the action in one prompt. You review the sheet after, not before.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to list all your Typeform forms with metadata. The Typeform integration is included in every SheetXAI plan. For next steps, see how to reorganize forms across workspaces or the Typeform in Google Sheets overview.