Willo to Google Sheets: log every interview response as a new row

PromptCreate

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 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.

FAQs

How fast does the new row appear after a candidate submits?

Within seconds. Willo sends the response event the moment a candidate finishes, and the workflow writes the row on the next step.

What columns get filled in?

By default: submitted time, candidate name, email, phone, interview name, current stage, overall score if present, a link back to the Willo response, and a transcript link. You can trim or add columns to match your existing tracker.

Will it work if my Willo plan does not include transcripts?

Yes. The transcript column simply stays blank for responses where a transcript is not available on your plan.

Can I backfill existing candidates into the sheet?

This workflow only fires on new completed responses going forward. For a one-time backfill, run a separate export from Willo and paste it into the same tab using the same column order.

What happens if I rename the spreadsheet tab later?

The workflow writes to the tab you selected when you set it up. If you rename the tab, update the workflow's tab name so it keeps finding it.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.