The Scenario
Q2 post-mortem time. Your talent analytics lead wants to know which sourcing channels actually converted — not just which ones drove application volume, but which ones produced candidates who reached the offer stage. She's asked you to pull the data into a pivot-ready Google Sheet so she can build the analysis herself.
The data is spread across every application record in Ashby. There is no built-in "sourcing attribution" export.
The bad version:
- Click into job 1 in Ashby. Click through each application. Note the source. Note the current stage. Go to the sheet. Enter the row.
- Click into job 2. Repeat for all 15 open jobs and the half-dozen that closed in Q2.
- Somewhere around application 80 you realize Ashby's display shows "LinkedIn" for both "LinkedIn Recruiter" and "LinkedIn - Organic" as distinct sources, but you've been writing them both as "LinkedIn" in your sheet. The analysis is now inaccurate.
There are hundreds of applications. Each one has a source field that you need to pull consistently. This is not a manual task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It pulls application data from Ashby through a built-in integration and writes it into the sheet in one operation — source labels exactly as Ashby stores them.
Fetch all Ashby applications created in the last 6 months and write candidate name, job title, current stage, application source, and credited user into this sheet for sourcing channel analysis.
SheetXAI queries Ashby applications with the six-month filter, pages through all results, resolves source and stage labels from their IDs, and writes one row per application.
What You Get
- One row per application with candidate name, job title, current stage, application source, and credited recruiter.
- Source labels exactly as Ashby stores them — no collapsing distinct sources into one label.
- The sheet is pivot-ready immediately.
- Your analytics lead can build the channel-to-offer conversion view herself without waiting for another data pull.
What If the Data Is Not Quite Ready
You also want to know whether each application reached the offer stage
Fetch all Ashby applications from the last 6 months. Write candidate name, job title, application source, current stage, and credited recruiter into this sheet. In column F, write "Reached Offer" if the current stage is "Offer" or any downstream stage, otherwise leave blank.
You want to filter to only applications that were sourced by a specific recruiter
Fetch all Ashby applications from the last 6 months where the credited recruiter email is in column A of the "Recruiters" tab. Write candidate name, job title, application source, and current stage into the main sheet.
You want to break down sourcing attribution by quarter
Fetch all Ashby applications created in the last 12 months. Write candidate name, job title, application source, current stage, and application date into this sheet. In column F, label each row as Q1, Q2, Q3, or Q4 based on the application date.
Pull all application data, group by source, and calculate offer conversion rate per channel
Fetch all Ashby applications from the last 6 months. Write candidate name, job title, application source, and current stage into this sheet. Below the data, add a summary table showing each distinct source, total applications from that source, and how many reached the offer stage.
The summary table at the bottom is the whole point. Your analytics lead gets the answer and the raw data in one pull.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull six months of Ashby application data with source attribution so you can build a channel conversion report. See also the spoke on auditing job posting details for compliance, or return to the Ashby overview.