The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": 12,
"name": "Create Onfleet tasks from Spreadsheets",
"nodes": [
{
"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": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "Read Binary File",
"type": "n8n-nodes-base.readBinaryFile",
"position": [
500,
280
],
"parameters": {
"filePath": "=/Users/jamesli/Downloads/Onfleet Import Google Sheet.xlsx"
},
"typeVersion": 1
},
{
"name": "Spreadsheet File1",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
700,
280
],
"parameters": {
"options": {}
},
"typeVersion": 1
}
],
"active": false,
"settings": {},
"connections": {
"Read Binary File": {
"main": [
[
{
"node": "Spreadsheet File1",
"type": "main",
"index": 0
}
]
]
},
"Spreadsheet File1": {
"main": [
[
{
"node": "Onfleet",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
onfleetApi
About this workflow
Create Onfleet tasks from Spreadsheets. Uses onfleet, readBinaryFile, spreadsheetFile. Manual trigger; 3 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →