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
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 →