The Scenario
You are a product analyst. You have a Sheet with 80 person IDs from sign-up events — users who created accounts in January. You need to know how many of them hit the "upgrade_clicked" event before converting to paid. That number is the metric your head of product is using to evaluate the onboarding flow.
GoSquared has every event for every person. But the dashboard is built for looking at one person at a time, not for pulling 80 event feeds and counting a specific event across all of them. You need the count in a Sheet column before the product review on Thursday.
The slow version:
- You click into the first person ID in GoSquared People, scroll through their event feed, count the "upgrade_clicked" events manually
- You record the count in the Sheet, go back to GoSquared, click the next person ID
- Person 7 has 400 events in their feed and the dashboard loads slowly
- Person 19 has no event data at all — either a bad ID or a person GoSquared never saw events for
- By Thursday morning you have counted 35 of 80 people and your number is not ready.
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 event feeds through the API, so you do not have to click through 80 individual profiles in the dashboard.
Open the SheetXAI sidebar and type:
For each person ID in column A, fetch their GoSquared event feed and count how many times the event 'upgrade_clicked' appears. Write the count into column B. If a person ID returns no events, write 0.
SheetXAI calls the GoSquared People events endpoint for each of the 80 person IDs, counts the target event in each feed, and writes the count into column B. You have a complete column of counts before the product review.
What You Get
A complete event count for each person in the sheet:
- Person ID column — unchanged from your input
- Event count column — how many times each person fired "upgrade_clicked," with 0 for anyone with no events
- 80 rows processed — every person covered, not just the ones you got to before the meeting
The zeros are as useful as the counts. A person who signed up and never hit "upgrade_clicked" is a signal the onboarding flow never got them there. A person with 12 "upgrade_clicked" events before converting tells a different story.
What If the Data Is Not Quite Ready
Event analysis is almost always more nuanced than "count one event and stop."
When you need counts for multiple events
Your head of product wants to see the funnel — not just "upgrade_clicked" but "onboard_complete" and "first_export" as well.
For each person ID in column A, fetch their GoSquared event feed. Count how many times each person fired 'onboard_complete', 'first_export', and 'upgrade_clicked'. Write the three counts into columns B, C, and D respectively.
When you need the most recent events, not a count
You want to see each person's last 5 event names and timestamps to spot patterns in what people do right before they drop off.
For each person ID in column A, pull their GoSquared event feed and write the 5 most recent event names and timestamps into columns B through K of this sheet — two columns per event (name and timestamp), most recent first.
When some person IDs in the sheet are not in GoSquared
The 80 IDs came from your app database and some users may have been identified with a different visitor ID in GoSquared, or not identified at all.
For each person ID in column A, fetch their GoSquared event feed. If GoSquared returns an empty feed or a not-found error, write 'Not in GoSquared' in column B. If events are found, count the 'upgrade_clicked' occurrences and write the count in column B.
When you need the event count plus a conversion label and a recommendation
Your head of product wants not just the counts but a column that labels each person as a "fast converter," "slow converter," or "non-converter" based on the event timeline, and a brief observation about the pattern.
For each person ID in column A, fetch their GoSquared event feed. Count the 'upgrade_clicked' events and write the count in column B. In column C, label each person: 'Fast Converter' if they hit 'upgrade_clicked' within 3 days of their first event, 'Slow Converter' if they hit it after 3 days, 'Non-Converter' if they never hit it. In cell A1 of the Summary tab, write a two-sentence observation about the most common pattern across all 80 users.
The pattern: fetch the feeds, count the events, classify the behavior, summarize the pattern. One prompt replaces 80 manual profile visits and an hour of counting.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull GoSquared event feeds for any list of person IDs in your sheet. The GoSquared integration is included in every SheetXAI plan. See also how to track GoSquared custom event counts by day or the GoSquared in Google Sheets overview.