n8n TeamRetro Health Check to Google Sheets Scores

Automatically score TeamRetro Health Checks into Google Sheets—one row per dimension

This n8n workflow captures TeamRetro “Health Check Completed” events, pulls every dimension’s average score from the TeamRetro API, and appends the results to Google Sheets for reporting and dashboards.

What this workflow does

• Receives a TeamRetro webhook when a health check is completed (via the n8n TeamRetro Trigger).
• Calls the TeamRetro API to retrieve all dimension scores for that completed health check.
• Flattens health check metadata and merges it with each dimension’s average score.
• Generates one Google Sheets row per dimension (so teams can track trends across multiple dimensions).
• Appends rows using automatic column mapping to the selected Google Sheets worksheet.

Use cases

• Build a lightweight TeamRetro performance dashboard in Google Sheets by tracking dimension scores over time.
• Surface team health trends during retrospectives by reviewing historical dimension scores.
• Centralize health check results for SaaS ops reporting without manually exporting data from TeamRetro.

Technical details

• Trigger/Integration: TeamRetro webhook for the Health Check Completed event using n8n-nodes-teamretroteam retro trigger.
• API access: Retrieves dimension data from the TeamRetro API (includes use of the webhook signing secret and a TeamRetro credential).
• Data shaping: Uses code and a sticky note for workflow organization.
• Storage: Appends rows to Google Sheets via the Google Sheets credential and an Append Rows step.

Setup requirements (important)

In your Google Sheet, ensure row 1 contains headers exactly: date, team, healthCheck, dimension, score—so auto-mapping writes each field to the correct column.