The Scenario
The HR director forwarded you a Slack message at 8 AM: leadership wants to review the onboarding survey results at the 2 PM all-hands. Three hundred responses, she said. The file needs to be readable — not a spreadsheet full of item_7 and item_14 that requires a Rosetta Stone.
You know the responses are in Formsite. What you don't know, offhand, is how Formsite stores them — and when you export the CSV, the column headers confirm your concern: numeric item IDs, no question text, no context. Whoever receives this file will have no idea what item_12 means without cross-referencing the form builder.
The bad version:
- Export the CSV from Formsite's Results page and open it in Google Sheets.
- Open the Formsite form builder in a separate tab to look up what each item ID corresponds to.
- Manually rename 22 columns to their actual question text, one by one.
It's 8:15 AM. The all-hands is at 2. You've already used thirty minutes on column renaming and you haven't started the actual review.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It uses Formsite's item definitions API to retrieve the question labels for a form, then pulls the results and uses those labels as column headers — all in one step.
Fetch the form items for "Employee Onboarding Survey" from Formsite to get question labels, then pull all results and use those labels as column headers in this sheet starting at A1
What You Get
- Row 1: column headers from the actual question text — "How would you rate your first week?" not "item_9"
- Row 2 onward: one row per submission, values aligned to their corresponding question columns
- Submission ID and timestamp included from Formsite result metadata
- Any item type not applicable to a given row (e.g., section headers, instructions): omitted from the output or left blank depending on form structure
What If the Data Is Not Quite Ready
Some questions have multiple-choice responses and I want each option on its own line, not concatenated
Fetch form items and results for Formsite form "Employee Onboarding Survey" — for any multiple-choice or checkbox questions, write each selected option as a separate entry in its column rather than combining them with a separator
The form has been updated since the first responses came in, so older submissions are missing answers to newer questions
Pull form items and results for "Employee Onboarding Survey" from Formsite — for older submissions that predate new questions, leave those cells blank and note in column A the submission date so I can see which responses are pre- and post-update
I only want the results for a specific subset of questions — skip the demographic fields
Fetch form items for "Employee Onboarding Survey" from Formsite, then pull results but only include columns for questions that contain the word "satisfaction" or "recommend" in the question text
Pull the data, rename the headers to plain English, flag incomplete responses, and sort for presentation
Fetch form items and all results for Formsite form "Employee Onboarding Survey" — use question labels as headers, flag any row where more than 5 questions are blank by writing "INCOMPLETE" in column A, sort by submission timestamp descending, and format the sheet so row 1 is bold
The cleanup and the export happen in one pass. By the time the prompt finishes, the sheet is ready to share.
Try It
Open a Google Sheet and get the 7-day free trial of SheetXAI — then ask it to pull your Formsite onboarding or exit survey with readable question headers. If you're working with multiple forms, see how to audit your full form inventory or pull all survey responses for the broader integration overview, visit Formsite + Google Sheets.