n8n - 💡(How to fix) Fix Google Sheets Trigger every minute is not working manual Execute is working sent email

[My workflow 4.json]

https://github.com/user-attachments/files/28372160/My.workflow.4.json { "name": "My workflow 4", "nodes": [ { "parameters": { "pollTimes": { "item": [ { "mode": "everyMinute" }, { "mode": "everyMinute" }, { "mode": "everyMinute" } ] }, "documentId": { "__rl": true, "value": "109ljeIToNyxDDeCD6fLRKZwvr2LFP6m9TpoAKyWabkI", "mode": "list", "cachedResultName": "Support Ticket (Responses)", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/109ljeIToNyxDDeCD6fLRKZwvr2LFP6m9TpoAKyWabkI/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": 1865845473, "mode": "list", "cachedResultName": "Form Responses 1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/109ljeIToNyxDDeCD6fLRKZwvr2LFP6m9TpoAKyWabkI/edit#gid=1865845473" }, "event": "rowAdded", "options": {} }, "type": "n8n-nodes-base.googleSheetsTrigger", "typeVersion": 1, "position": [ -240, -80 ], "id": "5393b8e4-dd2e-4d49-a4e1-3ca8aa377030", "name": "Google Sheets Trigger", "retryOnFail": false, "alwaysOutputData": false, "credentials": { "googleSheetsTriggerOAuth2Api": { "id": "evTbITA39WnQWKWK", "name": "Google Sheets Trigger account" } } }, { "parameters": { "assignments": { "assignments": [ { "id": "03f183e5-4846-41ba-890a-bd1b2669e245", "name": "TicketID", "value": "={{ "TCK-" + $now.toFormat("yyyyLLdd-HHmmss") }}", "type": "string" }, { "id": "f25e18fc-ccf1-4110-b7c4-47417d35b5e0", "name": "Ticket Status", "value": "Open", "type": "string" }, { "id": "0d7fd0c3-fd9e-4a15-9acb-66b21f1741c4", "name": "Created At", "value": "={{$now.toISO()}}", "type": "string" } ] }, "options": {} }, "type": "n8n-nodes-base.set", "typeVersion": 3.4, "position": [ -32, -80 ], "id": "0b6536e9-c8a4-4238-84b5-474f4791ea8e", "name": "Edit Fields" }, { "parameters": { "operation": "update", "documentId": { "__rl": true, "value": "109ljeIToNyxDDeCD6fLRKZwvr2LFP6m9TpoAKyWabkI", "mode": "list", "cachedResultName": "Support Ticket (Responses)", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/109ljeIToNyxDDeCD6fLRKZwvr2LFP6m9TpoAKyWabkI/edit?usp=drivesdk" }, "sheetName": { "__rl": true, "value": 1865845473, "mode": "list", "cachedResultName": "Form Responses 1", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/109ljeIToNyxDDeCD6fLRKZwvr2LFP6m9TpoAKyWabkI/edit#gid=1865845473" }, "columns": { "mappingMode": "defineBelow", "value": { "TicketID": "={{ $json.TicketID }}", "Ticket Status": "={{ $json['Ticket Status'] }}", "Created At": "={{ $json['Created At'] }}", "Timestamp": "={{ $('Google Sheets Trigger').item.json.Timestamp }}" }, "matchingColumns": [ "Timestamp" ], "schema": [ { "id": "Timestamp", "displayName": "Timestamp", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": false }, { "id": "Name", "displayName": "Name", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": true }, { "id": "Ticket Type", "displayName": "Ticket Type", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": true }, { "id": "Location\nEg: Campus Name", "displayName": "Location\nEg: Campus Name", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": true }, { "id": "Message", "displayName": "Message", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": true }, { "id": "Priority", "displayName": "Priority", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true, "removed": true }, { "id": "TicketID", "displayName": "TicketID", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Ticket Status", "displayName": "Ticket Status", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "Created At", "displayName": "Created At", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }, { "id": "row_number", "displayName": "row_number", "required": false, "defaultMatch": false, "display": true, "type": "number", "canBeUsedToMatch": true, "readOnly": true, "removed": true } ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {} }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.7, "position": [ 176, -80 ], "id": "bbfb2423-140d-407e-a2eb-b36d780662ac", "name": "Update row in sheet", "credentials": { "googleSheetsOAuth2Api": { "id": "FOV84ZCV08kpIKTE", "name": "Google Sheets account" } } }, { "parameters": { "sendTo": "={{ $('Google Sheets Trigger').item.json.Email }}", "subject": "={{ $json.TicketID }} - Support Request Recived", "emailType": "text", "message": "=Hello, We received your request. We will get back to you soon. Here is your ticket ID : {{ $json.TicketID }}", "options": {} }, "type": "n8n-nodes-base.gmail", "typeVersion": 2.2, "position": [ 384, -80 ], "id": "62b221db-9b79-4ca5-a3eb-2eeea3e5c195", "name": "Send a message", "webhookId": "a826b64e-976e-467e-87fd-99ac2e782969", "credentials": { "gmailOAuth2": { "id": "X12a0s7b7nRVgNf6", "name": "Gmail account" } } } ], "pinData": {}, "connections": { "Google Sheets Trigger": { "main": [ [ { "node": "Edit Fields", "type": "main", "index": 0 } ] ] }, "Edit Fields": { "main": [ [ { "node": "Update row in sheet", "type": "main", "index": 0 } ] ] }, "Update row in sheet": { "main": [ [ { "node": "Send a message", "type": "main", "index": 0 } ] ] } }, "active": false, "settings": { "executionOrder": "v1", "binaryMode": "separate" }, "versionId": "c2354263-dd75-4496-b4fe-bb7fdbdf8b34", "meta": { "templateCredsSetupCompleted": true, "instanceId": "80310539d5a6b010de7ca1bb760192df7b517726dafcba280fde5b39cb66d875" }, "id": "b6GkVt8DNp0cYSOJ", "tags": [] }

Describe the problem/error/question

Google Sheets Trigger every minute is not working manual Execute is working sent email

What is the error message (if any)?

manuals execute is no problem

Please share your workflow/screenshots/recording

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
⚠️ WARNING ⚠️ If you have sensitive data in your workflow (like API keys), please remove it before sharing.

Share the output returned by the last node

Debug info

core

• n8nVersion: 2.22.0
• platform: docker (self-hosted)
• nodeJsVersion: 24.15.0
• nodeEnv: production
• database: sqlite
• executionMode: regular
• concurrency: -1
• license: community

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 336 hours
• maxCount: 10000 executions

client

• userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/148.0.0.0 safari/537.36 edg/148.0.0.0
• isTouchDevice: false

Generated at: 2026-05-29T00:26:57.508Z