Insert And Update Data In Airtable

About This Script

Features:

• Integrates with Airtable

{
    "nodes": [
        {
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                500,
                350
            ],
            "parameters": [],
            "typeVersion": 1,
            "id": "a6a4cfbf-66fe-4c6b-b4e1-b9b22ddb41d2"
        },
        {
            "name": "Airtable",
            "type": "n8n-nodes-base.airtable",
            "position": [
                900,
                350
            ],
            "parameters": {
                "table": "Table 1",
                "options": [],
                "operation": "append",
                "application": ""
            },
            "credentials": {
                "airtableApi": "Airtable Credentials n8n"
            },
            "typeVersion": 1,
            "id": "ae3996a1-910d-4634-affb-2b0ad8260ad1"
        },
        {
            "name": "Airtable1",
            "type": "n8n-nodes-base.airtable",
            "position": [
                1100,
                350
            ],
            "parameters": {
                "table": "={{$node[\"Airtable\"].parameter[\"table\"]}}",
                "operation": "list",
                "application": "={{$node[\"Airtable\"].parameter[\"application\"]}}",
                "additionalOptions": {
                    "filterByFormula": "Name='n8n'"
                }
            },
            "credentials": {
                "airtableApi": "Airtable Credentials n8n"
            },
            "typeVersion": 1,
            "id": "01c43c4d-d706-4601-bffe-ffd71951727c"
        },
        {
            "name": "Set",
            "type": "n8n-nodes-base.set",
            "position": [
                700,
                350
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "ID",
                            "value": 3
                        }
                    ],
                    "string": [
                        {
                            "name": "Name",
                            "value": "n8n"
                        }
                    ]
                },
                "options": []
            },
            "typeVersion": 1,
            "id": "ebb0a52f-cb3d-439b-b214-900dc6f22ecf"
        },
        {
            "name": "Set1",
            "type": "n8n-nodes-base.set",
            "position": [
                1300,
                350
            ],
            "parameters": {
                "values": {
                    "string": [
                        {
                            "name": "Name",
                            "value": "nodemation"
                        }
                    ]
                },
                "options": [],
                "keepOnlySet": true
            },
            "typeVersion": 1,
            "id": "8c5c4d28-e200-46f0-8d48-52a413f55f3d"
        },
        {
            "name": "Airtable2",
            "type": "n8n-nodes-base.airtable",
            "position": [
                1500,
                350
            ],
            "parameters": {
                "id": "={{$node[\"Airtable1\"].json[\"id\"]}}",
                "table": "={{$node[\"Airtable\"].parameter[\"table\"]}}",
                "options": [],
                "operation": "update",
                "application": "={{$node[\"Airtable\"].parameter[\"application\"]}}"
            },
            "credentials": {
                "airtableApi": "Airtable Credentials n8n"
            },
            "typeVersion": 1,
            "id": "10515412-0c46-437b-8072-846e4feb06e9"
        }
    ],
    "connections": {
        "Set": {
            "main": [
                [
                    {
                        "node": "Airtable",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Set1": {
            "main": [
                [
                    {
                        "node": "Airtable2",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Airtable": {
            "main": [
                [
                    {
                        "node": "Airtable1",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Airtable1": {
            "main": [
                [
                    {
                        "node": "Set1",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "Set",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements