AutomationFlowsData & Sheets › Get Company Data And Store It In Airtable

Get Company Data And Store It In Airtable

Get Company Data And Store It In Airtable. Uses manualTrigger, Brandfetch, airtable. Event-driven trigger; 5 nodes.

Event trigger★★★★☆ complexity5 nodesBrandfetchAirtable
Data & Sheets Trigger: Event Nodes: 5 Complexity: ★★★★☆

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
{
  "nodes": [
    {
      "name": "On clicking 'execute'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        250,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Brandfetch",
      "type": "n8n-nodes-base.Brandfetch",
      "position": [
        450,
        300
      ],
      "parameters": {
        "domain": "n8n.io"
      },
      "credentials": {
        "brandfetchApi": "<your credential>"
      },
      "typeVersion": 1
    },
    {
      "name": "Brandfetch1",
      "type": "n8n-nodes-base.Brandfetch",
      "position": [
        650,
        300
      ],
      "parameters": {
        "domain": "={{$node[\"Brandfetch\"].parameter[\"domain\"]}}",
        "operation": "company"
      },
      "credentials": {
        "brandfetchApi": "<your credential>"
      },
      "typeVersion": 1
    },
    {
      "name": "Set",
      "type": "n8n-nodes-base.set",
      "position": [
        850,
        300
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "Name",
              "value": "={{$node[\"Brandfetch1\"].json[\"name\"]}}"
            },
            {
              "name": "Icon URL",
              "value": "={{$node[\"Brandfetch\"].json[\"icon\"][\"image\"]}}"
            },
            {
              "name": "Logo URL",
              "value": "={{$node[\"Brandfetch\"].json[\"logo\"][\"image\"]}}"
            }
          ]
        },
        "options": {},
        "keepOnlySet": true
      },
      "typeVersion": 1
    },
    {
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1050,
        300
      ],
      "parameters": {
        "table": "Table 1",
        "options": {},
        "operation": "append",
        "application": "app5cseR9ZKgtU3dc"
      },
      "credentials": {
        "airtableApi": "<your credential>"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Set": {
      "main": [
        [
          {
            "node": "Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Brandfetch": {
      "main": [
        [
          {
            "node": "Brandfetch1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Brandfetch1": {
      "main": [
        [
          {
            "node": "Set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On clicking 'execute'": {
      "main": [
        [
          {
            "node": "Brandfetch",
            "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.

About this workflow

Get Company Data And Store It In Airtable. Uses manualTrigger, Brandfetch, airtable. Event-driven trigger; 5 nodes.

Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →