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": "Dashboard_Sheets",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.3,
"position": [
0,
0
],
"id": "9e149929-693e-4fce-afe1-0b0fb84a47ba",
"name": "Schedule Trigger"
},
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT \n m.ticket_id,\n m.cliente_id,\n c.nombre,\n m.modelo,\n m.tokens_input,\n m.tokens_output,\n m.costo_usd,\n m.tiempo_ms,\n m.estado,\n t.urgencia,\n t.escalado,\n m.created_at\nFROM metricas m\nLEFT JOIN clientes c ON m.cliente_id = c.id\nLEFT JOIN tickets t ON m.ticket_id = t.id\nORDER BY m.created_at DESC\nLIMIT 10;",
"options": {}
},
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.6,
"position": [
208,
0
],
"id": "cf0f4be9-4606-4133-9f3b-0e37679d0dbe",
"name": "Obtener_info_ticket_cliente",
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "clear",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "list",
"cachedResultName": "Dashboard_reto_final",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1omiRQw0u9_Tp8R_wcelfbZHdKiknZvjHygjAB1rCZgQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Metricas_raw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1omiRQw0u9_Tp8R_wcelfbZHdKiknZvjHygjAB1rCZgQ/edit#gid=0"
},
"clear": "specificRange",
"range": "A2:Z1000"
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
416,
0
],
"id": "2c4f996a-9d82-42b5-894f-68871380b504",
"name": "Clear sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "list",
"cachedResultName": "Dashboard_reto_final",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1omiRQw0u9_Tp8R_wcelfbZHdKiknZvjHygjAB1rCZgQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Metricas_raw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1omiRQw0u9_Tp8R_wcelfbZHdKiknZvjHygjAB1rCZgQ/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"ticket_id": "={{ $json.ticket_id }}",
"cliente_id": "={{ $json.cliente_id }}",
"modelo": "={{ $json.modelo }}",
"tokens_input": "={{ $json.tokens_input }}",
"tokens_output": "={{ $json.tokens_output }}",
"costo_usd": "={{ $json.costo_usd }}",
"tiempo_ms": "={{ $json.tiempo_ms }}",
"created_at": "={{ $json.created_at }}",
"estado": "={{ $json.estado }}",
"nombre": "={{ $json.nombre }}",
"urgencia": "={{ $json.urgencia }}",
"escalado": "={{ $json.escalado }}"
},
"matchingColumns": [],
"schema": [
{
"id": "ticket_id",
"displayName": "ticket_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "cliente_id",
"displayName": "cliente_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "nombre",
"displayName": "nombre",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "urgencia",
"displayName": "urgencia",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "escalado",
"displayName": "escalado",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "modelo",
"displayName": "modelo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "tokens_input",
"displayName": "tokens_input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "tokens_output",
"displayName": "tokens_output",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "costo_usd",
"displayName": "costo_usd",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "tiempo_ms",
"displayName": "tiempo_ms",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "estado",
"displayName": "estado",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "created_at",
"displayName": "created_at",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
624,
0
],
"id": "cc425332-2747-4ce6-97f8-735563c295f5",
"name": "Append row in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Obtener_info_ticket_cliente",
"type": "main",
"index": 0
}
]
]
},
"Obtener_info_ticket_cliente": {
"main": [
[
{
"node": "Clear sheet",
"type": "main",
"index": 0
}
]
]
},
"Clear sheet": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"binaryMode": "separate",
"availableInMCP": false,
"timeSavedMode": "fixed",
"errorWorkflow": "Lg4ma3dxwZeqgxOJDE0ew",
"callerPolicy": "workflowsFromSameOwner"
},
"versionId": "cd14ac19-0a0f-425e-8631-8ff96c3435ad",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "oBUCBnVsP2HV8JJ4j4JJo",
"tags": [
{
"updatedAt": "2026-04-09T17:46:49.517Z",
"createdAt": "2026-04-09T17:46:49.517Z",
"id": "mgZcU7gmlZ9CRjHr",
"name": "sheets"
},
{
"updatedAt": "2026-04-09T17:46:57.624Z",
"createdAt": "2026-04-09T17:46:57.624Z",
"id": "sNlg2URyKQ1opU4m",
"name": "dashboard"
}
]
}
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
Dashboard_Sheets. Uses postgres, googleSheets. Scheduled trigger; 4 nodes.
Source: https://github.com/sergioRancibia/n8n-automation-ai-agents-portfolio/blob/main/n8n-ai-automation-system/workflows/dashboard-sheets.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.
Synchronize Your Google Sheets With Postgres. Uses scheduleTrigger, compareDatasets, splitOut, googleSheets. Scheduled trigger; 10 nodes.
Google Sheets, Postgres
Synchronize your Google Sheets with Postgres. Uses scheduleTrigger, compareDatasets, splitOut, googleSheets. Scheduled trigger; 10 nodes.
Google Sheets, Postgres
This workflow monitors customer health by combining payment behavior, complaint signals, and AI-driven feedback analysis. It runs on daily and weekly schedules to evaluate risk levels, escalate high-r
Google Sheets, HTTP Request, Gmail +2
Code Postgres. Uses httpRequest, splitInBatches, postgres, hubspot. Scheduled trigger; 23 nodes.
HTTP Request, Postgres, HubSpot +1
This workflow automatically monitors and reports data quality for any SQL table using configurable checks and thresholds. It evaluates key metrics—including null values, duplicate records, row count a
Postgres, Google Sheets, Gmail