{"product_id":"n8n-weekly-famulor-inventory-sync-to-google-sheets","title":"n8n Weekly Famulor Inventory Sync to Google Sheets","description":"\u003ch3\u003eKeep your Famulor assistant inventory synced to Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003en8n Weekly Famulor Inventory Sync to Google Sheets\u003c\/strong\u003e is an automation workflow that pulls your Famulor assistants via the Famulor API and keeps a \u003cem\u003enine-column\u003c\/em\u003e inventory updated in Google Sheets. It runs weekly (every Monday at 09:00) or on-demand, and upserts rows matched by \u003cstrong\u003eAssistant ID\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules an inventory sync\u003c\/strong\u003e every Monday at \u003cstrong\u003e09:00\u003c\/strong\u003e (or you can run it manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches assistant records\u003c\/strong\u003e from the \u003cstrong\u003eFamulor API\u003c\/strong\u003e using \u003cstrong\u003epaginated HTTP GET\u003c\/strong\u003e requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates pagination consistency\u003c\/strong\u003e and applies a \u003cstrong\u003e2,000-record safety limit\u003c\/strong\u003e to protect sync runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTransforms results\u003c\/strong\u003e into Google Sheets-ready rows, including a \u003cstrong\u003e“Last seen”\u003c\/strong\u003e timestamp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePreview mode support\u003c\/strong\u003e: if preview mode is enabled, it stops after outputting prepared rows for inspection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLive upsert to Google Sheets\u003c\/strong\u003e: when preview mode is disabled, it checks for existing rows and then \u003cstrong\u003eappends or updates\u003c\/strong\u003e rows using \u003cstrong\u003eAssistant ID\u003c\/strong\u003e as the unique key.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need a reliable, human-readable \u003cstrong\u003eFamulor inventory\u003c\/strong\u003e for weekly reporting.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want an audit-friendly sheet with \u003cstrong\u003eCreated at\u003c\/strong\u003e, \u003cstrong\u003eUpdated at\u003c\/strong\u003e, and \u003cstrong\u003eLast seen\u003c\/strong\u003e fields.\u003c\/li\u003e\n  \u003cli\u003eTeams managing multiple assistants who need lightweight tracking in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e without building a custom dashboard.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow category\u003c\/strong\u003e: n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic used\u003c\/strong\u003e: if, set, code, sticky note, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFamulor API auth\u003c\/strong\u003e: Bearer token using a Famulor workspace API key with \u003cstrong\u003eassistants:read\u003c\/strong\u003e scope\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets headers required\u003c\/strong\u003e: Assistant ID, Name, Active, Mode, Speech language, Tags, Created at, Updated at, Last seen\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223927476403,"sku":"N8N-20931","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/exYVxD6bFriUYRBtsu6pL_jVGE6b50.png?v=1791968782","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-famulor-inventory-sync-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}