This workflow follows the Form Trigger → Google Sheets 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": "Google Sheets Data Entry",
"nodes": [
{
"parameters": {
"formTitle": "Quote Form",
"formDescription": "Get a quote",
"formFields": {
"values": [
{
"fieldLabel": "First Name"
},
{
"fieldLabel": "Last Name"
},
{
"fieldLabel": "Email"
},
{
"fieldLabel": "Phone"
},
{
"fieldLabel": "Budget",
"fieldType": "number"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.2,
"position": [
0,
0
],
"id": "7eb222f0-565d-44ef-8357-72d3c1dd33eb",
"name": "On form submission"
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "1T-OYuge_YUWGv-nY372FP2HpB2jvWLKPdVwUN8c7Jrw",
"mode": "list",
"cachedResultName": "n8n Custom Dashboard",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-OYuge_YUWGv-nY372FP2HpB2jvWLKPdVwUN8c7Jrw/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-OYuge_YUWGv-nY372FP2HpB2jvWLKPdVwUN8c7Jrw/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Email": "={{ $json.Email }}",
"First Name": "={{ $json[\"First Name\"] }}",
"Budget": "={{ $json.Budget }}",
"Phone": "={{ $json.Phone }}",
"Last Name": "={{ $json[\"Last Name\"] }}",
"Date": "={{ $json.submittedAt }}",
"Rejected": "={{ $if($json.Budget >= 1000, \"FALSE\", \"TRUE\") }}",
"Stage": "Lead"
},
"matchingColumns": [
"Email"
],
"schema": [
{
"id": "First Name",
"displayName": "First Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"displayName": "Last Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Phone",
"displayName": "Phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Budget",
"displayName": "Budget",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Rejected",
"displayName": "Rejected",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Email",
"displayName": "Send Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Calendar",
"displayName": "Send Calendar",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Invoice",
"displayName": "Send Invoice",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Pricing",
"displayName": "Send Pricing",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Stage",
"displayName": "Stage",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Package",
"displayName": "Package",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
220,
0
],
"id": "355f9472-b8d7-44d8-87cf-ab05454eab80",
"name": "Google Sheets",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"formTitle": "Sales Call",
"formDescription": "Sales call form",
"formFields": {
"values": [
{
"fieldLabel": "First Name"
},
{
"fieldLabel": "Last Name"
},
{
"fieldLabel": "Email"
},
{
"fieldLabel": "Phone"
},
{
"fieldLabel": "Package"
},
{
"fieldLabel": "Service Date",
"fieldType": "date"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.2,
"position": [
0,
280
],
"id": "36218cf6-0243-436c-83f5-3ee187a29d66",
"name": "On form submission1"
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "1T-OYuge_YUWGv-nY372FP2HpB2jvWLKPdVwUN8c7Jrw",
"mode": "list",
"cachedResultName": "n8n Custom Dashboard",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-OYuge_YUWGv-nY372FP2HpB2jvWLKPdVwUN8c7Jrw/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1T-OYuge_YUWGv-nY372FP2HpB2jvWLKPdVwUN8c7Jrw/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Email": "={{ $json.Email }}",
"First Name": "={{ $json[\"First Name\"] }}",
"Budget": "=",
"Phone": "={{ $json.Phone }}",
"Last Name": "={{ $json[\"Last Name\"] }}",
"Date": "={{ $json.submittedAt }}",
"Rejected": "={{ $if($json.Budget >= 1000, \"FALSE\", \"TRUE\") }}",
"Stage": "Sales Call",
"Package": "={{ $json.Package }}"
},
"matchingColumns": [
"Email"
],
"schema": [
{
"id": "First Name",
"displayName": "First Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"displayName": "Last Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Phone",
"displayName": "Phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Budget",
"displayName": "Budget",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Rejected",
"displayName": "Rejected",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Email",
"displayName": "Send Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Calendar",
"displayName": "Send Calendar",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Invoice",
"displayName": "Send Invoice",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Send Pricing",
"displayName": "Send Pricing",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Stage",
"displayName": "Stage",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Package",
"displayName": "Package",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
220,
280
],
"id": "38264717-2de5-4898-8918-c3d00a2ad0c3",
"name": "Google Sheets1",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"On form submission": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"On form submission1": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "c4fc673d-4343-4f63-a794-c8665543d258",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "flMj5n7nn9jbxiiY",
"tags": []
}
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.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Google Sheets Data Entry. Uses formTrigger, googleSheets. Event-driven trigger; 4 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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.
Waitlist Form Stored In Googlesheet With Email Verification Step. Uses googleSheets, emailSend, form, stickyNote. Event-driven trigger; 19 nodes.
Google Sheets, Email Send, Form +2
CV Tailor Onboarding (easybits). Uses formTrigger, googleSheets, @easybits/n8n-nodes-extractor, form. Event-driven trigger; 19 nodes.
Form Trigger, Google Sheets, @Easybits/N8N Nodes Extractor +1
Form with Dynamic Dropdown Field. Uses n8n, formTrigger, googleSheetsTrigger, executeWorkflow. Event-driven trigger; 16 nodes.
n8n, Form Trigger, Google Sheets Trigger +1
Wait Code. Uses stickyNote, httpRequest, formTrigger, googleSheets. Event-driven trigger; 15 nodes.
HTTP Request, Form Trigger, Google Sheets
JD to Google Sheets Saver. Uses formTrigger, googleSheets. Event-driven trigger; 3 nodes.
Form Trigger, Google Sheets