This workflow follows the Google Sheets → Postgres 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": "Cargar Base de datos",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-224,
0
],
"id": "7e4d7931-42c9-4976-a0f0-5ec4789b49fe",
"name": "When clicking \u2018Execute workflow\u2019"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1H1LyNTUeGGjY8ZJr4hSDeg7vJa23zGyhetjtzu0Nfjc",
"mode": "list",
"cachedResultName": "Mensajes",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1H1LyNTUeGGjY8ZJr4hSDeg7vJa23zGyhetjtzu0Nfjc/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Hoja 1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1H1LyNTUeGGjY8ZJr4hSDeg7vJa23zGyhetjtzu0Nfjc/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
0,
0
],
"id": "997345a1-87c9-4544-9eeb-01b05cda9015",
"name": "Obtengo las conversaciones guardadas",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"batchSize": 100,
"options": {
"reset": false
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
224,
0
],
"id": "be2109af-3f0d-418c-9f9d-74932835639c",
"name": "Separo de a 100 registros",
"notesInFlow": false
},
{
"parameters": {
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"table": {
"__rl": true,
"value": "mensajes",
"mode": "list",
"cachedResultName": "mensajes"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"id": "={{ $json.row_number - 2}}",
"input": "={{ $json.input }}",
"output": "={{ $json.output }}"
},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "number",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "output",
"displayName": "output",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "embedding",
"displayName": "embedding",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"queryBatching": "transaction"
}
},
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.6,
"position": [
496,
16
],
"id": "142a4818-9dcf-4623-bc23-0e0279a12399",
"name": "Inserto los datos en la BDD",
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
}
],
"connections": {
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Obtengo las conversaciones guardadas",
"type": "main",
"index": 0
}
]
]
},
"Obtengo las conversaciones guardadas": {
"main": [
[
{
"node": "Separo de a 100 registros",
"type": "main",
"index": 0
}
]
]
},
"Separo de a 100 registros": {
"main": [
[],
[
{
"node": "Inserto los datos en la BDD",
"type": "main",
"index": 0
}
]
]
},
"Inserto los datos en la BDD": {
"main": [
[
{
"node": "Separo de a 100 registros",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"binaryMode": "separate",
"availableInMCP": false
},
"versionId": "2f9fd34a-deb1-4283-9faa-e409668a31ee",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "D7q4widSnxkMkJBp",
"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.
googleSheetsOAuth2Apipostgres
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Cargar Base de datos. Uses googleSheets, postgres. Event-driven trigger; 4 nodes.
Source: https://github.com/thiagodal9/whatsapp_ai_chatbot_rag/blob/4e1bfd806fcd21b97864ca532b8569742ea80ce8/flows/cargar_base_de_datos.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.
Cash Flow - Plan upd. Uses googleSheets, postgres. Event-driven trigger; 11 nodes.
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
Accounting to DWH via email CSV reader (DE). Uses httpRequest, postgres, googleSheets, gmailTrigger. Event-driven trigger; 55 nodes.
PPL Instrument Access (MI). Uses googleSheets, postgres. Event-driven trigger; 38 nodes.
Bill Payment Automated Invoices (Contractor invoice). Uses httpRequest, googleSheets, emailSend, postgres. Event-driven trigger; 25 nodes.