{"product_id":"n8n-workflow-sync-negative-famulor-call-reviews-to-google-sheets","title":"n8n Workflow: Sync Negative Famulor Call Reviews to Google Sheets","description":"\u003ch3\u003eSync negative Famulor call reviews to Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls \u003cstrong\u003ecompleted negative-sentiment calls\u003c\/strong\u003e from the \u003cstrong\u003eFamulor\u003c\/strong\u003e API for the last 48 hours and \u003cstrong\u003eupserts concise review rows\u003c\/strong\u003e into your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e follow-up queue—running hourly or on-demand.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e (or can be manually triggered for testing).\u003c\/li\u003e\n  \u003cli\u003eComputes the call “creation window” using your configured \u003cstrong\u003eBusiness timezone\u003c\/strong\u003e, then converts the boundaries to \u003cstrong\u003eUTC\u003c\/strong\u003e for the Famulor Calls API.\u003c\/li\u003e\n  \u003cli\u003eRequests \u003cstrong\u003ecompleted\u003c\/strong\u003e, \u003cstrong\u003enegative-sentiment\u003c\/strong\u003e calls using the \u003cstrong\u003eFamulor Calls API\u003c\/strong\u003e with pagination.\u003c\/li\u003e\n  \u003cli\u003eValidates paginated results, \u003cstrong\u003ededuplicates by Call ID\u003c\/strong\u003e, and formats each call into a short review row:\n    \u003cul\u003e\n      \u003cli\u003eNo transcripts or recordings\u003c\/li\u003e\n      \u003cli\u003eSummary capped at \u003cstrong\u003e1,500 characters\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eMissing success analysis is explicitly labeled\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf no calls match, it returns a clear \u003cstrong\u003eno-results preview message\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003epreview mode\u003c\/strong\u003e is enabled, it outputs the prepared rows \u003cem\u003ewithout writing\u003c\/em\u003e to Google Sheets; otherwise, it \u003cstrong\u003eupserts\u003c\/strong\u003e rows by \u003cstrong\u003eCall ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep a rolling \u003cstrong\u003enegative feedback backlog\u003c\/strong\u003e for QA and coaching teams in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eReview difficult conversations faster by automatically capturing only the \u003cstrong\u003emost actionable negative calls\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS operations with consistent call sentiment monitoring—without manual exports from Famulor.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFamulor API\u003c\/strong\u003e: uses an HTTP Header Auth credential with \u003cstrong\u003eAuthorization: Bearer {workspace API key}\u003c\/strong\u003e (calls:read access).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling\u003c\/strong\u003e: hourly execution with manual run support.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e (plus a sticky note).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: requires your spreadsheet ID and sheet tab name; upserts based on \u003cstrong\u003eCall ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190247346355,"sku":"N8N-20544","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9Ul3fBkKYBLmCRXt2ZaE8_9Ya6IYUY.png?v=1791451276","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-sync-negative-famulor-call-reviews-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}