{"product_id":"n8n-teamretro-health-check-to-google-sheets-scores","title":"n8n TeamRetro Health Check to Google Sheets Scores","description":"\u003ch3\u003eAutomatically score TeamRetro Health Checks into Google Sheets—one row per dimension\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures \u003cstrong\u003eTeamRetro “Health Check Completed”\u003c\/strong\u003e events, pulls every dimension’s average score from the TeamRetro API, and \u003cstrong\u003eappends the results to Google Sheets\u003c\/strong\u003e for reporting and dashboards.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a TeamRetro webhook\u003c\/strong\u003e when a health check is completed (via the n8n TeamRetro Trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the TeamRetro API\u003c\/strong\u003e to retrieve all dimension scores for that completed health check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens health check metadata\u003c\/strong\u003e and merges it with each dimension’s average score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates one Google Sheets row per dimension\u003c\/strong\u003e (so teams can track trends across multiple dimensions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows using automatic column mapping\u003c\/strong\u003e to the selected Google Sheets worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a lightweight \u003cstrong\u003eTeamRetro performance dashboard\u003c\/strong\u003e in Google Sheets by tracking dimension scores over time.\u003c\/li\u003e\n  \u003cli\u003eSurface \u003cstrong\u003eteam health trends\u003c\/strong\u003e during retrospectives by reviewing historical dimension scores.\u003c\/li\u003e\n  \u003cli\u003eCentralize health check results for \u003cstrong\u003eSaaS ops reporting\u003c\/strong\u003e without manually exporting data from TeamRetro.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger\/Integration:\u003c\/strong\u003e TeamRetro webhook for the \u003cem\u003eHealth Check Completed\u003c\/em\u003e event using \u003cstrong\u003en8n-nodes-teamretroteam retro trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI access:\u003c\/strong\u003e Retrieves dimension data from the TeamRetro API (includes use of the \u003cstrong\u003ewebhook signing secret\u003c\/strong\u003e and a TeamRetro credential).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData shaping:\u003c\/strong\u003e Uses \u003cstrong\u003ecode\u003c\/strong\u003e and a \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow organization.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage:\u003c\/strong\u003e Appends rows to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via the Google Sheets credential and an \u003cstrong\u003eAppend Rows\u003c\/strong\u003e step.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements (important)\u003c\/h3\u003e\n\u003cp\u003eIn your Google Sheet, ensure row 1 contains headers exactly: \u003cstrong\u003edate\u003c\/strong\u003e, \u003cstrong\u003eteam\u003c\/strong\u003e, \u003cstrong\u003ehealthCheck\u003c\/strong\u003e, \u003cstrong\u003edimension\u003c\/strong\u003e, \u003cstrong\u003escore\u003c\/strong\u003e—so auto-mapping writes each field to the correct column.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814420963507,"sku":"N8N-17999","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xmG1Fe5AkIX_xy3KFg-kp_0vh6NF8J.png?v=1786439546","url":"https:\/\/buyflowscripts.com\/products\/n8n-teamretro-health-check-to-google-sheets-scores","provider":"N8N Commerce","version":"1.0","type":"link"}