n8n recipe · docs

Gmail → Google Sheets

Every new Gmail email becomes a row in Google Sheets — a simple log of what came in.

지메일에 새 메일이 오면 구글 시트에 한 줄씩 적어요.

Steps

  1. When when a new email arrives in gmail — Gmail node
  2. Then add a row to google sheets — Google Sheets node

Fields to fill (3)

The file has every node wired up. These are the blanks only you can fill (your form, your sheet, your words).

NodeWhat to do
Google Sheetsfill documentId (Document)
Google Sheetsfill sheetName (Sheet)
Google Sheetsfill columns (Columns)

Accounts to connect (2)

In n8n, pick or add a credential on each node — one of the types below.

Get the n8n file

Download gmail-to-google-sheets.json

  1. Open a new, empty workflow in n8n.
  2. Open the workflow menu (⋯) and choose Import from File — or copy the JSON below and paste it onto the canvas (Ctrl/Cmd+V).
  3. Connect the accounts, fill the fields above, run one test, then turn the workflow on.
Or copy the JSON 
{
  "name": "Every new Gmail email becomes a row in Google Sheets — a simple log of what came in",
  "nodes": [
    {
      "id": "n1",
      "name": "Gmail Trigger",
      "type": "n8n-nodes-base.gmailTrigger",
      "typeVersion": 1.4,
      "parameters": {
        "event": "messageReceived"
      },
      "position": [
        240,
        300
      ],
      "notes": "step: when a new email arrives in gmail"
    },
    {
      "id": "n2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "parameters": {
        "resource": "sheet",
        "operation": "append",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": []
        }
      },
      "position": [
        460,
        300
      ],
      "notes": "step: add a row to google sheets"
    }
  ],
  "connections": {
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "active": false
}