Log Willo interview responses to a Google Sheets hiring tracker
Every time a candidate finishes a Willo interview, add one clean row to your Google Sheets hiring tracker. No manual copying, no missed candidates.
Willo
Google SheetsHR & PeopleOperationsData SyncBuild me a code workflow that logs every completed Willo interview response as a new row in a Google Sheets hiring tracker. The pipeline is fully deterministic: fixed trigger, single lookup, single append. No summarization, no branching, no LLM judgement.
Trigger: a Willo webhook subscribed to the new_response event. The webhook payload includes the participant key I need for the lookup.
Step 1: Call Willo Get Participant using the participant key from the webhook payload. From the response, pull these fields: participant key, candidate full name, email, phone, interview title, submitted timestamp, current stage, overall score if present (leave blank if absent), Willo response URL, and transcript URL if available on the plan (leave blank otherwise).
Step 2: Call Google Sheets Append Values against a spreadsheet and tab the user configures at setup. Append one row per response with these fixed columns in this order: Submitted At, Candidate Name, Email, Phone, Interview, Stage, Score, Response URL, Transcript URL. Use USER_ENTERED as the value input option so timestamps and URLs render cleanly.
Inputs the workflow should ask the user for at setup: Willo credential, Google Sheets credential, the spreadsheet ID, and the tab name to append to. Assume the header row already exists in that tab; do not attempt to create or check headers.
Keep it small and readable. One trigger node, one Willo lookup node, one Google Sheets append node. If the participant lookup fails or the append fails, surface the error clearly so recruiting ops can retry. No retries with backoff, no dead-letter logic, just a clean single-shot pipeline.
Additional information
What does this prompt do?
- Listens for every completed Willo interview and adds one row to your hiring tracker spreadsheet the moment it lands.
- Pulls the candidate's key details (name, email, phone, interview title, current stage, score, and links to their response and transcript) so the row is ready for filtering, pivoting, or sharing.
- Gives recruiting ops a durable audit trail that lives outside Willo, easy to hand off to finance, hiring managers, or a weekly review.
- Runs deterministically. No summaries, no AI guesses, no branching, just a clean pipeline from response to spreadsheet row.
What do I need to use this?
- A Willo account with permission to view participants and set up webhooks.
- A Google account with edit access to the spreadsheet you want to log responses in.
- A Google Sheet with a tab set up for the columns you want to track (or use the standard set we suggest below).
How can I customize it?
- Change the columns you log. Drop score, add a hiring manager column, or split the interview title into department and role.
- Point it at a different tab per department, or route different Willo interviews to different spreadsheets.
- Add a second step that pings a Slack channel or emails the hiring manager once the row is written.
Frequently asked questions
How fast does the new row appear after a candidate submits?
What columns get filled in?
Will it work if my Willo plan does not include transcripts?
Can I backfill existing candidates into the sheet?
What happens if I rename the spreadsheet tab later?
Related templates
Stop hand-copying Willo candidates into your hiring tracker.
Connect Willo and Google Sheets once, and every completed interview response lands in your spreadsheet automatically.