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 sheet so she can run the numbers across departments. She sent you the request three days ago via Slack.
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 sheet. 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's 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 Google Sheet. 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.
Fetch all Ashby offers created after the date in cell B1 and write candidate ID, job title, offer status, start date, and the value of the custom field 'Base Salary' into this sheet.
SheetXAI reads the date from B1, queries the Ashby offers endpoint with that filter, resolves the custom field value, and writes one row per offer.
What You Get
- One row per offer, with candidate ID, job title, status, start date, and base salary.
- Custom field values pulled directly from Ashby — no manual click-into-offer required.
- The sheet is ready for pivot tables, pay-band analysis, or department breakdowns.
- If a custom field is missing on some offers, those cells show blank rather than breaking the whole export.
What If the Data Is Not Quite Ready
You also need department alongside job title
Fetch all Ashby offers created after the date in cell B1 and write candidate name, job title, department, offer status, offer date, and the Base Salary custom field into this sheet.
You only want accepted offers
Fetch all Ashby offers with status "Accepted" created in the last 90 days. Write candidate name, job title, department, offer date, and base salary into this sheet.
The comp analyst wants offers filtered to specific departments
Fetch all Ashby offers created in 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 this sheet.
Pull offers, flag missing salary fields, 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 this sheet. In column F, flag any row where Base Salary is blank as "Missing salary." Below the data, add a row showing average Base Salary by department using a formula.
The last prompt saves the comp analyst a step — she gets the data and the first layer of analysis in one pull.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, enter a date in cell B1, and ask it to pull your Ashby offer history into it for analysis. See also the spoke on exporting pipeline data for reporting, or return to the Ashby overview.