The Scenario
You are a product analyst. You have an Excel workbook 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.
The slow version:
- You click into the first person ID in GoSquared People, scroll through their event feed, count the "upgrade_clicked" events
- You record the count in the workbook, go back to GoSquared, click the next person ID
- Person 7 has 400 events and the dashboard loads slowly
- Person 19 has no event data at all
- 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 Excel workbook 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 of the People tab, 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 workbook:
- 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
The zeros are as useful as the counts. A person who never hit "upgrade_clicked" signals the onboarding flow never got them there.
What If the Data Is Not Quite Ready
Event analysis is almost always more nuanced than counting one event.
When you need counts for multiple events
Your head of product wants the funnel — not just "upgrade_clicked" but "onboard_complete" and "first_export" too.
For each person ID in column A of the People tab, 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 each person's last 5 event names and timestamps to spot patterns in what people do before they drop off.
For each person ID in column A of the People tab, pull their GoSquared event feed and write the 5 most recent event names and timestamps into columns B through K — two columns per event (name and timestamp), most recent first.
When some person IDs are not in GoSquared
The 80 IDs came from your app database and some may not be in GoSquared People.
For each person ID in column A of the People tab, 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 summary
Your head of product wants counts, a classification per person, and a brief observation about the overall pattern.
For each person ID in column A of the People tab, 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 after 3 days, 'Non-Converter' if never. 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.
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 Excel workbook. The GoSquared integration is included in every SheetXAI plan. See also how to track GoSquared custom event counts by day in Excel or the GoSquared in Excel overview.