The Scenario
You run brand research for a hospitality company. Your manager pinged you Monday asking for a qualitative summary of what real visitors are saying about 30 competitor venues — not star ratings, actual comments. Foursquare has user tips attached to every venue. You have the FSQ IDs in a Google Sheet. The gap is getting those tips into the sheet so the research team can code themes without everyone hunting through the Foursquare UI one venue at a time.
The bad version:
- Open Foursquare for each venue, navigate to the tips section, read through the comments, and manually copy the ones worth capturing into the sheet — 5 tips per venue, 30 venues
- Realize after 10 venues that the tips section layout changed and half of them aren't showing without scrolling, so you're missing content
- Send the partially filled sheet to the research team anyway, knowing it's incomplete, and hope nobody asks how you selected which tips to include
The research team's coding session is scheduled for Wednesday. You don't have until Wednesday to do this by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your FSQ IDs and pulls the Foursquare tips for each venue directly — one tip per row, grouped by venue, no manual navigation required.
For each Foursquare FSQ ID in column A, fetch up to 5 user tips and write them into column B as one tip per cell in consecutive rows, with the FSQ ID repeated in column A for each tip row so each tip row stays linked to its venue
What You Get
- One tip per row in column B, with the source FSQ ID repeated in column A for traceability
- Up to 5 tips per venue, written consecutively so venue groupings stay intact
- Venues that have fewer than 5 tips get however many exist — no blanks padded in to fill the count
- The research team gets a flat, codeable list ready for thematic analysis without any reformatting
What If the Data Is Not Quite Ready
The venue names aren't in the sheet yet — add them alongside the tips so researchers don't have to look up which venue each tip belongs to
For each Foursquare FSQ ID in column A, fetch the venue name and up to 5 user tips. Write the venue name into column B, the FSQ ID into column A, and each tip into column C in separate rows grouped by venue
You only want tips that mention specific themes — filter for tips containing "service" or "wait time" before writing
For each Foursquare FSQ ID in column A, fetch up to 10 user tips and write only the tips that mention "service," "staff," or "wait" into column B, one tip per row, with the FSQ ID in column A
You want the tip text and its creation date side by side for temporal analysis
For each Foursquare FSQ ID in column A, fetch up to 5 user tips and write the tip text into column B and the creation date into column C, one row per tip, grouped by venue
Pull tips, flag the sentiment of each as positive or negative, and sort them so negative tips appear first for priority review
For each Foursquare FSQ ID in column A, fetch up to 5 user tips, write each tip into column B with its FSQ ID in column A, classify the sentiment as Positive or Negative in column C, then sort the rows so Negative tips appear at the top
Running the fetch, the sentiment classification, and the sort in one prompt means the research team opens a ready-to-use sheet, not a raw data dump.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with Foursquare FSQ IDs for competitor venues, then ask it to pull user tips into rows ready for qualitative coding. Also worth reading: Backfill Venue Details From FSQ IDs and the Foursquare hub overview.