{
  "name": "Get started with Google Sheets in n8n",
  "nodes": [
    {
      "id": "b44bc1eb-78dd-4cf0-85d0-564a30b0e24b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -272,
        176
      ],
      "parameters": {
        "width": 600,
        "height": 860,
        "content": "### 0️⃣ Prerequisites\n- **Google Sheets**\n  1. Open **Google Cloud Console** → create / select a project.  \n  2. Enable **Google Sheets API** under *APIs & Services*.  \n  3. Create an OAuth **Desktop*"
      }
    },
    {
      "id": "df6378cb-73bb-437c-a7c6-cfd0f705721b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        176
      ],
      "parameters": {
        "width": 960,
        "height": 860,
        "content": "### 5️⃣ Create a description with GPT-4o  \n1. **`OpenAI Chat Model`** – uses your OpenAI credential.  \n2. **`Write description`** (AI Agent) – prompt = the **Topic**.  \n3. **`Structured Output Parser`"
      }
    },
    {
      "id": "c6b35aa8-5313-4548-af40-e6d66440347e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        176
      ],
      "parameters": {
        "width": 600,
        "height": 860,
        "content": "### 3️⃣ Generate a demo row  \n- **Node:** `Generate 1 Row of Data` (Set node)  \n- Pretends a form was submitted:  \n  - `Name`, `Email`, `Topic`, `Submitted = \"Yes\"`\n\n---\n\n### 4️⃣ Append the new row  \n"
      }
    },
    {
      "id": "b08ad9f7-40cf-4714-ac52-3746eca60b67",
      "name": "OpenAI Chat Model4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1120,
        784
      ]
    },
    {
      "id": "089e86af-2154-4a1c-9c4b-245e66ddb4d5",
      "name": "Structured Output Parser3",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1360,
        832
      ]
    },
    {
      "id": "3be017cc-04e0-4384-868b-e8169c2cd863",
      "name": "Run Workflow",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -208,
        896
      ]
    },
    {
      "id": "1ddd7bc9-6abe-4f2a-9de3-0f88c0109eda",
      "name": "Get Rows from Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        160,
        736
      ]
    },
    {
      "id": "7b4b1b34-0d2a-4081-9cc1-811dedd66b97",
      "name": "Generate 1 Row of Data",
      "type": "n8n-nodes-base.set",
      "position": [
        480,
        864
      ]
    },
    {
      "id": "a9b4a11b-fd45-46bf-b1d0-188954ef9b48",
      "name": "Append Data to google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        848
      ]
    },
    {
      "id": "f08ad7a6-05f9-4035-8c14-3082937a46b4",
      "name": "Write description",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1232,
        608
      ]
    },
    {
      "id": "cef80a95-5ded-4ceb-95e3-21be33725d97",
      "name": "Update Sheets data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1712,
        656
      ]
    },
    {
      "id": "0f505760-f0f1-4519-b0c4-c8269569186b",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        -96
      ],
      "parameters": {
        "width": 504,
        "height": null,
        "content": "## 📬 Need Help or Want to Customize This?\n📧 [robert@ynteractive.com](mailto:robert@ynteractive.com)  \n🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)"
      }
    },
    {
      "id": "8d44204f-e79e-4c75-b125-579c7ae62f81",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        176
      ],
      "parameters": {
        "width": 496,
        "height": 848,
        "content": "## 🎥 Watch This Tutorial\n\n[![Watch the video](https://img.youtube.com/vi/86mJa1aSb3Q/maxresdefault.jpg)](https://www.youtube.com/watch?v=86mJa1aSb3Q)\n\n\n## 🌐 How to Connect Google Cloud to n8n\n\n[![Watc"
      }
    }
  ],
  "connections": {
    "Run Workflow": {
      "main": [
        [
          {
            "node": "Get Rows from Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate 1 Row of Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write description": {
      "main": [
        [
          {
            "node": "Update Sheets data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model4": {
      "ai_languageModel": [
        [
          {
            "node": "Write description",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Generate 1 Row of Data": {
      "main": [
        [
          {
            "node": "Append Data to google",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser3": {
      "ai_outputParser": [
        [
          {
            "node": "Write description",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get Rows from Google Sheets": {
      "main": [
        [
          {
            "node": "Write description",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}