AutomationFlowsData & Sheets › Fase 1 - Motor Logica

Fase 1 - Motor Logica

FASE 1 - Motor Logica. Uses googleSheets. Scheduled trigger; 8 nodes.

Cron / scheduled trigger★★★★☆ complexity8 nodesGoogle Sheets
Data & Sheets Trigger: Cron / scheduled Nodes: 8 Complexity: ★★★★☆ Added:

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": "FASE 1 - Motor Logica",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 6
            }
          ]
        }
      },
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -600,
        0
      ]
    },
    {
      "parameters": {
        "operation": "read",
        "documentId": "REEMPLAZAR_SHEET_ID",
        "sheetName": "Calendario"
      },
      "name": "Get Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -400,
        0
      ]
    },
    {
      "parameters": {
        "conditions": {
          "conditions": [
            {
              "leftValue": "={{ $json.estado }}",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "rightValue": "pendiente"
            }
          ]
        }
      },
      "name": "IF Estado",
      "type": "n8n-nodes-base.if",
      "position": [
        -200,
        0
      ]
    },
    {
      "parameters": {
        "conditions": {
          "conditions": [
            {
              "leftValue": "={{ new Date($json.fecha_hora) }}",
              "rightValue": "={{ new Date() }}",
              "operator": {
                "type": "dateTime",
                "operation": "beforeOrEquals"
              }
            }
          ]
        }
      },
      "name": "IF Fecha",
      "type": "n8n-nodes-base.if",
      "position": [
        0,
        0
      ]
    },
    {
      "parameters": {
        "batchSize": 1
      },
      "name": "Split In Batches",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        200,
        0
      ]
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "modo",
              "value": "test"
            }
          ]
        }
      },
      "name": "Set Modo",
      "type": "n8n-nodes-base.set",
      "position": [
        350,
        0
      ]
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "tipo",
              "value": "={{ $json.tipo }}"
            },
            {
              "name": "caption",
              "value": "={{ $json.caption }}"
            },
            {
              "name": "media_url",
              "value": "={{ $json.media_url }}"
            },
            {
              "name": "hashtags",
              "value": "={{ $json.hashtags }}"
            },
            {
              "name": "plataforma",
              "value": "={{ $json.plataforma }}"
            },
            {
              "name": "row_number",
              "value": "={{ $json.row_number }}"
            },
            {
              "name": "modo",
              "value": "={{ $json.modo }}"
            }
          ]
        }
      },
      "name": "Build Payload",
      "type": "n8n-nodes-base.set",
      "position": [
        500,
        0
      ]
    },
    {
      "parameters": {
        "workflowId": "REEMPLAZAR_WORKFLOW_ID_PUBLICADOR",
        "options": {}
      },
      "name": "Execute Publicador",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        700,
        0
      ]
    }
  ],
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Sheet"
          }
        ]
      ]
    },
    "Get Sheet": {
      "main": [
        [
          {
            "node": "IF Estado"
          }
        ]
      ]
    },
    "IF Estado": {
      "main": [
        [
          {
            "node": "IF Fecha"
          }
        ]
      ]
    },
    "IF Fecha": {
      "main": [
        [
          {
            "node": "Split In Batches"
          }
        ]
      ]
    },
    "Split In Batches": {
      "main": [
        [
          {
            "node": "Set Modo"
          }
        ]
      ]
    },
    "Set Modo": {
      "main": [
        [
          {
            "node": "Build Payload"
          }
        ]
      ]
    },
    "Build Payload": {
      "main": [
        [
          {
            "node": "Execute Publicador"
          }
        ]
      ]
    }
  }
}
Pro

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

About this workflow

FASE 1 - Motor Logica. Uses googleSheets. Scheduled trigger; 8 nodes.

Source: https://gist.github.com/karolmendezb-commits/28c433aa67bfae0ab8fd023c9be7bc9d — 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

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

Useful if a team is working within a single instance and you want to be notified of what workflows have changed since you last visited them. Another use-case might be monitoring your managed instances

Google Sheets, Execute Workflow Trigger, n8n
Data & Sheets

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

Start, HTTP Request, Function Item +3