Workflow: Manualtrigger Workflow
Integrations: googleSheets, manualTrigger, n8nTrainingCustomerDatastore, set, stickyNote, stopAndError

{"nodes": [{"name": "On clicking 'execute'", "type": "n8n-nodes-base.manualTrigger", "position": [1160, 480], "parameters": {}, "typeVersion": 1, "id": "8ad37748-4466-404a-bc5d-eeba8ab0228d", "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"name": "Note", "type": "n8n-nodes-base.stickyNote", "position": [800, 420], "parameters": {"width": 320, "height": 200, "content": "### Very often your data is not in the right format to insert in a node. you can use the set node to fix it.\n\n### Click the `Execute Workflow` button and double click on the nodes to see the input and output items."}, "typeVersion": 1, "id": "1466358c-aa92-452a-ae06-59a574d5f111", "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"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": "{{ $credentials.oAuth2 }}"}, "credentials": {"googleSheetsOAuth2Api": {"id": "{{ $credentials.googleSheetsOAuth2Api.id }}", "name": "Sheets"}}, "typeVersion": 1, "id": "bfe3d629-7f0a-482d-bb04-65002a73abbc", "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"name": "Note1", "type": "n8n-nodes-base.stickyNote", "position": [1480, 360], "parameters": {"width": 400, "height": 280, "content": "\nThis is where we put the data in the format that Google Sheets expect. \nThis means changing the field name from `name` to `Full name`, dropping all fields except `ID`, `Email` and adding a `Created time` field"}, "typeVersion": 1, "id": "1f6a1d71-7486-4102-9189-fc9c239178b3", "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"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": "727f904f-c743-40d9-8b12-4c6332e83b35"}, {"name": "Customer Datastore - Generate some data", "type": "n8n-nodes-base.n8nTrainingCustomerDatastore", "position": [1340, 480], "parameters": {"operation": "getAllPeople"}, "typeVersion": 1, "id": "5923c33a-6b40-4b51-b1eb-0aa43d5fcc9c", "notes": "This n8nTrainingCustomerDatastore node performs automated tasks as part of the workflow."}, {"id": "error-0efad909", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "connections": {}, "name": "Manualtrigger Workflow", "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "meta": {"instanceId": "workflow-88bcaf48", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:48.744696", "updatedAt": "2025-09-29T07:07:48.744709", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "description": "Automated workflow: Manualtrigger Workflow. This workflow processes data and performs automated tasks.", "notes": "Excellent quality workflow: Manualtrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}