The Scenario
You track 50 SaaS companies as part of your competitive intelligence function. Every quarter you produce a ranking by headcount growth rate — but the data lives in Crustdata, the output goes in Excel, and whoever built the last version of this report left in January. You inherited the worksheet but not the process.
The bad version:
- Open Crustdata, find each of the 50 companies, navigate to the headcount history view, and manually copy quarterly snapshots into the workbook
- Notice halfway through that the date format Crustdata displays is different from what the workbook expects, and spend time reformatting each entry
- By the time you hit company 30, realize you have not been consistent about which quarter you recorded
The resulting table will technically have numbers in it, but the analysis built on top of those numbers will be unreliable.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your company list, calls Crustdata's headcount timeseries endpoint for each company, and places the returned values in a consistent structure across your workbook.
Use Crustdata to fetch quarterly headcount snapshots for each company in column A and build a pivot-ready table in a new worksheet called Headcount Data with columns: Company, Quarter, and Headcount
What You Get
- A Headcount Data worksheet with one row per company-quarter combination
- Columns: Company name, Quarter label (Q1 2024, Q2 2024, etc.), headcount figure from Crustdata
- Structure ready for pivot table analysis without any additional reshaping
- Any company where Crustdata has no timeseries data gets a note row so you know the gap is intentional
What If the Data Is Not Quite Ready
Some companies in the list have been acquired or renamed
For each company in column A, check Crustdata's records and note in column B if the company has been acquired or rebranded, then fetch headcount timeseries only for companies that are still independent and active
The growth rate should be calculated against a specific baseline quarter
Use Crustdata to fetch headcount for each company in column A at Q1 2024 and at Q1 2026 — write both values into columns B and C, then calculate the 2-year growth rate in column D sorted descending
You need the data as a wide table instead of a flat one
For the 50 companies in column A, pull Crustdata headcount at 6-month intervals from January 2023 to January 2026 — write the results as a wide table in the current worksheet with one column per interval, labeled with the date
One prompt to clean the company list, pull the timeseries, and produce a ranked output
Remove any rows where column A is blank or duplicated, then use Crustdata to fetch headcount at Jan 2024, Jul 2024, Jan 2025, and Jul 2025 for each remaining company — write those four values into columns B through E and add a rank column in F ordering companies from highest to lowest growth between Jan 2024 and Jul 2025
Try It
Get the 7-day free trial of SheetXAI and open your competitive intelligence workbook with a list of target companies, then ask it to pull Crustdata headcount timeseries and build the growth-rate table. You can also ask it to overlay funding milestones or job listing counts for the same company set.