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

Export All Paperform Forms Into a Google Sheet for a Form Library Audit

2026-05-14
5 min read

The Scenario

It's Thursday afternoon and you've just been handed a cleanup project. The company has 45 Paperform forms spread across four spaces, and nobody has a clear picture of what's still active and what's been sitting idle for eight months. Your job is to build the audit spreadsheet: every form, its ID, the space it lives in.

The bad version:

  • Open Paperform, navigate to the form library, and start writing down form names one at a time — clicking into each form's settings panel to find the ID because it doesn't display in the list view
  • Switch to the spaces panel, cross-reference which forms belong to which space, and fill in the space column manually for all 45 rows
  • Go back and verify that the IDs you wrote down match what's actually in the URL bar, because three of them look suspiciously similar and you're not confident you got them right

That's a two-hour job on a day you already had other things on the list. And when someone asks you to re-run the audit next quarter, you do it again from scratch.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that runs inside your Google Sheet. It reads the sheet and, through its built-in Paperform connection, can query your entire form library and write the results directly into your columns — no copy-pasting, no tab-switching, no ID transcription.

List all my Paperform forms and write each form's name, ID, and space into this sheet — get all forms in one pull

What You Get

  • Column A: form name for every form in your Paperform account
  • Column B: form ID (the exact string, not an approximation)
  • Column C: the space name the form belongs to
  • All forms returned in one operation — no pagination you have to manage manually

What If the Data Is Not Quite Ready

Some forms have no space assigned

List all my Paperform forms and write name, ID, and space into columns A through C — for any form with no space assigned, write "Unassigned" in column C

You want to sort by space before writing

Fetch all Paperform forms and write them into this sheet sorted by space name, then alphabetically by form name within each space — columns: form name, form ID, space name

You need form IDs from multiple spaces cross-referenced against a second tab

I have a list of space names in column A of the "Spaces" tab — fetch all Paperform forms and write each form's name, ID, and space into the "Forms" tab, but only include forms that belong to spaces listed in the Spaces tab

Full audit pull with an active/inactive flag

Fetch all Paperform forms, write name, ID, and space into columns A through C of this sheet, and in column D write "Review" for any form whose name contains "old", "test", "draft", or "copy" — everything else gets "Active"

The most efficient audit runs both the data pull and the classification in the same prompt.

Try It

Get the 7-day free trial of SheetXAI and open the Google Sheet where your form audit lives — then ask it to populate every row from your Paperform account in one shot. If you also need to map forms back to spaces, see the spaces inventory spoke or the full Paperform overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

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

Learn more