{"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,"id":"dd536ac6-fa16-4bf8-b07c-06fd82aa94c4","notes":"This manualTrigger node performs automated tasks as part of the workflow."},{"name":"Google Sheets2","type":"n8n-nodes-base.googleSheets","position":[1450,450],"parameters":{"key":"YOUR_CREDENTIAL_HERE","range":"A:D","options":{"valueInputMode":"USER_ENTERED","valueRenderMode":"UNFORMATTED_VALUE"},"sheetId":"1remFwo--5ehUgIU7UUndKldPI0Xm93e1T3DldD9GOg0","operation":"update","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":"google-sheet"},"typeVersion":1,"id":"003db6d4-b010-4ee6-9ba2-f146cd61472e","notes":"This googleSheets node performs automated tasks as part of the workflow."},{"name":"Set1","type":"n8n-nodes-base.set","position":[1250,450],"parameters":{"values":{"number":[{"name":"Rent","value":"={{$node[\"Google Sheets1\"].json[\"Rent\"]+100}}"},{"name":"ID","value":"={{$node[\"Google Sheets1\"].json[\"ID\"]}}"}],"string":[{"name":"Name","value":"={{$node[\"Google Sheets1\"].json[\"Name\"]}}"},{"name":"City","value":"={{$node[\"Google Sheets1\"].json[\"City\"]}}"}]},"options":{},"keepOnlySet":true},"typeVersion":1,"id":"49308656-f6ef-401e-82fa-db4282a14ee0","notes":"This set node performs automated tasks as part of the workflow."},{"name":"Google Sheets1","type":"n8n-nodes-base.googleSheets","position":[1050,450],"parameters":{"range":"A:D","options":{"valueRenderMode":"UNFORMATTED_VALUE","returnAllMatches":true},"sheetId":"1remFwo--5ehUgIU7UUndKldPI0Xm93e1T3DldD9GOg0","operation":"lookup","lookupValue":"Berlin","lookupColumn":"City","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":"google-sheet"},"typeVersion":1,"id":"93828e2d-7bc6-48aa-a35f-6546d39297fe","notes":"This googleSheets node performs automated tasks as part of the workflow."},{"name":"Google Sheets","type":"n8n-nodes-base.googleSheets","position":[850,450],"parameters":{"range":"A:D","options":{"valueInputMode":"USER_ENTERED"},"sheetId":"1remFwo--5ehUgIU7UUndKldPI0Xm93e1T3DldD9GOg0","operation":"append","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":"google-sheet"},"typeVersion":1,"id":"12204ded-3322-47cc-a833-d64ca9295700","notes":"This googleSheets node performs automated tasks as part of the workflow."},{"name":"Google Sheets3","type":"n8n-nodes-base.googleSheets","position":[1650,450],"parameters":{"range":"A:D","options":{"valueRenderMode":"FORMATTED_VALUE"},"sheetId":"1remFwo--5ehUgIU7UUndKldPI0Xm93e1T3DldD9GOg0","authentication":"{{ $credentials.oAuth2 }}"},"credentials":{"googleSheetsOAuth2Api":"google-sheet"},"typeVersion":1,"id":"de55186a-26b1-4643-8033-59be8eda3d0d","notes":"This googleSheets node performs automated tasks as part of the workflow."},{"name":"Set","type":"n8n-nodes-base.set","position":[650,450],"parameters":{"values":{"number":[{"name":"ID","value":"={{Math.floor(Math.random()*1000)}}"}],"string":[{"name":"Name","value":"John's Place"},{"name":"Rent","value":"$1,000"},{"name":"City","value":"Berlin"}]},"options":{},"keepOnlySet":true},"typeVersion":1,"id":"96fccd39-f431-44b7-88e6-41a583b93b52","notes":"This set node performs automated tasks as part of the workflow."},{"id":"error-873da12a","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"connections":{},"description":"Automated workflow: Append, lookup, update, and read data from a Google Sheets spreadsheet. This workflow processes data and performs automated tasks.","meta":{"instanceId":"workflow-44c11ba9","versionId":"1.0.0","createdAt":"2025-09-29T07:07:49.626218","updatedAt":"2025-09-29T07:07:49.626229","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Append, lookup, update, and read data from a Google Sheets spreadsheet. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}