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": "integrating-googlesheet-n8n",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"id": "2057106d-914e-4d6e-834f-e551ab32c215",
"name": "When clicking \u2018Execute workflow\u2019"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1FYvEFIaC813Ty-5_aVI4GuAa3H671OTKJhwX2bCSkHg",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Contacts",
"mode": "name"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
496,
-224
],
"id": "5587b784-8a6b-49b4-9b31-623ebd8a11d4",
"name": "Get row(s) in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1FYvEFIaC813Ty-5_aVI4GuAa3H671OTKJhwX2bCSkHg",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Contacts",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Email": "=teresav@gmail.com",
"Name": "teresa",
"Contact": "0908654",
"Age": "62"
},
"matchingColumns": [],
"schema": [
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Age",
"displayName": "Age",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Contact",
"displayName": "Contact",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
496,
-32
],
"id": "b36d27e1-7b4b-43d8-8dc9-8ebaa57615a6",
"name": "Append row in sheet",
"executeOnce": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "delete",
"documentId": {
"__rl": true,
"value": "1FYvEFIaC813Ty-5_aVI4GuAa3H671OTKJhwX2bCSkHg",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Contacts",
"mode": "name"
},
"startIndex": 10,
"numberToDelete": 50
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
496,
160
],
"id": "95cd3f34-0992-4379-878d-5ff096de942d",
"name": "Delete rows or columns from sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "1FYvEFIaC813Ty-5_aVI4GuAa3H671OTKJhwX2bCSkHg",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Contacts",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Name": "Henry Tan",
"Age": "22",
"Email": "rmanubag308@gmail.com",
"Contact": "090909"
},
"matchingColumns": [
"Name"
],
"schema": [
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Age",
"displayName": "Age",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Contact",
"displayName": "Contact",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
496,
368
],
"id": "0dbf444f-6cf0-47db-84df-77bda90a60a1",
"name": "Append or update row in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
},
{
"node": "Append row in sheet",
"type": "main",
"index": 0
},
{
"node": "Delete rows or columns from sheet",
"type": "main",
"index": 0
},
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[]
]
},
"Delete rows or columns from sheet": {
"main": [
[]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"binaryMode": "separate"
},
"versionId": "56e651c3-db2f-401a-a0a0-1d85ce9a2593",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "JWhPP2QRypKuYDX1",
"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
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
integrating-googlesheet-n8n. Uses googleSheets. Event-driven trigger; 5 nodes.
Source: https://github.com/wayne2604/integrating-googlesheet-n8n/blob/main/integrating-googlesheet-n8n.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.
This n8n workflow pulls campaign data from Google Sheets and creates two pivot tables automatically each time it runs. In n8n, go to Credentials → click New Credential Select Google Sheets OAuth2 API
This n8n workflow automates the collection and processing of trip feedback data using Google Sheets as the backend. When new users are added to the system, they automatically receive feedback forms vi
Stop letting great ideas vanish in your Notes app. This workflow transforms your voice memos into polished blog posts, LinkedIn articles, or newsletters — automatically.
📺 Full walkthrough video: https://youtu.be/uk-mJRgYnfs
An automated workflow that scrapes Shopify store information and product data using the Shopify Scraper API from RapidAPI, triggered by a user submitting a website URL, then logs data into Google Shee