Create Onfleet Tasks from Local Spreadsheets

This n8n workflow simplifies the process of creating tasks in Onfleet by reading data from a local spreadsheet file. It allows you to quickly populate your Onfleet account with delivery or service tasks based on structured data you provide in a CSV, Excel, or similar spreadsheet format.

What it does

This workflow performs the following steps:

1. Reads a Binary File: It starts by reading a local file in binary format. This is typically your spreadsheet file (e.g., .csv, .xlsx).
2. Converts to Spreadsheet Data: The binary file content is then processed and converted into a structured spreadsheet format, making the data accessible for further operations.
3. Creates Onfleet Tasks: Finally, it takes the data from the spreadsheet and uses it to create new tasks within your Onfleet account.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Onfleet Account: An active Onfleet account with API access.
• Onfleet API Key: Configured as a credential within your n8n instance.
• Local Spreadsheet File: A spreadsheet file (e.g., CSV, Excel) containing the data for your Onfleet tasks. The exact columns required will depend on how you map them in the Onfleet node.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Ensure your Onfleet API Key is set up as an Onfleet credential in n8n.
3. Configure "Read Binary File" Node:
   • Specify the path to your local spreadsheet file.
4. Configure "Spreadsheet File" Node:
   • Ensure the node is correctly configured to parse your specific spreadsheet format (e.g., CSV, Excel).
5. Configure "Onfleet" Node:
   • Select the "Create" operation for tasks.
   • Map the fields from your spreadsheet (e.g., recipient name, address, notes, etc.) to the corresponding fields in the Onfleet task creation form.
6. Execute the Workflow: Once configured, you can manually trigger the workflow to create the Onfleet tasks.