Queue negative Famulor call reviews to Google Sheets for follow-up
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls app.famulor.io over HTTP.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Configure workflow (Edit Fields (Set)): sets 5 fields: businessTimezone, lookbackHours, previewOnly…
- Build date window (Edit Fields (Set)): sets 2 fields: windowStart, windowEnd
- Read Famulor pages (HTTP Request): calls app.famulor.io (GET)
- Validate and prepare (Code): runs custom JavaScript code
- Has review rows? (If): checks a condition and branches into true / false
- Preview only? (If): checks a condition and branches into true / false
- Preview prepared output (Code): runs custom JavaScript code
- Upsert the review queue (Google Sheets): append or update
Services it uses
HTTP calls to: app.famulor.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow runs hourly (or on manual run) to fetch completed negative-sentiment calls from the Famulor API for the last 48 hours, then upserts a concise review row per call into a Google Sheets follow-up queue. How it works 1. Runs every…