Automate assignee payroll calculations with Dart, Gemini AI, and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs on a schedule (every week at 07:00). Along the way it connects Google Sheets, Google Gemini Chat Model and Dart (community).
How it runs
Trigger: On a schedule (every week at 07:00).
- List tasks (Dart): list tasks
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Assignee & Time Scanner (AI Agent): runs an AI agent, with model: AI SCANNER
- Parse Output (Code): runs custom JavaScript code
- Append row in sheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-dart is verified or supports 3.0 (used in List tasks).
Nodes used (7)
- Dart
n8n-nodes-dart.dart - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Task-based Assignee billing via Time Tracking This workflow automates billing by scanning a target Dartboard on schedule, aggregating time logs from completed tasks, cross‑referencing assignee rates in Google Sheets, calculating total pay, and updating the…