Data Processing & Analysis
Append, lookup, update, and read data from a Google Sheets spreadsheet
Append, lookup, update, and read data from a Google Sheets spreadsheet
Manual
Medium
7
Nodes
Manual
Trigger
Medium
Complexity
7/22/2025
Added
Workflow Overview
Total Nodes
7
Node Types
0
Workflow JSON
5.11 KB
{
"id": "5",
"name": "Append, lookup, update, and read data from a Google Sheets spreadsheet",
"nodes": [
{
"name": "On clicking 'execute'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
450,
450
],
"parameters": {},
"typeVersion": 1
},
{
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1450,
450
],
"parameters": {
"key": "ID",
"range": "A:D",
"options": {
"valueInputMode": "USER_ENTERED",
"valueRenderMode": "UNFORMATTED_VALUE"
},
"sheetId": "1remFwo--5ehUgIU7UUndKldPI0Xm93e1T3DldD9GOg0",
"operation": "update",
"authentication": "oAuth2"
},
"credentials": {
"googleSheetsOAuth2Api": "google-sheet"
},
"typeVersion": 1
},
{
"name": "Set1",
"type": "n8n-nodes-base.set",
"position": [
1250,
4...Showing first 1000 characters. Click "Expand" to view the full JSON.