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 →
{
"nodes": [
{
"name": "On clicking 'execute'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
1160,
480
],
"parameters": {},
"typeVersion": 1
},
{
"name": "Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
420
],
"parameters": {
"width": 320,
"height": 200,
"content": "### Very often your data is not in the right format to insert in a node. you can use the set node to fix it.\n\n### Click the `Execute Workflow` button and double click on the nodes to see the input and output items."
},
"typeVersion": 1
},
{
"name": "Create or Update record in Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1920,
480
],
"parameters": {
"range": "A:C",
"options": {},
"sheetId": "13_bAEYNTzVXVY6SfAkBa9ijtJGSxPd8D-hcXXwXtdDo",
"operation": "upsert",
"authentication": "oAuth2"
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
360
],
"parameters": {
"width": 400,
"height": 280,
"content": "\nThis is where we put the data in the format that Google Sheets expect. \nThis means changing the field name from `name` to `Full name`, dropping all fields except `ID`, `Email` and adding a `Created time` field"
},
"typeVersion": 1
},
{
"name": "Set - Prepare fields",
"type": "n8n-nodes-base.set",
"notes": "Prepare fields",
"position": [
1620,
480
],
"parameters": {
"values": {
"number": [
{
"name": "ID",
"value": "={{$json[\"id\"]}}"
}
],
"string": [
{
"name": "Full name",
"value": "={{$json[\"name\"]}}"
},
{
"name": "Email",
"value": "={{$json[\"email\"]}}"
},
{
"name": "Created time",
"value": "={{$now}}"
}
]
},
"options": {},
"keepOnlySet": true
},
"notesInFlow": false,
"typeVersion": 1
},
{
"name": "Customer Datastore - Generate some data",
"type": "n8n-nodes-base.n8nTrainingCustomerDatastore",
"position": [
1340,
480
],
"parameters": {
"operation": "getAllPeople"
},
"typeVersion": 1
}
],
"connections": {
"Set - Prepare fields": {
"main": [
[
{
"node": "Create or Update record in Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"On clicking 'execute'": {
"main": [
[
{
"node": "Customer Datastore - Generate some data",
"type": "main",
"index": 0
}
]
]
},
"Customer Datastore - Generate some data": {
"main": [
[
{
"node": "Set - Prepare fields",
"type": "main",
"index": 0
}
]
]
}
}
}
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
Preparing Data To Be Sent To A Service. Uses manualTrigger, stickyNote, googleSheets, n8nTrainingCustomerDatastore. Event-driven trigger; 6 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →