This workflow follows the Gmail → Google Drive 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": "n8n \u5b8c\u8ab2\u8b49\u66f8 + Email \u901a\u77e5",
"nodes": [
{
"parameters": {},
"id": "1df2d618-1c2b-473c-8382-7634582cd07c",
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-2080,
180
]
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 1
},
"conditions": [
{
"id": "0b84f22d-3f97-4db9-b5d3-7fa643896444",
"leftValue": "={{ $json.Status }}",
"rightValue": "Sent",
"operator": {
"type": "string",
"operation": "notEquals"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "8950dd17-ca8b-48fa-b969-7d677dc43c48",
"name": "\u5224\u65b7\uff1a\u5df2\u6709\u6191\u8b49\uff1f",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
-1380,
40
]
},
{
"parameters": {
"operation": "copy",
"fileId": {
"__rl": true,
"value": "https://docs.google.com/presentation/d/1xeP0xbNjhtaFJ1m3O91UtPgc07V5bLNhOAayfYPQnnM",
"mode": "url"
},
"options": {
"name": "={{ $json['Student Name'] }} \u8b49\u66f8 - {{ $now.format('yyyy-MM-dd') }}"
}
},
"id": "ce323cb9-dce2-46c5-9e73-c5ded55f5709",
"name": "Drive \u2013 \u8907\u88fd Slide \u7bc4\u672c",
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 2,
"position": [
-1160,
40
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 1
},
"conditions": [
{
"id": "e2beee46-2c57-4f8b-a9b6-3b5d56cc51e6",
"leftValue": "={{ $json.Status }}",
"rightValue": "Create",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "3c197862-1d46-4ddc-a4d6-cf097edaec63",
"name": "\u5224\u65b7\uff1a\u53ef\u5bc4\u9001\uff1f",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
-500,
120
]
},
{
"parameters": {
"sendTo": "={{ $('Loop Over Items').item.json['Student Email'] }}",
"subject": "={{ $('Loop Over Items').item.json['Student Name'] }} - \u606d\u559c\u4f60\uff01",
"emailType": "text",
"message": "=\u606d\u559c\u4f60\u5b8c\u6210\u5b78\u7a0b\uff01\u63d0\u4f9b\u8b49\u660e\u7d66\u4f60",
"options": {
"appendAttribution": false,
"attachmentsUi": {
"attachmentsBinary": [
{}
]
}
}
},
"id": "5be864aa-b8e3-4814-b140-2d03fa14d6bb",
"name": "Gmail \u2013 \u5bc4\u9001\u6191\u8b49",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
-60,
120
],
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
-1600,
180
],
"id": "1d586073-2e6d-4096-9ea5-fd11fc294102",
"name": "Loop Over Items"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "https://docs.google.com/spreadsheets/d/1TaotKDQygA1O02NkRqVedRUwGFG0lEbxR1sMLPThcFc",
"mode": "url"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "List",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TaotKDQygA1O02NkRqVedRUwGFG0lEbxR1sMLPThcFc/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
-1820,
180
],
"id": "69b57766-4386-41fe-aeb2-9245f9d89480",
"name": "Google Sheets - \u5c1a\u672a\u50b3\u9001",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "replaceText",
"presentationId": "={{ $json.id }}",
"textUi": {
"textValues": [
{
"matchCase": true,
"pageObjectIds": [
"gc6f8f3c68_0_0"
],
"text": "=Student Name",
"replaceText": "={{ $('Loop Over Items').item.json['Student Name'] }}"
},
{
"matchCase": true,
"pageObjectIds": [
"gc6f8f3c68_0_0"
],
"text": "=Title",
"replaceText": "={{ $('Loop Over Items').item.json['Title'] }}"
},
{
"matchCase": true,
"pageObjectIds": [
"gc6f8f3c68_0_0"
],
"text": "Your Name",
"replaceText": "={{ $('Loop Over Items').item.json['Student Name'] }}"
},
{
"matchCase": true,
"pageObjectIds": [
"gc6f8f3c68_0_0"
],
"text": "Company Name",
"replaceText": "={{ $('Loop Over Items').item.json['Company Name'] }}"
},
{
"matchCase": true,
"pageObjectIds": [
"gc6f8f3c68_0_0"
],
"text": "Date",
"replaceText": "=\u65e5\u671f: {{ $('Loop Over Items').item.json['Date'] }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSlides",
"typeVersion": 2,
"position": [
-940,
40
],
"id": "d7d19b79-9c5f-4d48-86f5-490ae5840022",
"name": "Google Slides",
"credentials": {
"googleSlidesOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "https://docs.google.com/spreadsheets/d/1TaotKDQygA1O02NkRqVedRUwGFG0lEbxR1sMLPThcFc",
"mode": "url"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "List",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TaotKDQygA1O02NkRqVedRUwGFG0lEbxR1sMLPThcFc/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Student Email": "={{ $('Loop Over Items').item.json['Student Email'] }}",
"Status": "Create"
},
"matchingColumns": [
"Student Email"
],
"schema": [
{
"id": "Student Name",
"displayName": "Student Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Manager Name",
"displayName": "Manager Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Title",
"displayName": "Title",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Company Name",
"displayName": "Company Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Student Email",
"displayName": "Student Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Student Slide",
"displayName": "Student Slide",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Status",
"displayName": "Status",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
-720,
40
],
"id": "1f79c457-4acc-46ee-bd2e-e475b8bd5ab1",
"name": "Google Sheets - Update Status",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "download",
"fileId": {
"__rl": true,
"value": "={{ $('Drive \u2013 \u8907\u88fd Slide \u7bc4\u672c').item.json.id }}",
"mode": "id"
},
"options": {
"googleFileConversion": {
"conversion": {
"docsToFormat": "application/pdf",
"slidesToFormat": "application/pdf"
}
}
}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
-280,
120
],
"id": "61f5f6a9-f19d-401c-be20-114a054a7a30",
"name": "Google Drive",
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "https://docs.google.com/spreadsheets/d/1TaotKDQygA1O02NkRqVedRUwGFG0lEbxR1sMLPThcFc",
"mode": "url"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "List",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TaotKDQygA1O02NkRqVedRUwGFG0lEbxR1sMLPThcFc/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Student Email": "={{ $('Loop Over Items').item.json['Student Email'] }}",
"Status": "Sent",
"Student Slide": "={{ $('Google Slides').item.json.presentationId }}"
},
"matchingColumns": [
"Student Email"
],
"schema": [
{
"id": "Student Name",
"displayName": "Student Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Manager Name",
"displayName": "Manager Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Title",
"displayName": "Title",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Company Name",
"displayName": "Company Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Student Email",
"displayName": "Student Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Student Slide",
"displayName": "Student Slide",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Status",
"displayName": "Status",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
180,
200
],
"id": "f96e0c71-06a6-4084-bb0c-10421d59c9ad",
"name": "Google Sheets - Update Sent",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## Step-1 \u8b80\u53d6\u5b78\u54e1\u540d\u55ae\uff0c\u624b\u52d5\u6216 8am \u5bc4\u51fa",
"height": 640,
"width": 500,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-2160,
-160
],
"id": "a3875697-09cc-4c2f-8c97-99f213f43054",
"name": "Sticky Note"
},
{
"parameters": {
"content": "## Step-2 \u5ba2\u88fd\u5316\u5b78\u54e1\u8b49\u66f8\uff0c\u4e26\u4fee\u6539\u72c0\u614b\n\u4fee\u6539\u70ba create \u72c0\u614b",
"height": 640,
"width": 1100,
"color": 5
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1660,
-160
],
"id": "be4d7d9a-641d-4c2b-817f-fb1a4847b8aa",
"name": "Sticky Note1"
},
{
"parameters": {
"content": "## Step-3 \u90f5\u4ef6\u5bc4\u9001\u8b49\u66f8\u7d66\u5b78\u54e1\n\u4fee\u6539Sent\u72c0\u614b",
"height": 640,
"width": 880,
"color": 3
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-560,
-160
],
"id": "c9f9967e-e764-49d1-8d5f-6e38faf6bf87",
"name": "Sticky Note2"
},
{
"parameters": {
"content": "# \u8001\u5e2b\u5fc5\u5b78\uff5c\u7528 n8n \u81ea\u52d5\u5316\u5bc4\u767c\u8ab2\u7a0b\u5b8c\u8ab2\u8b49\u660e\n\n## \u554f\u984c\uff1a\n\u5927\u5bb6\u90fd\u77e5\u9053\uff0c\u958b\u5b8c\u8ab2\u3001\u7d50\u675f\u8a13\u7df4\u5f8c\uff0c\u6700\u82b1\u6642\u9593\u7684\u5c31\u662f\u767c\u8b49\u66f8\uff01\n\u5b78\u54e1\u50ac\u4f60\u3001\u4f60\u624b\u5fd9\u8173\u4e82\uff0c\u4e00\u500b\u6c92\u6ce8\u610f\u9084\u6f0f\u5bc4\uff01\n\n\n## \u65b9\u6cd5\n\u73fe\u5728\u7528 n8n\uff0c\u53ea\u8981\u8a2d\u5b9a\u597d\u6d41\u7a0b\uff0c\u5b78\u54e1\u4e00\u5b8c\u8ab2\uff0c\n\u7cfb\u7d71\u81ea\u52d5\u6293\u540d\u55ae\u3001\u586b\u8cc7\u6599\uff0cPDF \u8b49\u66f8\u81ea\u52d5\u751f\u6210\u4e26\u5bc4\u51fa\uff0c\n\u4f60\u9084\u80fd\u81ea\u5df1\u5ba2\u88fd\u5167\u5bb9\u3001\u9644\u52a0\u6210\u7e3e\u6216\u8a55\u8a9e\uff0c\u5168\u90e8\u81ea\u52d5\u5316\u96f6\u51fa\u932f\uff01\n\n## \ud83c\udf93 \u5b78\u7fd2\u8207\u793e\u7fa4\n\n* \ud83d\udd17 [\u52a0\u5165 AI \u5b78\u7fd2\u793e\u7fa4 (Skool)](https://www.skool.com/ai-brain-alex/about?ref=5dde9b20e8e7432aa9a01df6e89685f4)\n* [skool \u8ab2\u7a0b\u6559\u5b78\u9023\u7d50](https://www.skool.com/ai-brain-alex/classroom/4965fcd6?md=ec91451441dd4ec69f7d78318126b926)",
"height": 460,
"width": 1900
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-1960,
-640
],
"id": "c99fc347-ccdd-4dc1-a972-b1dfa99416cf",
"name": "Sticky Note3"
},
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-2080,
0
],
"id": "1da700a8-b67c-4951-948b-1df62af81bbe",
"name": "8am"
}
],
"connections": {
"Manual Trigger": {
"main": [
[
{
"node": "Google Sheets - \u5c1a\u672a\u50b3\u9001",
"type": "main",
"index": 0
}
]
]
},
"\u5224\u65b7\uff1a\u5df2\u6709\u6191\u8b49\uff1f": {
"main": [
[
{
"node": "Drive \u2013 \u8907\u88fd Slide \u7bc4\u672c",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Drive \u2013 \u8907\u88fd Slide \u7bc4\u672c": {
"main": [
[
{
"node": "Google Slides",
"type": "main",
"index": 0
}
]
]
},
"\u5224\u65b7\uff1a\u53ef\u5bc4\u9001\uff1f": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Gmail \u2013 \u5bc4\u9001\u6191\u8b49": {
"main": [
[
{
"node": "Google Sheets - Update Sent",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "\u5224\u65b7\uff1a\u5df2\u6709\u6191\u8b49\uff1f",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - \u5c1a\u672a\u50b3\u9001": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Slides": {
"main": [
[
{
"node": "Google Sheets - Update Status",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Update Status": {
"main": [
[
{
"node": "\u5224\u65b7\uff1a\u53ef\u5bc4\u9001\uff1f",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "Gmail \u2013 \u5bc4\u9001\u6191\u8b49",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Update Sent": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"8am": {
"main": [
[
{
"node": "Google Sheets - \u5c1a\u672a\u50b3\u9001",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1",
"timezone": "Asia/Taipei",
"callerPolicy": "workflowsFromSameOwner"
},
"versionId": "9011f70a-c5b5-4810-bc42-16f593bfa1ac",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "7p8AEJERHekTX20S",
"tags": [
{
"createdAt": "2025-02-08T08:50:12.969Z",
"updatedAt": "2025-02-08T08:50:12.969Z",
"id": "MsjujtEapjDx89km",
"name": "YT"
},
{
"createdAt": "2025-02-10T07:08:57.753Z",
"updatedAt": "2025-02-10T07:08:57.753Z",
"id": "mskXWa7kgjAUGYID",
"name": "ai-brain"
}
]
}
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.
gmailOAuth2googleDriveOAuth2ApigoogleSheetsOAuth2ApigoogleSlidesOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
n8n 完課證書 + Email 通知. Uses googleDrive, gmail, googleSheets, googleSlides. Event-driven trigger; 16 nodes.
Source: https://github.com/qwedsazxc78/ai-automation-n8n/blob/bc074b119e8c8f42b3ceaf6f05d016d893869008/n8n/30-n8n-auto-certificate/n8n_auto_certificate_and_send_email_.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.
AICARE Email Blast System. Uses googleDrive, httpRequest, googleSheets, gmail. Event-driven trigger; 39 nodes.
Google Drive, HTTP Request, Google Sheets +2
Telegram Code. Uses stickyNote, telegramTrigger, telegram, googleDrive. Event-driven trigger; 37 nodes.
Telegram Trigger, Telegram, Google Drive +2
Categories: Payments, Project Operations, Client Onboarding
Stripe Trigger, Google Drive, ClickUp +4
General use cases include: Property managers who manage multiple buildings or units. Building owners looking to centralize tenant repair communication. Automation builders who want to learn multi-trig
Google Sheets, Google Drive, Gmail +1
This workflow automates the full offer letter lifecycle, from generation to final candidate response tracking. When a new row with a Pending status is added to Google Sheets, it creates a personalized
Google Sheets Trigger, Google Drive, Google Docs +2