The Scenario
You are an operations manager at a regional real estate brokerage. The managing broker wants to know how the team's showing schedule breaks down by agent and appointment type for the current month. The data lives in Follow Up Boss. There are 80 appointments scheduled this month.
The broker wants the export on her desk by 3 PM Thursday.
The slow version:
- You open Follow Up Boss, navigate to the Appointments section, set the date filter to this month
- The built-in report does not have an "agent" column in the format she wants
- You export the default CSV, open it in Google Sheets
- You manually add a pivot-style count by agent using COUNTIF
- You realize the export grouped some appointment types differently than she expected
- You deliver the sheet at 4:15 PM and spend another 20 minutes explaining why "Buyer Consultation" and "Consultation" are listed as different categories
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI pulls Follow Up Boss appointments directly into the sheet and can add the summary logic in the same prompt.
Open the SheetXAI sidebar and type:
Pull all Follow Up Boss appointments from this month and write appointment title, start time, end time, appointment type, and assigned agent into this sheet starting at row 2. After writing all rows, add a summary table below the data showing appointment count by agent and a second summary table showing appointment count by appointment type.
SheetXAI queries Follow Up Boss, writes the 80 appointments into the sheet, and adds both summary tables. The broker gets a clean export and a ready-made analysis.
What You Get
A structured appointment export with built-in summaries:
- All appointments this month — title, start time, end time, type, assigned agent
- Count by agent — summary table below the data
- Count by appointment type — second summary table
The summaries are generated from the live data, not from a formula you maintain. If an appointment is rescheduled and you re-run the prompt, the counts update automatically.
Want to add invitee emails or property addresses? Add those fields to the prompt and SheetXAI includes them.
What If the Data Is Not Quite Ready
Appointment data from a high-volume team is never perfectly consistent. Appointment type labels drift, agents share accounts, and time zones create off-by-one-hour issues. SheetXAI handles conditioning inline.
When appointment type names are inconsistent
Some agents call it "Buyer Consultation," others say "Consultation," one says "Initial Meeting." You need them normalized for the count to make sense.
Pull all Follow Up Boss appointments from this month. Before writing to the sheet, normalize appointment type to one of these four categories: Buyer Consultation, Listing Appointment, Showing, and Other. Use your best judgment for ambiguous labels. Write the normalized type in column E and the original type in column F. Then add summary counts by normalized type below the data.
When you only need appointments for specific agents
The broker only wants to see the three senior agents' schedules.
Pull all Follow Up Boss appointments from this month that are assigned to agents whose names are listed in the AgentList tab, column A. Write appointment title, start time, end time, type, and agent into this sheet. Add a count-by-agent summary below the data.
When you need to flag double-booked time slots
Two agents sometimes share the same property for overlapping showings. You want to flag those.
Pull all Follow Up Boss appointments from this month and write them into this sheet. In a new column called "Overlap", write "Yes" if two or more appointments for the same agent overlap in time, and "No" otherwise. Sort by agent, then by start time.
When the broker also wants the full contact list for each appointment
Not just appointment metadata but the invitee names and emails for the broker to reference when she follows up.
Pull all Follow Up Boss appointments from this month. For each appointment, also fetch the invitee contact names and emails. Write appointment title, start time, type, agent, and a comma-separated list of invitee emails into this sheet. Add a count-by-type summary below the data.
The pattern: pull, condition, and summarize in one prompt instead of exporting, cleaning, and building summaries separately in two tools.
Try It
Get the 7-day free trial of SheetXAI and open any sheet, then ask it to pull this month's Follow Up Boss appointments. The Follow Up Boss integration is included in every SheetXAI plan. For related workflows, see how to export pipeline deals to a sheet or the Follow Up Boss in Google Sheets overview.