Developer & DevOps

Process large datasets in scheduled batches with HTTP requests

10 nodes 174 104 Scheduled trigger
Download

Workflow Description

A scheduled workflow that retrieves data via HTTP, divides it into manageable batches, applies conditional logic to each batch, and sends results to target APIs with timed intervals between batches to prevent system overload.

How it works

  1. 1.Schedule trigger initiates the workflow at predefined intervals
  2. 2.HTTP request fetches raw data from source API or database
  3. 3.Data splits into sequential batches for controlled processing
  4. 4.Conditional logic evaluates each batch to determine processing path
  5. 5.Wait node introduces delays between batch submissions
  6. 6.Final HTTP request sends processed batches to destination endpoint

Use cases

  • Export millions of database records to external systems progressively without overwhelming APIs
  • Process large CSV files and batch-update thousands of records in CRM platforms
  • Sync data between rate-limited systems while respecting API call thresholds

Requirements

  • Valid API endpoint URL and request method (GET, POST, or other)
  • Clear conditional logic rules to filter and categorize data appropriately
  • Optimal batch size and delay interval matched to target system capacity

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Split In Batches

Details

Trigger Scheduled trigger
Nodes 10
Apps 1
Views 174
Downloads 104

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (10)

API to Check existing merge request

HTTP Request

#1

Is Exists

If

#2

Create New Merge Request

HTTP Request

#3

Loop Over Items

Split In Batches

#4

API to CLOSE existing Merge Request

HTTP Request

#5

Add Custom Notes To Merge Request

HTTP Request

#6

30 secs wait to approve merge request and pipeline to finish1

Wait

#7

Merge When Pipeline Succeeds

HTTP Request

#8

setValueForMerge

Set

#9

Schedule Trigger

Schedule Trigger

#10