テンプレートに戻る
ワークフローテンプレート
Google Sheets | Operasyon için n8n Otomasyon İş Akışı Şablonu (Google Sheets, HTTP, Gmail)
n8n için hazır otomasyon şablonu: Google Sheets. 27 düğüm. Entegrasyonlar: Google Sheets, HTTP, Gmail. JSON'u kopyalayıp n8n'e içe aktarın.
27 ノードGoogle_Sheets-workflow.json
{"meta": {"instanceId": "4786bf0f18c0e8e92c361de5a158cabf4eb0bb3b9c113091b054ff26e359a029","templateCredsSetupCompleted": true},"nodes": [{"id": "f7bb1a9e-0f0f-4bec-85d4-539317088cc1","name": "Google Sheets","type": "n8n-nodes-base.googleSheets","position": [2540,1000],"parameters": {},"typeVersion": 4.5},{"id": "d1a262cb-8b55-4bda-96bb-182f459caec6","name": "Remove Duplicates","type": "n8n-nodes-base.removeDuplicates","onError": "continueErrorOutput","position": [1740,-700],"parameters": {},"typeVersion": 1.1,"alwaysOutputData": true},{"id": "c79c8608-92fa-4bd3-b314-917848c61e5e","name": "Remove Duplicates2","type": "n8n-nodes-base.removeDuplicates","onError": "continueErrorOutput","position": [1460,60],"parameters": {},"typeVersion": 1.1},{"id": "36690a7d-e4e7-4667-808d-2837c5f14015","name": "Split Out","type": "n8n-nodes-base.splitOut","onError": "continueRegularOutput","position": [1000,0],"parameters": {},"typeVersion": 1,"alwaysOutputData": true},{"id": "907ab7c1-e4c2-4ba9-9956-c95e3a821fe5","name": "Aggregate","type": "n8n-nodes-base.aggregate","onError": "continueErrorOutput","position": [620,0],"parameters": {},"typeVersion": 1},{"id": "ff9e3e3f-0b39-4743-9e3a-e8d137d5ca23","name": "Loop Over Items","type": "n8n-nodes-base.splitInBatches","onError": "continueRegularOutput","position": [2080,-540],"parameters": {},"typeVersion": 3,"alwaysOutputData": false},{"id": "40b62462-d0de-43fe-8188-2b7738ceff2b","name": "HTTP Request1","type": "n8n-nodes-base.httpRequest","onError": "continueRegularOutput","position": [2560,-460],"parameters": {},"typeVersion": 4.2,"alwaysOutputData": false},{"id": "5950231f-1309-4f6b-967e-d0279109de51","name": "Loop Over Items1","type": "n8n-nodes-base.splitInBatches","onError": "continueRegularOutput","position": [320,0],"parameters": {},"executeOnce": false,"typeVersion": 3,"alwaysOutputData": false},{"id": "2a546eb4-4b59-4195-96e2-b7eba1c3db02","name": "Wait1","type": "n8n-nodes-base.wait","position": [220,-680],"webhookId": "8e37f217-0dfc-4207-8caf-482429db71ee","parameters": {},"typeVersion": 1.1},{"id": "f90cadce-6c39-4c06-a8f2-5f6e9dc9b634","name": "When clicking ‘Test workflow’","type": "n8n-nodes-base.manualTrigger","position": [-1280,-700],"parameters": {},"typeVersion": 1},{"id": "df09b5e3-082b-4bce-8944-08c103b37a87","name": "Loop Over Items4","type": "n8n-nodes-base.splitInBatches","position": [160,880],"parameters": {},"typeVersion": 3},{"id": "5717c401-8c55-4d42-9823-4d0db0f90201","name": "get website with Jina.ai","type": "n8n-nodes-base.httpRequest","onError": "continueRegularOutput","position": [860,900],"parameters": {},"typeVersion": 4.2,"alwaysOutputData": true},{"id": "c73d880c-ab85-435c-8080-a3ad69f1f5f6","name": "If1","type": "n8n-nodes-base.if","position": [1120,920],"parameters": {},"typeVersion": 2.2},{"id": "8c2d984f-7ea0-49e0-83c9-d5a16700a81e","name": "Gmail1","type": "n8n-nodes-base.gmail","position": [2240,1000],"webhookId": "bb60a806-9295-42f0-af17-ee97d0e07d9a","parameters": {},"typeVersion": 2.1},{"id": "a6521c26-1e78-4c3a-a314-4d5ff16519c6","name": "Generate Email content","type": "@n8n/n8n-nodes-langchain.openAi","position": [1740,1000],"parameters": {},"typeVersion": 1},{"id": "1fc096aa-703f-435d-b4df-ef1ae82c37ae","name": "Wait2","type": "n8n-nodes-base.wait","position": [3140,1160],"webhookId": "d5ba06e1-56da-489d-9324-745b8e0b0391","parameters": {},"typeVersion": 1.1},{"id": "d054801e-3d52-4233-a74b-e9ef789ce407","name": "Code6","type": "n8n-nodes-base.code","position": [2860,1020],"parameters": {},"typeVersion": 2},{"id": "07517064-72cf-4e7a-bf42-5a386fb0a913","name": "Sticky Note","type": "n8n-nodes-base.stickyNote","position": [-440,-960],"parameters": {},"typeVersion": 1},{"id": "d1fb586f-f0eb-4dd4-9d9c-0a39444a7502","name": "Sticky Note1","type": "n8n-nodes-base.stickyNote","position": [-460,-60],"parameters": {},"typeVersion": 1},{"id": "308a3e5b-c9f8-4415-9dbf-1c8e3ecc81ef","name": "Sticky Note2","type": "n8n-nodes-base.stickyNote","position": [-460,640],"parameters": {},"typeVersion": 1},{"id": "40bcfb9c-8627-4e4f-a84b-bc425e0915ff","name": "Generate queries","type": "@n8n/n8n-nodes-langchain.openAi","position": [-980,-700],"parameters": {},"executeOnce": false,"typeVersion": 1.4,"alwaysOutputData": true},{"id": "99f29882-f4d4-407c-b89a-9754201b37dc","name": "fomate queries","type": "n8n-nodes-base.code","position": [-580,-700],"parameters": {},"typeVersion": 2,"alwaysOutputData": true},{"id": "3f9f4311-adf5-4487-9f6b-4170b11d7e24","name": "Loop Over queries","type": "n8n-nodes-base.splitInBatches","position": [-60,-700],"parameters": {},"typeVersion": 3},{"id": "f35a8c01-3738-4bc3-9903-6975545253df","name": "Gmail search","type": "n8n-nodes-base.httpRequest","position": [500,-680],"parameters": {},"typeVersion": 4.2},{"id": "4f99d198-6692-423d-a6c7-cdcb85bc5d9f","name": "Extract Urls","type": "n8n-nodes-base.code","position": [860,-680],"parameters": {},"typeVersion": 2},{"id": "49b5d048-ae23-416a-812f-f6f3c5a4e3d5","name": "Filter urls","type": "n8n-nodes-base.filter","onError": "continueRegularOutput","position": [1160,-680],"parameters": {},"typeVersion": 2.2,"alwaysOutputData": false},{"id": "49e6a8a7-12a4-4c97-be90-3ea5eac47438","name": "If url is not empty","type": "n8n-nodes-base.if","position": [1420,-680],"parameters": {},"typeVersion": 2.2},{"id": "7b4b2baf-1375-40a7-bf49-ddbb4a99f413","name": "Extract Domain Name","type": "n8n-nodes-base.code","position": [580,900],"parameters": {},"typeVersion": 2},{"id": "e86ae6c8-0f12-46f0-afd5-08e7de05f7b6","name": "Extract Emails","type": "n8n-nodes-base.code","onError": "continueRegularOutput","position": [480,180],"parameters": {},"typeVersion": 2,"alwaysOutputData": true},{"id": "1c579280-211b-4c8e-b213-8b54e3f43a1d","name": "Limit Markdown","type": "n8n-nodes-base.code","position": [1440,960],"parameters": {},"typeVersion": 2},{"id": "770d1919-68a3-405c-b7cd-faacb15f211e","name": "Sticky Note7","type": "n8n-nodes-base.stickyNote","position": [-1380,-820],"parameters": {},"typeVersion": 1}],"pinData": {"When clicking ‘Test workflow’": [{"query": "TodayInvestment.com"}]},"connections": {"If1": {"main": [[{"node": "Loop Over Items4","type": "main","index": 0}],[{"node": "Limit Markdown","type": "main","index": 0}]]},"Code6": {"main": [[{"node": "Wait2","type": "main","index": 0}]]},"Wait1": {"main": [[{"node": "Gmail search","type": "main","index": 0}]]},"Wait2": {"main": [[{"node": "Loop Over Items4","type": "main","index": 0}]]},"Gmail1": {"main": [[{"node": "Google Sheets","type": "main","index": 0}]]},"Aggregate": {"main": [[{"node": "Split Out","type": "main","index": 0}]]},"Split Out": {"main": [[{"node": "Remove Duplicates2","type": "main","index": 0}]]},"Filter urls": {"main": [[{"node": "If url is not empty","type": "main","index": 0}]]},"Extract Urls": {"main": [[{"node": "Filter urls","type": "main","index": 0}]]},"Gmail search": {"main": [[{"node": "Extract Urls","type": "main","index": 0}]]},"Google Sheets": {"main": [[{"node": "Code6","type": "main","index": 0}]]},"HTTP Request1": {"main": [[{"node": "Loop Over Items","type": "main","index": 0}]]},"Extract Emails": {"main": [[{"node": "Loop Over Items1","type": "main","index": 0}]]},"Limit Markdown": {"main": [[{"node": "Generate Email content","type": "main","index": 0}]]},"fomate queries": {"main": [[{"node": "Loop Over queries","type": "main","index": 0}]]},"Loop Over Items": {"main": [[{"node": "Loop Over Items1","type": "main","index": 0}],[{"node": "HTTP Request1","type": "main","index": 0}]]},"Generate queries": {"main": [[{"node": "fomate queries","type": "main","index": 0}]]},"Loop Over Items1": {"main": [[{"node": "Aggregate","type": "main","index": 0}],[{"node": "Extract Emails","type": "main","index": 0}]]},"Loop Over Items4": {"main": [[{"node": "Loop Over queries","type": "main","index": 0}],[{"node": "Extract Domain Name","type": "main","index": 0}]]},"Loop Over queries": {"main": [[],[{"node": "Wait1","type": "main","index": 0}]]},"Remove Duplicates": {"main": [[{"node": "Loop Over Items","type": "main","index": 0}]]},"Remove Duplicates2": {"main": [[{"node": "Loop Over Items4","type": "main","index": 0}]]},"Extract Domain Name": {"main": [[{"node": "get website with Jina.ai","type": "main","index": 0}]]},"If url is not empty": {"main": [[{"node": "Remove Duplicates","type": "main","index": 0}],[{"node": "Loop Over queries","type": "main","index": 0}]]},"Generate Email content": {"main": [[{"node": "Gmail1","type": "main","index": 0}]]},"get website with Jina.ai": {"main": [[{"node": "If1","type": "main","index": 0}]]},"When clicking ‘Test workflow’": {"main": [[{"node": "Generate queries","type": "main","index": 0}]]}}}
n8n エディター内：Ctrl+V で貼り付け→ワークフローが作成されます