The Scenario
Your VP of business development sent a message at 4pm on a Tuesday: "Can you pull together a chart showing how many new clients we added per month this year? Board deck is Thursday."
You open SuiteDash. There's a Contacts list, sortable by various fields. You can filter by creation date — sort of. Getting a by-month breakdown into a Google Sheet you can actually chart requires more than a filter. It requires the data in a sheet, with a count per month in a summary table.
The bad version:
- Export the contacts list as CSV. Open it in Sheets. Find the "Created Date" column.
- Write a COUNTIFS formula to bucket by month. Realize the date values came over as text strings, not dates.
- Fix the date formatting. Rebuild the formula. Wonder if you missed any contacts who were created under a slightly different label.
- Build the chart. Notice it doesn't match the number your VP mentioned from memory last quarter.
Thursday morning is thirty-six hours away and the deck still needs a slide deck wrapper.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to SuiteDash through its built-in integration, filters contacts by date range, and writes both the detail rows and the summary count into the sheet — formatted for charting.
Open your reporting sheet and type:
List all SuiteDash contacts created in the last 6 months and write name, email, company, role, and created date into this sheet sorted by created date descending
What You Get
- One row per contact created in the specified window
- Columns: name, email, company, role, created date (as a real date value, not a string)
- Sorted most-recent first so you can scan the latest additions immediately
- Ready to pivot or chart without reformatting
What If the Data Is Not Quite Ready
You want a by-month count on a second sheet
List all SuiteDash contacts created this year, write name, email, company, role, and created date into Sheet1, then add a count per month summary table into Sheet2 so I can build a chart
You need the previous year's data for a year-over-year comparison
List all SuiteDash contacts created in 2025, write name, email, company, role, and created date into columns A–E of Sheet1 — then list all contacts created in 2026 year-to-date into Sheet2 with the same columns
You want to see acquisition broken down by the company's assigned territory tag
List all SuiteDash contacts created in the last 6 months and write name, email, company, role, created date, and any company tags into columns A–G — sorted by created date descending
Full kill chain: pull the contacts, add a monthly count, and flag months below target
List all SuiteDash contacts created in 2026. Write name, email, company, role, and created date into columns A–E of Sheet1 sorted by created date descending. On Sheet2, create a monthly summary table with month in column A and contact count in column B. In column C, write "BELOW TARGET" for any month where the count is less than 8, and "ON TRACK" otherwise.
The board deck question — "how many per month and are we trending up?" — answered in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open the reporting sheet you use for executive updates — then ask it to pull your SuiteDash contact acquisition data and summarize it by month. Also see: Export your full client roster and the SuiteDash overview.