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.