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
}
]
]
}
}
}