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": [
{
"id": "678e86bc-2755-4c79-97d6-fa4da1ed9ff9",
"name": "Postgres Trigger",
"type": "n8n-nodes-base.postgresTrigger",
"disabled": true,
"position": [
500,
480
],
"parameters": {
"schema": {
"__rl": true,
"mode": "list",
"value": "computed",
"cachedResultName": "computed"
},
"firesOn": "UPDATE",
"tableName": {
"__rl": true,
"mode": "list",
"value": "users",
"cachedResultName": "users"
},
"additionalFields": {}
},
"credentials": {
"postgres": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "accecdfc-283c-4119-9b23-4cf44bc5e68c",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"notes": "Filter out @n8n.io emails",
"position": [
980,
540
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.email }}",
"value2": "n8n.io",
"operation": "notContains"
}
]
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "d16d7ae7-0c60-48f0-97fe-c7618cab73d3",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
380
],
"parameters": {
"width": 424,
"height": 559,
"content": "## \ud83d\udc4b \uc774 \ud15c\ud50c\ub9bf\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\n\uc774 \ud15c\ud50c\ub9bf\uc740 \ud558\ub098\uc758 \uc11c\ube44\uc2a4\uc5d0\uc11c \ub2e4\ub978 \uc11c\ube44\uc2a4\ub85c \ub370\uc774\ud130\ub97c \ub3d9\uae30\ud654\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc774 \uc608\uc81c\uc5d0\uc11c \uc6b0\ub9ac\ub294 \uc0c8\ub85c\uc6b4 \uc790\uaca9\uc744 \uac16\ucd98 \ub9ac\ub4dc\ub97c Google Sheets \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4. \ud15c\ud50c\ub9bf\uc744 \ud14c\uc2a4\ud2b8\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:\n\n1. \uc6b0\ub9ac\uc758 [Google Sheets](https://docs.google.com/spreadsheets/d/1gVfyernVtgYXD-oPboxOSJYQ-HEfAguEryZ7gTtK0V8/edit?usp=sharing) \ud30c\uc77c\uc744 \ubcf5\uc81c\ud558\uc138\uc694.\n2. `Google Sheets` \ub178\ub4dc\ub97c \ub354\ube14 \ud074\ub9ad\ud558\uc5ec \ub85c\uadf8\uc778\ud558\uc5ec \uc790\uaca9 \uc99d\uba85\uc744 \uc0dd\uc131\ud558\uc138\uc694.\n3. \uc62c\ubc14\ub978 Google Sheets \ubb38\uc11c\uc640 \uc2dc\ud2b8\ub97c \uc120\ud0dd\ud558\uc138\uc694.\n4. `Execute Workflow` \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uace0 \ub178\ub4dc\ub97c \ub354\ube14 \ud074\ub9ad\ud558\uc5ec \uc785\ub825 \ubc0f \ucd9c\ub825 \ub370\uc774\ud130\ub97c \ubcf4\uc138\uc694.\n\n### \uc774\ub97c \uadc0\ud558\uc758 \ud544\uc694\uc5d0 \ub9de\uac8c \uc0ac\uc6a9\uc790 \uc815\uc758\ud558\ub824\uba74 \ub2e4\uc74c\uc744 \ud558\uc138\uc694:\n1. `Postgres trigger`\ub97c \ud65c\uc131\ud654\ud558\uac70\ub098 \uadc0\ud558\uc758 \uc6a9\ub3c4\uc5d0 \ub9de\ub294 \uc11c\ube44\uc2a4\ub85c \uad50\uccb4\ud558\uc138\uc694.\n2. `Filter`\ub97c \uadc0\ud558\uc758 \ud544\uc694\uc5d0 \ub9de\uac8c \ubcc0\uacbd\ud558\uc138\uc694.\n3. \uc704\uc5d0\uc11c \uc124\uba85\ud55c \ub300\ub85c Google Sheets \ub178\ub4dc\ub97c \uc870\uc815\ud558\uc138\uc694.\n4. `On clicking \"Execute Node\"` \ubc0f `Code` \ub178\ub4dc\ub97c \ube44\ud65c\uc131\ud654\ud558\uac70\ub098 \uc81c\uac70\ud558\uc138\uc694."
},
"typeVersion": 1
},
{
"id": "8bc7439e-d814-4960-8b75-fc77805f74c7",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
380
],
"parameters": {
"width": 344,
"height": 562,
"content": "1. \ud2b8\ub9ac\uac70 \ub2e8\uacc4\ub294 \uc0c8\ub85c\uc6b4 \uc774\ubca4\ud2b8\ub97c \uae30\ub2e4\ub9bd\ub2c8\ub2e4."
},
"typeVersion": 1
},
{
"id": "63b2bc4c-8e33-4432-af4b-4595b2012ce1",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
460
],
"parameters": {
"width": 462,
"height": 407,
"content": "### 2. \ub370\uc774\ud130 \ud544\ud130\ub9c1 \ubc0f \ubcc0\ud658\n\n\uc774 \uacbd\uc6b0, \uc774\uba54\uc77c \uc8fc\uc18c\uc5d0 `@n8n.io`\uac00 \uc5c6\ub294 \uc801\uaca9\ud55c \uc0ac\uc6a9\uc790\ub9cc \uc800\uc7a5\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4.\n\n\ud544\ud130\ub97c \ud3b8\uc9d1\ud558\ub824\uba74, \uc785\ub825 \ub370\uc774\ud130\ub97c \ud544\ub4dc\ub85c \uac04\ub2e8\ud788 \ub4dc\ub798\uadf8 \uc564 \ub4dc\ub86d\ud558\uac70\ub098 \uac12\uc744 \uc9c1\uc811 \ubcc0\uacbd\ud558\uc138\uc694. **\ud544\ud130 \uc678\uc5d0\ub3c4, n8n\uc5d0\ub294 [Set](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.set/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.set), [ItemList](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.itemlists/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.itemLists), [Code](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.code/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.code) \uac19\uc740 \ub2e4\ub978 \uac15\ub825\ud55c \ubcc0\ud658 \ub178\ub4dc\uac00 \ub354 \uc788\uc2b5\ub2c8\ub2e4.**"
},
"typeVersion": 1
},
{
"id": "448e2c49-aa75-405b-ba51-3acbce0fb758",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
460
],
"parameters": {
"width": 342.52886836027733,
"height": 407.43618112665195,
"content": "### 3. \uc0ac\uc6a9\uc790\ub97c Google \uc2dc\ud2b8\uc5d0 \uc800\uc7a5\n\n\uac04\ub2e8\ud558\uac8c \ud558\uae30 \uc704\ud574, \uc790\uaca9\uc744 \uac16\ucd98 \uc0ac\uc6a9\uc790\ub97c Google \uc2dc\ud2b8\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.\n\n** [Excel](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.microsoftexcel/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.microsoftExcel) , [HubSpot](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.hubspot/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.hubspot) , [Pipedrive](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.pipedrive/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.pipedrive) , [Zendesk](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.zendesk/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.zendesk) \ub4f1\uacfc \uac19\uc740 \uc11c\ube44\uc2a4\ub85c \uc774 \ub178\ub4dc\ub97c \ub300\uccb4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. **"
},
"typeVersion": 1
},
{
"id": "c0ee182d-4c31-488b-a547-5f2d2ba8786e",
"name": "On clicking \"Execute Node\"",
"type": "n8n-nodes-base.manualTrigger",
"notes": "For testing the workflow",
"position": [
500,
680
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "87f2a11e-f704-4c9e-ac8b-ee1f057cd347",
"name": "Code",
"type": "n8n-nodes-base.code",
"notes": "Mock Data",
"position": [
680,
680
],
"parameters": {
"jsCode": "return [\n {\n \"id\": 1,\n \"username\": \"max_mustermann\",\n \"email\": \"max_mustermann@acme.com\",\n \"company_size\": \"500-999\",\n \"role\": \"Sales\",\n \"users\": 50\n }\n]"
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "0992077f-b6d3-47d2-94d2-c612dfbf5062",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "Add to \"Users to contact\"",
"position": [
1400,
540
],
"parameters": {
"columns": {
"value": {
"id": "={{ $json.id }}",
"email": "={{ $json.email }}",
"username": "={{ $json.username }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "username",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacted",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacted",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
]
},
"options": {
"cellFormat": "USER_ENTERED"
},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gVfyernVtgYXD-oPboxOSJYQ-HEfAguEryZ7gTtK0V8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1gVfyernVtgYXD-oPboxOSJYQ-HEfAguEryZ7gTtK0V8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gVfyernVtgYXD-oPboxOSJYQ-HEfAguEryZ7gTtK0V8/edit?usp=drivesdk",
"cachedResultName": "Qualified leads to contact"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 4
}
],
"connections": {
"Code": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Postgres Trigger": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"On clicking \"Execute Node\"": {
"main": [
[
{
"node": "Code",
"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.
googleSheetsOAuth2Apipostgres
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Workflow 1930. Uses postgresTrigger, googleSheets. Event-driven trigger; 9 nodes.
Source: https://github.com/n8nKOR/n8n-shared-workflow/blob/62a671327e906c22a40d290b339ff6d2373f8d75/workflows/n8n-workflows-by-Zie619/devops/1930_workflow_1930.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.
Code Postgres. Uses postgresTrigger, stickyNote, manualTrigger, googleSheets. Event-driven trigger; 9 nodes.
Postgres Trigger, Google Sheets
1930. Uses postgresTrigger, googleSheets. Event-driven trigger; 9 nodes.
Postgres Trigger, Google Sheets
This template shows how to sync data from one service to another. Specifically, in this example we're saving a new qualified lead from a Postgres database to a Google Sheets file.
Postgres Trigger, Google Sheets
This workflow automatically detects completed orders in PostgreSQL and prepares them for AI-based post-purchase communication. It enriches each order with customer, product, and payment data, then gen
Postgres Trigger, Postgres, Agent +4
This workflow acts as a junior finance research analyst for a UK boutique M&A or corporate finance team. It listens for Slack messages, classifies the request, gathers company or market data, and prod
HTTP Request, Google Drive, Google Docs +5