The Scenario
You're a UX designer and you've been staring at the Formbricks analytics dashboard for a survey you ran last month — a 10-question onboarding flow. The aggregate completion rate looks fine, but your instinct says people are dropping off somewhere in the middle.
The dashboard shows a completion percentage. It doesn't tell you which question stops people.
You need the raw response data — completion status and time-to-complete for every respondent — in a Google Sheet so you can calculate where the abandonment is happening.
The bad version:
- Export the full response CSV from Formbricks — all 10 columns of question answers, plus metadata
- Open it in Google Sheets, find the "finished" column and the "time" column, delete the 8 question columns you don't need right now
- Build a pivot table to count finished vs. unfinished, and a second one to average time-to-complete by question number — but you realize the "last answered question" field isn't in the export at all, so you can't actually figure out where drop-off happens without going back to Formbricks
The export got you halfway. The other half requires a different pull.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and through its built-in Formbricks integration can pull the specific response fields you need for drop-off analysis — not the full export, just the columns that matter.
Fetch all responses for the Formbricks survey ID in cell A1 and write respondent ID, finished status, and time-to-complete in seconds into columns B, C, and D
What You Get
- Column B: respondent ID
- Column C: finished status (true or false)
- Column D: time-to-complete in seconds (blank if the response is incomplete)
- One row per response, starting at row 2
- Responses ordered by submission date ascending by default
What If the Data Is Not Quite Ready
You only want the incomplete responses
The drop-off analysis only needs the people who didn't finish. Completed responses are noise for this specific question.
Pull all incomplete (finished=false) responses from my Formbricks survey and write the last answered question and submission date into this sheet for drop-off analysis
You want to group time-to-complete into buckets
For the design review, you want to show the distribution — not a raw list of seconds, but buckets: under 60 seconds, 60–180, 180–300, over 300.
Fetch all responses for the Formbricks survey ID in cell A1, write respondent ID (column B) and finished status (column C) — then add a "Time Bucket" column (column D) that says "Under 1 min" for time-to-complete below 60, "1–3 min" for 60–179, "3–5 min" for 180–299, and "Over 5 min" for 300 or more
You need to join drop-off data with respondent email
For follow-up outreach, you need to know who dropped off — not just that they did.
Fetch all incomplete responses for the Formbricks survey ID in cell A1 — write respondent ID (column B), respondent email (column C), last answered question (column D), and submission date (column E)
Full drop-off analysis in one shot
Fetch all responses for the Formbricks survey ID in cell A1, write respondent ID, finished status, time-to-complete, and last answered question into this sheet — then add a summary row at the bottom showing total responses, completion rate as a percentage, and average time-to-complete for finished responses only
The raw data and the summary statistics land together. The design review deck doesn't need a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a Formbricks survey ID — then ask it to pull completion and drop-off data for your UX analysis. The Formbricks integration is included in every SheetXAI plan. If you also want to pull the full response text for qualitative review, see the export survey responses spoke, or start with the Formbricks overview for all integration options.