The Scenario
A recruiter handed you a sheet of 150 open requisition IDs last Tuesday and said: "I need to know which ones have the most applicants so I can prioritize outreach." It's now Thursday. You've been manually looking up each req in SuccessFactors, copying the application count, and pasting it into column B. You're on row 47.
The bad version:
- Open each req in SuccessFactors Recruiting one at a time to see the application count.
- Copy the number, switch back to the sheet, paste it, go back to SuccessFactors for the next one.
- The application count includes withdrawn candidates, which skews the number — you need active applications only, and there's no way to filter that in the UI without clicking into each individual req.
You were told this would take an hour. It's been two days and you have 103 rows left.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your sheet and connects to SAP SuccessFactors. You give it the column with the req IDs and tell it what to write back — it handles the lookups in bulk.
For each job requisition ID in column A of this sheet, fetch the SAP SuccessFactors application count and most recent application date, and write the results into columns B and C
What You Get
- Column B fills with the total application count for each req ID in column A.
- Column C fills with the most recent application date for each req.
- Any req ID that returns no results (cancelled, wrong ID, access error) gets a note in column D so you can review those rows separately.
- The 150-row lookup runs in one pass — not 150 manual clicks.
What If the Data Is Not Quite Ready
You need only active (non-withdrawn) application counts
For each requisition ID in column A, fetch the SAP SuccessFactors count of applications where applicationStatus is not "Withdrawn" and write the active application count into column B and the most recent active application date into column C
You also want a stage breakdown alongside the total count
For each req ID in column A, fetch the SAP SuccessFactors application count by stage and write the total into column B, the count in "Phone Screen" into column C, the count in "Interview" into column D, and the count in "Offer" into column E
Some req IDs in column A have a prefix that needs to be stripped first
For each value in column A, strip the leading "REQ-" prefix to get the numeric ID, then fetch the SAP SuccessFactors application count and most recent application date and write them into columns B and C
Full prioritization dataset in one prompt
For each req ID in column A, fetch the SAP SuccessFactors application count (active only) and most recent application date, write them into columns B and C, then add a column D that scores each req as "High Priority" (fewer than 5 active applications), "Medium" (5-15), or "Low" (more than 15)
The recruiter gets a prioritized list, not a spreadsheet to figure out themselves.
Try It
Drop your list of req IDs into column A of a Google Sheet and get the 7-day free trial of SheetXAI. Ask it to look up application counts from SAP SuccessFactors for each one. 150 lookups, one prompt, a few seconds.