AutomationFlowsData & Sheets › Jane Riveros — Flujo 04 · Un Tablero, Todos Tus Datos

Jane Riveros — Flujo 04 · Un Tablero, Todos Tus Datos

Jane Riveros — Flujo 04 · Un tablero, todos tus datos. Uses httpRequest, googleSheets. Scheduled trigger; 7 nodes.

Cron / scheduled trigger★★★★☆ complexity7 nodesHTTP RequestGoogle Sheets
Data & Sheets Trigger: Cron / scheduled Nodes: 7 Complexity: ★★★★☆ Added:

This workflow follows the Google Sheets → HTTP Request 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 →

Download .json
{
  "name": "Jane Riveros \u2014 Flujo 04 \u00b7 Un tablero, todos tus datos",
  "nodes": [
    {
      "id": "91f95b9c-b6e0-4c84-859e-9e6d72ec2cbb",
      "name": "C\u00d3MO CONFIGURAR",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        448,
        256
      ],
      "parameters": {
        "content": "## Flujo 04 \u00b7 Un tablero, todos tus datos\n**Qu\u00e9 hace:** todos los d\u00edas junta tus datos de ventas, pagos y pedidos desde sus apps y los deja normalizados en UNA planilla \u2014 tu tablero \u00fanico, siempre al d\u00eda.\n\n**Configuraci\u00f3n (\u224830 min):**\n1. **Fuente A y Fuente B** \u2014 reemplaza las URLs por las APIs de tus apps (tu e-commerce, tu pasarela de pago, tu sistema de pedidos). Agrega m\u00e1s nodos HTTP si tienes m\u00e1s fuentes.\n2. **Normalizar** \u2014 ajusta los campos al formato que uses: fecha, fuente, concepto, monto.\n3. **Google Sheets** \u2014 conecta tu cuenta y elige la planilla del tablero.\n4. Activa el workflow. Corre solo cada ma\u00f1ana a las 7:00.\n\n**Te devuelve:** claridad diaria en 1 vistazo \u2014 decisiones con datos, no a ciegas.\n\n\u2014 Jane Riveros \u00b7 janeriveros.com",
        "width": 460,
        "height": 460
      }
    },
    {
      "id": "ee2f17b3-1ce3-4ea6-9d00-f39f6ea8208d",
      "name": "Cada ma\u00f1ana 7:00",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.3,
      "position": [
        0,
        96
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "days",
              "triggerAtHour": 7
            }
          ]
        }
      }
    },
    {
      "id": "10828143-da08-4252-a9c2-38f027a41542",
      "name": "Fuente A \u00b7 Ventas",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.3,
      "position": [
        224,
        0
      ],
      "parameters": {
        "method": "GET",
        "url": "https://TU-APP-DE-VENTAS.com/api/ventas"
      }
    },
    {
      "id": "23b4997d-4df7-432f-89d4-491ea8824e94",
      "name": "Juntar todo",
      "type": "n8n-nodes-base.merge",
      "typeVersion": 3.2,
      "position": [
        448,
        96
      ],
      "parameters": {
        "mode": "append"
      }
    },
    {
      "id": "7fe40110-8657-4486-8fd5-26bd93bd9081",
      "name": "Fuente B \u00b7 Pagos",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.3,
      "position": [
        224,
        192
      ],
      "parameters": {
        "method": "GET",
        "url": "https://TU-PASARELA-DE-PAGO.com/api/pagos"
      }
    },
    {
      "id": "91d4c127-0e33-40e4-8d25-f0d0ed67cee5",
      "name": "Normalizar datos",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        672,
        96
      ],
      "parameters": {
        "mode": "manual",
        "includeOtherFields": false,
        "assignments": {
          "assignments": [
            {
              "id": "n-fecha",
              "name": "fecha",
              "value": "={{ $json.fecha || $now.toFormat(\"yyyy-MM-dd\") }}",
              "type": "string"
            },
            {
              "id": "n-fuente",
              "name": "fuente",
              "value": "={{ $json.fuente || \"api\" }}",
              "type": "string"
            },
            {
              "id": "n-concepto",
              "name": "concepto",
              "value": "={{ $json.concepto || $json.descripcion }}",
              "type": "string"
            },
            {
              "id": "n-monto",
              "name": "monto",
              "value": "={{ $json.monto || $json.amount }}",
              "type": "string"
            }
          ]
        }
      }
    },
    {
      "id": "dc5a9306-4b5a-4666-a1e9-b6701845601d",
      "name": "Actualizar tablero (Google Sheets)",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        896,
        96
      ],
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {}
        },
        "options": {}
      }
    }
  ],
  "connections": {
    "Cada ma\u00f1ana 7:00": {
      "main": [
        [
          {
            "node": "Fuente A \u00b7 Ventas",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fuente B \u00b7 Pagos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fuente A \u00b7 Ventas": {
      "main": [
        [
          {
            "node": "Juntar todo",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Juntar todo": {
      "main": [
        [
          {
            "node": "Normalizar datos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fuente B \u00b7 Pagos": {
      "main": [
        [
          {
            "node": "Juntar todo",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Normalizar datos": {
      "main": [
        [
          {
            "node": "Actualizar tablero (Google Sheets)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1",
    "availableInMCP": true
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Jane Riveros — Flujo 04 · Un tablero, todos tus datos. Uses httpRequest, googleSheets. Scheduled trigger; 7 nodes.

Source: https://github.com/testaiprojects1-sketch/janeriveros-website/blob/729a8f99b3a6bfd5307b5f1814b43e25abcb3ca1/public/n8nflujos/jane-riveros-flujo-04.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

Complaint Triage Orchestrator (S2.3). Uses httpRequest, googleSheets. Scheduled trigger; 65 nodes.

HTTP Request, Google Sheets
Data & Sheets

This workflow automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo

Google Sheets, HTTP Request, Form Trigger +2
Data & Sheets

YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.

Google Sheets, Google Sheets Tool, HTTP Request +1
Data & Sheets

This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev

Google Calendar, Google Sheets, HTTP Request +1
Data & Sheets

ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.

Start, HTTP Request, Function Item +3