This is a detailed guide that walks you through setting up our n8n template that automatically scans a dartboard for completed tasks, calculates billable hours using AI, and logs the final pay amounts directly into a Google Sheet.
How it works
This automation runs on a schedule (e.g., weekly) to perform the following actions:
Scans Dart: fetches time logs from completed tasks on a specific dartboard
Matches rates: cross-references the assignee’s name in the connected Google Sheet
Calculates pay: uses AI to process time logs and calculate the total payout based on the hourly rate
Updates records: writes the final billable hours and total pay back into your Google Sheet
Prerequisites
Before importing the workflow, ensure you have the following:
A Dart account with an active workspace
An n8n instance (cloud or self-hosted)
A Google Sheet to act as your payroll database
How to setup
Prepare your Google Sheet
Create a new Google Sheet (or a new tab in an existing one) to store your payroll data. The workflow requires specific column headers to map data correctly.
Create the following columns in row 1:
Name(Must exactly match the assignee name in Dart)HourlyRate(The dollar amount per hour, e.g., $40)TotalHours(Leave empty; the automation will fill this)TotalPay(Leave empty; the automation will fill this)DateCalculated(Leave empty; the automation will fill this)Status(Optional: Use this to track if the payment has been made)
Pre-fill the Name and HourlyRate columns for all team members you want to track.
Configure your nodes
Connect Dart
Open the List tasks node
Select Create New Credential and follow the prompt to log in with your Dart account
For Dartboard ID, replace the placeholder ID with the ID of the Dartboard you want to track
Connect Google Sheets
Open the Google Sheets nodes
Select or create your Google Sheets credentials
Spreadsheet ID: Select the sheet you created in Step 1
Ensure the "Range" or "Sheet name" matches your actual file
Connect your AI model
Open the AI/LLM node
Connect your AI model account
You can adjust the "Prompt" system instruction if you need the AI to format the calculation differently.
Test and activate
Click Execute Workflow at the bottom of the n8n canvas to run a test
Check your Google Sheet; you should see the
TotalHoursandTotalPaycolumns populated for any valid tasks foundIf successful, toggle Active in the top right corner
The workflow will now run automatically based on the schedule set in the Schedule Trigger node (default is usually weekly, but you can change this to Daily or Monthly).