AutomationFlowsData & Sheets › Convert Image Urls To An Uploaded Attachment In Airtable

Convert Image Urls To An Uploaded Attachment In Airtable

Convert Image Urls To An Uploaded Attachment In Airtable. Uses manualTrigger, airtable, stickyNote. Event-driven trigger; 4 nodes.

Event trigger★★☆☆☆ complexity4 nodesAirtable
Data & Sheets Trigger: Event Nodes: 4 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": [
    {
      "id": "b58964ca-d7a9-435d-a7cc-b09cac5c0a30",
      "name": "When clicking \"Execute Workflow\"",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        1000,
        720
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "08dcd330-232d-48bf-b3fc-275513be9c62",
      "name": "Get all records with an image URL",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1200,
        720
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "app5TBVbHPs64w5lE",
          "cachedResultUrl": "https://airtable.com/app5TBVbHPs64w5lE",
          "cachedResultName": "N8N Image Automation"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblTVTofgqfzqyIZk",
          "cachedResultUrl": "https://airtable.com/app5TBVbHPs64w5lE/tblTVTofgqfzqyIZk",
          "cachedResultName": "Frogs"
        },
        "options": {},
        "operation": "search",
        "filterByFormula": "=NOT({Image source URL} = '')"
      },
      "typeVersion": 2
    },
    {
      "id": "331b2a4f-2168-443e-9827-f4967587d643",
      "name": "Update attachment field with images",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1400,
        720
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "app5TBVbHPs64w5lE",
          "cachedResultUrl": "https://airtable.com/app5TBVbHPs64w5lE",
          "cachedResultName": "N8N Image Automation"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblTVTofgqfzqyIZk",
          "cachedResultUrl": "https://airtable.com/app5TBVbHPs64w5lE/tblTVTofgqfzqyIZk",
          "cachedResultName": "Frogs"
        },
        "columns": {
          "value": {
            "id": "={{ $json.id }}",
            "Image attachment": "={\n\"Attachment\": {\n\"url\": \"{{ $json[\"Image source URL\"] }}\"\n}\n}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "id",
              "defaultMatch": true
            },
            {
              "id": "Image source URL",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Image source URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Image attachment",
              "type": "object",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Image attachment",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ]
        },
        "options": {},
        "operation": "update"
      },
      "typeVersion": 2
    },
    {
      "id": "d2be8b46-c845-4ebf-adfc-2ca2eee9ee46",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        460
      ],
      "parameters": {
        "width": 476,
        "height": 849,
        "content": "## Read me\nSuper simple workflow to upload image URLs as attachments in Airtable. [Here's the example Airtable database I used for this workflow.](https://airtable.com/app5TBVbHPs64w5lE/shrcqQJEC56DV3I9b/tblTVTofgqfzqyIZk)\n\n1. Set up your Airtable database with one text field which contains image URLs, and an attachment field. \n![Source example](https://i.imgur.com/IVIPQoo.png/<IMAGE-NAME>.png#full-width)\n\n2. In each Airtable node, add your Airtable credentials and connect to the base and table you want to modify.\n\n3. In the \"Get all records with an image URL\" node under \"Filter by Formula\", change the field name from \"Image Source URL\" to whatever your URL field name is.\n![Source example](https://i.imgur.com/32Z7DqX.png/<IMAGE-NAME>.png)\n\n4. In the third node \"Update attachment field with images\", update the expression with the correct field name for the URL field. \n![Source example](https://i.imgur.com/hUeZgxX.png/<IMAGE-NAME>.png)\n\n5. Click \"Execute Workflow\" and watch the magic happen!\n\n"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "When clicking \"Execute Workflow\"": {
      "main": [
        [
          {
            "node": "Get all records with an image URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get all records with an image URL": {
      "main": [
        [
          {
            "node": "Update attachment field with images",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

About this workflow

Convert Image Urls To An Uploaded Attachment In Airtable. Uses manualTrigger, airtable, stickyNote. Event-driven trigger; 4 nodes.

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

More Data & Sheets workflows → · Browse all categories →