Библиотека / Синхронизация данных и ETL
Синхронизация данных и ETL
Еженедельная синхронизация инвентаря ассистентов Famulor AI с Google Sheets
Запускается каждый понедельник в 09:00 или по запросу, читает ассистентов через Famulor API и обновляет девять полей инвентаря в Google Sheets по Assistant ID, сохраняя ручные столбцы без изменений.
Что делает
## Who is this for? Operations teams and Famulor workspace administrators who want a weekly overview of their AI assistants in Google Sheets. ## How it works Every Monday at 09:00, or on a manual run, the workflow reads assistants through the Famulor API. It checks pagination and prepares nine inventory fields. Google Sheets appends or updates rows by Assistant ID, preserving unrelated columns such as Owner and Review notes. Preview only starts enabled, so you can inspect the rows before writing. Prompts, tools, recordings and contact details are not copied to the sheet. Deleted assistants remain in the sheet; Last seen helps identify older entries. ## Setup 1. Select an n8n HTTP Header Auth credential in Read Famulor assistant pages. Use Authorization as the header name and Bearer followed by your Famulor workspace API key as its value. The key needs assistants:read. Check the selected credential after import. 2. Create these sheet headers: Assistant ID, Name, Active, Mode, Speech language, Tags, Created at, Updated at, Last seen. Select your Google Sheets credential, spreadsheet and tab. 3. Set your workflow timezone; the default is Europe/Berlin. Run a manual preview, then turn Preview only off and activate the weekly schedule. ## Requirements and customization Uses built-in n8n nodes and Google Sheets edit access. Incomplete, capped or inconsistent scans stop before writes; the default limit is 2,000 assistants. Customize the schedule and mapping. Restrict sheet access and execution-history access: API responses can include configuration fields even though the sheet excludes them. Concurrent sheet writes are not transactional. Famulor setup guide.
Шаги
- Run an inventory preview
- Every Monday at 09:00
- Configure inventory
- Read Famulor assistant pages
- Validate and prepare assistant rows
- Preview only inventory?
- Preview assistant rows
- Has assistant rows?
- Upsert assistant rows
Похожие автоматизации
Синхронизация данных и ETLTech RadarШагов: 37Синхронизация данных и ETLAudit student grades and generate PDF report cards with Google Sheets and SlackШагов: 19Синхронизация данных и ETLСинхронизация событий Google Calendar с таблицей-трекером Google SheetsШагов: 9Синхронизация данных и ETL(G) LineChatBot + Google Sheets (as a memory)Шагов: 9