n8n Workflow

Extract Infromation From A Receipt And Store It In Airtable

This n8n workflow automates tasks using Airtable. Extract Infromation From A Receipt And Store It In Airtable - ready to import and run in your n8n instance.

n8n workflow.json

About This Script

This n8n workflow automates tasks using Airtable. Extract Infromation From A Receipt And Store It In Airtable - ready to import and run in your n8n instance.
Features:
  • Makes HTTP requests to external APIs
  • Integrates with Airtable
Source Code
{
    "nodes": [
        {
            "name": "Get Receipt",
            "type": "n8n-nodes-base.typeformTrigger",
            "position": [
                450,
                300
            ],
            "webhookId": "b51cc683-1ef6-412f-9885-91e65f151cc0",
            "parameters": {
                "formId": ""
            },
            "credentials": {
                "typeformApi": ""
            },
            "typeVersion": 1,
            "id": "a1362bb8-a422-490c-80d1-098c662c88e7"
        },
        {
            "name": "Get Image",
            "type": "n8n-nodes-base.httpRequest",
            "position": [
                650,
                300
            ],
            "parameters": {
                "url": "={{$node[\"Get Receipt\"].json[\"Upload receipt\"]}}",
                "options": [],
                "responseFormat": "file"
            },
            "typeVersion": 1,
            "id": "d95d94f3-e010-4b74-9eb9-24b2b51f7246"
        },
        {
            "name": "Extract Information",
            "type": "n8n-nodes-base.mindee",
            "position": [
                850,
                300
            ],
            "parameters": [],
            "credentials": {
                "mindeeReceiptApi": ""
            },
            "typeVersion": 1,
            "id": "f8304d8d-7e5f-4b52-a007-1feebbdeb9ab"
        },
        {
            "name": "Set Information",
            "type": "n8n-nodes-base.set",
            "position": [
                1050,
                300
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "Amount",
                            "value": "={{$node[\"Extract Information\"].json[\"total\"]}}"
                        }
                    ],
                    "string": [
                        {
                            "name": "Merchant",
                            "value": "={{$node[\"Extract Information\"].json[\"merchant\"]}}"
                        },
                        {
                            "name": "Date",
                            "value": "={{$node[\"Extract Information\"].json[\"date\"]}}"
                        },
                        {
                            "name": "Time",
                            "value": "={{$node[\"Extract Information\"].json[\"time\"]}}"
                        },
                        {
                            "name": "Receipt URL",
                            "value": "={{$node[\"Get Receipt\"].json[\"Upload receipt\"]}}"
                        },
                        {
                            "name": "Category",
                            "value": "={{$node[\"Extract Information\"].json[\"category\"]}}"
                        }
                    ]
                },
                "options": [],
                "keepOnlySet": true
            },
            "typeVersion": 1,
            "id": "5bcf6f99-ecbf-4241-87ed-b5cd353e1df4"
        },
        {
            "name": "Store Information",
            "type": "n8n-nodes-base.airtable",
            "position": [
                1250,
                300
            ],
            "parameters": {
                "table": "Expenses",
                "options": [],
                "operation": "append",
                "application": ""
            },
            "credentials": {
                "airtableApi": ""
            },
            "typeVersion": 1,
            "id": "80a1ae97-4f25-4f5e-935a-2c1f09519bb1"
        }
    ],
    "connections": {
        "Get Image": {
            "main": [
                [
                    {
                        "node": "Extract Information",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Get Receipt": {
            "main": [
                [
                    {
                        "node": "Get Image",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Set Information": {
            "main": [
                [
                    {
                        "node": "Store Information",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Extract Information": {
            "main": [
                [
                    {
                        "node": "Set Information",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}
Requirements
n8n instance, Airtable API credentials
Tags
#n8n #automation #workflow
Quick Actions
More in n8n Workflows