The Scenario
You are a growth manager at a 15-person SaaS company. The quarterly engagement review is tomorrow at 2 PM. Your VP of Success wants a sheet with every tracked user, their last-seen date, and their total event count so the team can score engagement and flag accounts at risk.
GoSquared shows you the numbers inside the dashboard. But your VP does not work in the GoSquared dashboard. She works in Google Sheets. There are 3,000 tracked users in GoSquared People.
The bad version of this afternoon:
- You open GoSquared, look for a People export button, find it, start the download
- The CSV lands with Unix timestamps and a column order that matches nothing in your report template
- You spend twenty minutes reformatting dates and renaming headers
- You realize the export capped at 1,000 rows and you have 3,000 users
- You run three separate exports, stitch them together, and deduplicate
- You walk into the 2 PM review with a sheet your VP has never seen and no time to explain it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads GoSquared People through the API, so you do not have to manage exports, pagination, or reformatting by hand.
Open the SheetXAI sidebar and type:
Pull all people from GoSquared into this sheet with columns for email, name, last seen, and total event count. Sort by last seen descending so the most recently active users appear at the top.
SheetXAI calls the GoSquared People API, paginates through all records, writes them into the sheet with the column names you specified, and sorts them. The sheet is ready before your next meeting.
What You Get
A flat list of every GoSquared People record, structured for immediate use:
- Email column — the address GoSquared has on file
- Name column — display name where available
- Last seen column — formatted as a readable date, not a Unix timestamp
- Total event count column — the engagement signal your VP actually wants to score against
The sort is applied at write time. The most-at-risk users — the ones with the oldest last-seen dates — surface at the bottom. The most active land at the top. No pivot needed.
If you want to add a scoring formula in column E after SheetXAI writes the data, you can tell it to do that in the same prompt. Ask SheetXAI to flag any user who has not been seen in more than 30 days as "At Risk" in a Status column and it will add the conditional logic inline.
What If the Data Is Not Quite Ready
Real GoSquared People data is rarely clean. Some profiles have gaps, some have duplicate emails, some have properties you need but that are not in the default export.
When some profiles are missing email
GoSquared identifies users by visitor ID, and not every visitor has been identified with an email yet.
Pull all GoSquared People into this sheet. If a person has no email, write their visitor ID in the email column instead and mark the row with "No Email" in a Status column. Include last seen and total event count for all rows regardless.
When you only want users on a specific plan
You do not need every user. You need the trial users specifically for the engagement review.
Search GoSquared People for users where the plan property equals 'trial'. Write them into this sheet with email, name, last seen, created date, and total event count. Sort by created date ascending so the oldest trials appear first.
When event count alone is not enough
Your team wants to know not just the total event count but whether the user has ever hit a specific key event — say, "export_completed."
Pull all GoSquared People into this sheet with email, name, and last seen. For each person, check whether they have ever fired the event 'export_completed' and write Yes or No in a column called Reached Key Action.
When you need to score and segment in the same operation
You want the full export, a health score, and a segment label in one shot so the sheet is ready to hand off without any manual work.
Pull all 3,000 GoSquared People into this sheet with email, name, last seen, and total event count. In column E, add a Health Score: 10 points for each event fired in the last 7 days, capped at 100. In column F, add a Segment label — Active for scores above 60, At Risk for 30 to 60, and Churned for below 30. Sort by Health Score descending.
The pattern: instead of exporting a flat file and scoring it separately, you ask for the export, the scoring, and the segmentation in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your GoSquared People records into any open sheet, then score or segment them however your team needs. The GoSquared integration is included in every SheetXAI plan. For related workflows, see how to export GoSquared Smart Group members or the GoSquared in Google Sheets overview.