Workflow: automate with n8n workflow for Manual Googlesheets Automate Triggered
Integrations: googleSheets, manualTrigger, set

{"nodes": [{"name": "On clicking 'execute'", "type": "n8n-nodes-base.manualTrigger", "position": [250, 300], "parameters": {}, "typeVersion": 1}, {"name": "Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [650, 300], "parameters": {"range": "A:B", "options": {}, "sheetId": "1ijnLMy6htVTX_68e2lsdGYiA5_6ZG72FXUbxAy_DC94", "operation": "append", "authentication": "oAuth2"}, "credentials": {"googleSheetsOAuth2Api": "Amudhan-GoogleSheets"}, "typeVersion": 1}, {"name": "Set", "type": "n8n-nodes-base.set", "position": [450, 300], "parameters": {"values": {"number": [{"name": "id"}], "string": [{"name": "name", "value": "n8n"}]}, "options": {}}, "typeVersion": 1, "alwaysOutputData": true}, {"name": "Google Sheets1", "type": "n8n-nodes-base.googleSheets", "position": [850, 300], "parameters": {"range": "A:B", "options": {}, "sheetId": "1ijnLMy6htVTX_68e2lsdGYiA5_6ZG72FXUbxAy_DC94", "authentication": "oAuth2"}, "credentials": {"googleSheetsOAuth2Api": "Amudhan-GoogleSheets"}, "typeVersion": 1}], "connections": {"Set": {"main": [[{"node": "Google Sheets", "type": "main", "index": 0}]]}, "Google Sheets": {"main": [[{"node": "Google Sheets1", "type": "main", "index": 0}]]}, "On clicking 'execute'": {"main": [[{"node": "Set", "type": "main", "index": 0}]]}}}