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.
Integrations
Willo
Google Sheets
Type
Categories
- HR & People
- Operations
Build 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.
What it does
- 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 you’ll need
- 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 to 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.
Use cases
- Data Sync
