1. Gmail to Google Sheets Logger

    1. Gmail to Google Sheets Logger

    Shared 1/16/2026

    3 views

    Visual Workflow

    JSON Code

    {
      "meta": {
        "instanceId": "91814a43b35a73cdbde395c6c42b41d25ae1ed457b1c2bfba1507016267a33fa",
        "templateCredsSetupCompleted": true
      },
      "nodes": [
        {
          "id": "0ea97e90-457f-44ff-9558-e8e112784491",
          "name": "Gmail Trigger",
          "type": "n8n-nodes-base.gmailTrigger",
          "position": [
            -848,
            -624
          ],
          "parameters": {
            "filters": {
              "q": "cc:marton@flashpointvc.com"
            },
            "pollTimes": {
              "item": [
                {
                  "mode": "everyMinute"
                }
              ]
            }
          },
          "credentials": {
            "gmailOAuth2": {
              "id": "3uB56pP8BC6S72Gx",
              "name": "Gmail account"
            }
          },
          "typeVersion": 1.3
        },
        {
          "id": "e81ec827-3a62-464d-a27e-d627439c634e",
          "name": "Append row in sheet",
          "type": "n8n-nodes-base.googleSheets",
          "position": [
            -464,
            -624
          ],
          "parameters": {
            "columns": {
              "value": {
                "id": "={{ $json.id }}",
                "to": "={{ $json.To }}",
                "from": "={{ $json.From }}",
                "subject": "={{ $json.Subject }}"
              },
              "schema": [
                {
                  "id": "id",
                  "type": "string",
                  "display": true,
                  "removed": false,
                  "required": false,
                  "displayName": "id",
                  "defaultMatch": true,
                  "canBeUsedToMatch": true
                },
                {
                  "id": "subject",
                  "type": "string",
                  "display": true,
                  "removed": false,
                  "required": false,
                  "displayName": "subject",
                  "defaultMatch": false,
                  "canBeUsedToMatch": true
                },
                {
                  "id": "from",
                  "type": "string",
                  "display": true,
                  "removed": false,
                  "required": false,
                  "displayName": "from",
                  "defaultMatch": false,
                  "canBeUsedToMatch": true
                },
                {
                  "id": "to",
                  "type": "string",
                  "display": true,
                  "removed": false,
                  "required": false,
                  "displayName": "to",
                  "defaultMatch": false,
                  "canBeUsedToMatch": true
                }
              ],
              "mappingMode": "defineBelow",
              "matchingColumns": [
                "id"
              ],
              "attemptToConvertTypes": false,
              "convertFieldsToString": false
            },
            "options": {},
            "operation": "append",
            "sheetName": {
              "__rl": true,
              "mode": "list",
              "value": "gid=0",
              "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1l0m3igf3ymqbn9fRylglSC740zNVLfwmR7J4YtEZG9Q/edit#gid=0",
              "cachedResultName": "Sheet1"
            },
            "documentId": {
              "__rl": true,
              "mode": "list",
              "value": "1l0m3igf3ymqbn9fRylglSC740zNVLfwmR7J4YtEZG9Q",
              "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1l0m3igf3ymqbn9fRylglSC740zNVLfwmR7J4YtEZG9Q/edit?usp=drivesdk",
              "cachedResultName": "1. Gmail to Google Sheets Logger"
            }
          },
          "credentials": {
            "googleSheetsOAuth2Api": {
              "id": "ibWtQUZxuo7fFa2a",
              "name": "Google Sheets account"
            }
          },
          "typeVersion": 4.7
        }
      ],
      "pinData": {},
      "connections": {
        "Gmail Trigger": {
          "main": [
            [
              {
                "node": "Append row in sheet",
                "type": "main",
                "index": 0
              }
            ]
          ]
        }
      }
    }