This workflow follows the Datatable → Gmail 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": "Activity 2 \u2014 Capture Submissions in a Data Table",
"nodes": [
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.6,
"position": [
-608,
144
],
"id": "bfc3397d-8956-4056-a2ad-4e15bdaadc5d",
"name": "On form submission"
},
{
"parameters": {
"sendTo": "angch@tertiaryinfotech.com",
"subject": "New Enquiry",
"message": "=Hi <br> <br>\n\nThere is a new enquiry. Below is the info: <br> <br>\n\nName:{{ $json.Name }} <br>\nEmail:{{ $json.Email }} <br>\nTel:{{ $json.Tel }} <br>\nMessage:{{ $json.Message }} <br>\n\n <br>\nAdmin <br>\nABC Pte Ltd",
"options": {}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
0,
0
],
"id": "c6e05ae6-21ff-4233-bdb1-5dbf55a7e7f1",
"name": "Send a message"
},
{
"parameters": {
"dataTableId": {
"__rl": true,
"value": "CvZ4zZMT30wgDNO0",
"mode": "list",
"cachedResultName": "Event",
"cachedResultUrl": "/projects/koXyebnPoyxlBtCG/datatables/CvZ4zZMT30wgDNO0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Joining": true,
"Name": "={{ $json.Name }}",
"Email": "={{ $json.Email }}",
"Tel": "={{ $json.Tel }}",
"Message": "={{ $json.Message }}"
},
"matchingColumns": [],
"schema": [
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "Tel",
"displayName": "Tel",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"readOnly": false,
"removed": false
},
{
"id": "Joining",
"displayName": "Joining",
"required": false,
"defaultMatch": false,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": false
},
{
"id": "Message",
"displayName": "Message",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.dataTable",
"typeVersion": 1.1,
"position": [
-192,
112
],
"id": "681cf92c-a96d-482f-954b-0354aef6714c",
"name": "Insert row"
}
],
"connections": {
"On form submission": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
},
{
"node": "Insert row",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"binaryMode": "separate"
},
"versionId": "d6f4b577-53d1-4a15-a015-3dab7586a47f",
"nodeGroups": [],
"id": "10fd449977644ab2",
"tags": []
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Activity 2 — Capture Submissions in a Data Table. Uses formTrigger, gmail, dataTable. Event-driven trigger; 3 nodes.
Source: https://github.com/tertiarycourses/TGS-2026062147-No-Code-and-Low-Code-Agentic-AI-Applications/blob/main/labs/activity2-data-table/Activity2-Data-Table.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.
Activity 3a — Conditional Response (Data Table). Uses gmail, dataTable, formTrigger. Event-driven trigger; 6 nodes.
This workflow automates end-to-end contract and invoice management using AI intelligence. It processes proposals through intelligent contract generation, approval workflows, and automated invoicing. O
Automates SaaS operations by consolidating user management, AI-driven support triage, analytics, and billing into one unified system. User signups flow through registration, support requests route via
This workflow automates business intelligence. Submit one URL, and it scrapes the website, uses AI to perform a comprehensive analysis, and generates a professional report in Google Doc and PDF format
Daily Viral Content Radar Pro (AnyAPI). Uses formTrigger, httpRequest, agent, lmChatOpenRouter. Event-driven trigger; 34 nodes.