The Scenario
Your compensation analyst has a pay-band review scheduled for next week. She needs six months of Ashby offer data — candidate name, job title, offer status, start date, and the custom salary field — in a single Excel workbook so she can run the numbers. She sent you the request three days ago.
The data is in Ashby. Getting it out manually is the part nobody wants to do.
The bad version:
- Go to Ashby's offers view, filter by the last 6 months, look at the first offer. Note the candidate name, the job title, the offer status, the start date.
- The salary is in a custom field. Click into the offer detail to find it. Write down the number.
- Go to the workbook. Enter the row. Go back to Ashby. Find the next offer.
Ashby made dozens of offers in the last six months. Even at two minutes per offer, that is an hour of data entry — for data that should just come out.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls structured data from Ashby through a built-in integration. Your comp analyst gets her data without you spending the afternoon in the Ashby UI.
Pull all accepted Ashby offers from the last 90 days and write candidate name, job title, department, offer date, and salary into the Excel 'CompensationReview' sheet.
SheetXAI queries the Ashby offers endpoint with the filter, resolves the custom field value, and writes one row per offer into the CompensationReview worksheet.
What You Get
- One row per offer with candidate name, job title, department, offer date, and salary.
- Custom field values pulled directly from Ashby — no manual click-into-offer required.
- The worksheet is ready for pivot tables or pay-band analysis.
- If a salary field is missing on some offers, those cells show blank rather than breaking the export.
What If the Data Is Not Quite Ready
You also need offers with pending status, not just accepted
Fetch all Ashby offers with status "Accepted" or "Pending" created in the last 6 months. Write candidate name, job title, department, offer status, offer date, and base salary into the CompensationReview worksheet.
You only want offers for specific departments
Fetch all accepted Ashby offers from the last 6 months for jobs in the Engineering and Product departments. Write candidate name, job title, offer status, offer date, and base salary into the CompensationReview worksheet.
The comp analyst wants offers and a calculated variance from midpoint
Fetch all accepted Ashby offers from the last 90 days. Write candidate name, job title, department, offer date, and base salary into CompensationReview. In the next column, add a formula comparing base salary to the midpoint value in the PayBands reference table.
Pull all offers, flag missing salary, and calculate average by department
Fetch all Ashby offers from the last 6 months. Write candidate name, job title, department, offer status, and base salary into the CompensationReview worksheet. Flag any row where base salary is blank as "Missing salary" in the next column. Below the data, add a row showing average base salary by department.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull your Ashby offer history into a worksheet for comp analysis. See also the spoke on exporting pipeline data for reporting, or return to the Ashby overview.