This workflow follows the Gmail Trigger → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Flujo 5 de Video 7",
"nodes": [
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"simple": false,
"filters": {},
"options": {}
},
"id": "da0a2224-5217-4460-b6e5-1228b13d79c3",
"name": "Gmail Trigger",
"type": "n8n-nodes-base.gmailTrigger",
"typeVersion": 1.1,
"position": [
200,
160
],
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "1T_TXm3Iu4Tp_htLWjpIQT8nN5acF80JzomxO8BxrV68",
"mode": "list",
"cachedResultName": "MiGoogleSheet",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T_TXm3Iu4Tp_htLWjpIQT8nN5acF80JzomxO8BxrV68/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Hoja 1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T_TXm3Iu4Tp_htLWjpIQT8nN5acF80JzomxO8BxrV68/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Fecha": "={{ $json.headers.date }}",
"QuienloEnvia": "={{ $json.headers.from }}",
"Subject": "={{ $json.headers.subject }}"
},
"matchingColumns": [
"Fecha"
],
"schema": [
{
"id": "Fecha",
"displayName": "Fecha",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Subject",
"displayName": "Subject",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "QuienloEnvia",
"displayName": "QuienloEnvia",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
]
},
"options": {}
},
"id": "f9596f9b-6c2f-4318-9982-e6b046e27e3f",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
440,
160
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Gmail Trigger": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "056e1f61-225f-4ac0-812d-f588641e5073",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "SrmRdAL6liDvObge",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
gmailOAuth2googleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Flujo 5 de Video 7. Uses gmailTrigger, googleSheets. Event-driven trigger; 2 nodes.
Source: https://github.com/lawlete/Automatizaciones-con-n8n/blob/03efa6ba64b54961a0e0fc1961229c82c645e995/Flujo_5_de_Video_7.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Add new incoming emails to a Google Sheets spreadsheet as a new row.. Uses gmailTrigger, googleSheets, stickyNote. Event-driven trigger; 4 nodes.
InquiryPilot - Gmail to Sheets and Draft. Uses gmailTrigger, httpRequest, googleSheets, gmail. Event-driven trigger; 4 nodes.
Automação de Email - Gmail para Planilha. Uses gmailTrigger, googleSheets. Event-driven trigger; 2 nodes.
This workflow ingests proof-of-delivery and completion documents from Gmail or a webhook, extracts key fields with an OpenRouter vision model, reconciles them against Google Sheets dispatch data, arch
This workflow automates the processing of credit card statement emails from multiple banks. It extracts important payment details, stores them in Google Sheets, and creates calendar reminders in Googl