AutomationFlowsData & Sheets › Create a Onfleet Task for a New Added Row in Airtable

Create a Onfleet Task for a New Added Row in Airtable

ByJames Li @ilsemaj on n8n.io

Summary

Event trigger★☆☆☆☆ complexity2 nodesAirtable TriggerOnfleet
Data & Sheets Trigger: Event Nodes: 2 Complexity: ★☆☆☆☆ Added:

This workflow corresponds to n8n.io template #1524 — we link there as the canonical source.

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 →

Download .json
{
  "id": 9,
  "name": "Airtable -> Onfleet",
  "nodes": [
    {
      "name": "Airtable Trigger",
      "type": "n8n-nodes-base.airtableTrigger",
      "position": [
        280,
        600
      ],
      "parameters": {
        "pollTimes": {
          "item": [
            {
              "mode": "everyX",
              "unit": "minutes",
              "value": 10
            }
          ]
        },
        "triggerField": "Address_Line1",
        "additionalFields": {}
      },
      "credentials": {
        "airtableApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "name": "Onfleet",
      "type": "n8n-nodes-base.onfleet",
      "position": [
        500,
        600
      ],
      "parameters": {
        "operation": "create",
        "destination": {
          "destinationProperties": {
            "address": "={{$node[\"Airtable Trigger\"].json[\"fields\"][\"Address_Line1\"]}}, {{$node[\"Airtable Trigger\"].json[\"fields\"][\"City/Town\"]}}, {{$node[\"Airtable Trigger\"].json[\"fields\"][\"State/Province\"]}}, {{$node[\"Airtable Trigger\"].json[\"fields\"][\"Country\"]}}, {{$node[\"Airtable Trigger\"].json[\"fields\"][\"Postal_Code\"]}}",
            "unparsed": true
          }
        },
        "additionalFields": {
          "notes": "={{$node[\"Airtable Trigger\"].json[\"fields\"][\"Task_Details\"][1]}} \n{{$node[\"Airtable Trigger\"].json[\"fields\"][\"Task_Details\"][0]}}",
          "recipient": {
            "recipientProperties": {
              "recipientName": "={{$node[\"Airtable Trigger\"].json[\"fields\"][\"Recipient_Name\"]}}",
              "recipientNotes": "={{$node[\"Airtable Trigger\"].json[\"fields\"][\"Recipient_Notes\"]}}",
              "recipientPhone": "=+1{{$node[\"Airtable Trigger\"].json[\"fields\"][\"Recipient_Phone\"]}}"
            }
          },
          "completeAfter": "= {{$node[\"Airtable Trigger\"].json[\"fields\"][\"completeAfter\"]}}",
          "completeBefore": "= {{$node[\"Airtable Trigger\"].json[\"fields\"][\"completeBefore\"]}}"
        }
      },
      "credentials": {
        "onfleetApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {},
  "connections": {
    "Airtable Trigger": {
      "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.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Summary

Source: https://n8n.io/workflows/1524/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

telli is an innovative platform that provides AI-powered voice agents capable of making calls and performing tasks tailored to specific customer use cases. These AI voice-agents can handle a wide rang

Airtable Trigger, N8N Nodes Telli
Data & Sheets

How it works

Airtable Trigger, Sendinblue, Airtable +1
Data & Sheets

[](https://youtu.be/6QKbzoWMaXE)

Airtable Trigger, Twilio, Airtable
Data & Sheets

Export N8N Cloud Execution Data To Csv. Uses manualTrigger, n8n, convertToFile, stickyNote. Event-driven trigger; 7 nodes.

n8n
Data & Sheets

This template helps n8n cloud plan users execute all executions to a CSV for easy data analysis. Identify what workflows are generating the most executions or could be optimized. Click "Test Workflow"

n8n