Preparing Data To Be Sent To A Service

About This Script

Features:

• Automates workflow tasks
• Ready to import into n8n
• Configurable parameters

{
    "nodes": [
        {
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                1160,
                480
            ],
            "parameters": [],
            "typeVersion": 1,
            "id": "0954c0ee-f370-49ee-914f-0a7ee612a3dc"
        },
        {
            "name": "Note",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                800,
                420
            ],
            "parameters": {
                "width": 320,
                "height": 200,
                "content": "Configuration note: update with your credentials or endpoint.",
                "color": "#FFF59D"
            },
            "typeVersion": 1,
            "id": "5f66866a-d48e-4598-a52d-873c3fadd682"
        },
        {
            "name": "Create or Update record in Google Sheet",
            "type": "n8n-nodes-base.googleSheets",
            "position": [
                1920,
                480
            ],
            "parameters": {
                "range": "A:C",
                "options": [],
                "sheetId": "13_bAEYNTzVXVY6SfAkBa9ijtJGSxPd8D-hcXXwXtdDo",
                "operation": "upsert",
                "authentication": "oAuth2"
            },
            "credentials": {
                "googleSheetsOAuth2Api": {
                    "id": "8",
                    "name": "Sheets"
                }
            },
            "typeVersion": 1,
            "id": "bd9f0ef7-5333-49ae-a105-2653ea415117"
        },
        {
            "name": "Note1",
            "type": "n8n-nodes-base.stickyNote",
            "position": [
                1480,
                360
            ],
            "parameters": {
                "width": 400,
                "height": 280,
                "content": "Configuration note: update with your credentials or endpoint.",
                "color": "#FFF59D"
            },
            "typeVersion": 1,
            "id": "ad516061-f1f6-4fad-ac32-b63bebcb66ad"
        },
        {
            "name": "Set - Prepare fields",
            "type": "n8n-nodes-base.set",
            "notes": "Prepare fields",
            "position": [
                1620,
                480
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "ID",
                            "value": "={{$json[\"id\"]}}"
                        }
                    ],
                    "string": [
                        {
                            "name": "Full name",
                            "value": "={{$json[\"name\"]}}"
                        },
                        {
                            "name": "Email",
                            "value": "={{$json[\"email\"]}}"
                        },
                        {
                            "name": "Created time",
                            "value": "={{$now}}"
                        }
                    ]
                },
                "options": [],
                "keepOnlySet": true
            },
            "notesInFlow": false,
            "typeVersion": 1,
            "id": "e790258e-1e17-43e3-8b67-9af1d2e7885f"
        },
        {
            "name": "Customer Datastore - Generate some data",
            "type": "n8n-nodes-base.n8nTrainingCustomerDatastore",
            "position": [
                1340,
                480
            ],
            "parameters": {
                "operation": "getAllPeople"
            },
            "typeVersion": 1,
            "id": "7c6783cf-8b60-4d21-ac38-e490fa5d51d4"
        }
    ],
    "connections": {
        "Set - Prepare fields": {
            "main": [
                [
                    {
                        "node": "Create or Update record in Google Sheet",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "Customer Datastore - Generate some data",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Customer Datastore - Generate some data": {
            "main": [
                [
                    {
                        "node": "Set - Prepare fields",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements