{"id":12,"name":"Create Onfleet tasks from Spreadsheets","nodes":[{"id":"trigger-542018d4","name":"Manual Trigger","type":"n8n-nodes-base.manualTrigger","typeVersion":1,"position":[100,100],"parameters":{}},{"name":"Onfleet","type":"n8n-nodes-base.onfleet","position":[900,280],"parameters":{"operation":"create","destination":{"destinationProperties":{"address":"={{$json[\"Address_Line1\"]}}, {{$json[\"Address_Line2\"]}}, {{$json[\"City/Town\"]}} {{$json[\"State/Province\"]}}, {{$json[\"Country\"]}}, {{$json[\"Postal_Code\"]}}","unparsed":true,"addressNotes":"=","addressApartment":"={{$json[\"Address_Line2\"]}}"}},"additionalFields":{"notes":"={{$json[\"Task_Details\"]}}","recipient":{"recipientProperties":{"recipientName":"={{$json[\"Recipient_Name\"]}}","recipientNotes":"={{$json[\"Recipient_Notes\"]}}","recipientPhone":"=+1{{$json[\"Recipient_Phone\"]}}"}}}},"credentials":{"onfleetApi":{"id":"{{ $credentials.onfleetApi.id }}","name":"Onfleet API Key"}},"typeVersion":1,"id":"8d5ecc2f-3011-40ee-a308-596ca39140af","notes":"This onfleet node performs automated tasks as part of the workflow."},{"name":"Read Binary File","type":"n8n-nodes-base.readBinaryFile","position":[500,280],"parameters":{"filePath":"=/Users/jamesli/Downloads/Onfleet Import Google Sheet.xlsx"},"typeVersion":1,"id":"de10e413-1106-495c-ab2d-58d4e7c06b68","notes":"This readBinaryFile node performs automated tasks as part of the workflow."},{"name":"Spreadsheet File1","type":"n8n-nodes-base.spreadsheetFile","position":[700,280],"parameters":{"options":{}},"typeVersion":1,"id":"9a7124e7-0503-423c-b4ce-c03e3063b201","notes":"This spreadsheetFile node performs automated tasks as part of the workflow."},{"id":"error-ba773696","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"connections":{},"description":"Automated workflow: Create Onfleet tasks from Spreadsheets. This workflow processes data and performs automated tasks.","meta":{"instanceId":"workflow-4e6b2510","versionId":"1.0.0","createdAt":"2025-09-29T07:07:51.521718","updatedAt":"2025-09-29T07:07:51.521768","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Create Onfleet tasks from Spreadsheets. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}