(5/5)

Splitout Workflow

Automated workflow: Splitout Workflow. This workflow integrates 14 different services: stickyNote, httpRequest, formTrigger, filter, code. It contains 45 nodes and follows best practices for error handling and security.

Integrations Used (3)

HTTP Request

Google Sheets

Form

Workflow Structure (26 nodes)

100%

Form Trigger

File upload form

Extract From File

To get the first line of file

Set

Set the real fields

Extract From File

Get the content of file

Merge

Merge fields and data

Google Sheets

Get the fields from the sheet

Code

Check if all fields from input are defined

If all fields are defined

Code

Creates the correspondance table

Form

Form to set the correponding field for each input field

Code

Set the values for each field

Code

Set the values for each field1

Split Out

Split all records to import

Set

Define properties

Http Request

Uploads to Hubspot

Form

Form response

Manual Trigger

Start here to update your field list

Google Sheets

Erase Google sheet

Set

Define array of objects

Split Out

Split by object

Http Request

Fetch properties from Hubspot

Code

Define crm_type

Split Out

Split results

Filter

Remove hidden and starting with hs_ props fields

Code

Transforms the results

Google Sheets

Append to Google sheet

Node Types:

logic

http

code

action

transform

trigger

default

Requires credentials

Prerequisites

Required Credentials (3)

Google Sheets

Used by: Append to Google sheet, Erase Google sheet +1 more

Docs

Hubspot

Used by: Fetch properties from Hubspot, Uploads to Hubspot

Docs

Hubspot Developer

Used by: Fetch properties from Hubspot, Uploads to Hubspot

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~50 min

Score: 80/100

Custom Code

Conditional Logic

7 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "nodes": [
    {
      "id": "18813eed-27a8-4338-8e71-abb270d43082",
      "name": "Split by object",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -260,
        540
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "object"
      },
      "typeVersion": 1,
      "notes": "This splitOut node performs automated tasks as part of the workflow."
    },
    {
      "id": "ee610ddd-5bd7-4d97-82a9-b688c71616d8",
      "name": "Fetch properties from Hubspot",
...