Files & Documents

Send spreadsheet files in batches via email

6 nodes 130 84 Automatic trigger
Download

Workflow Description

An automated workflow that reads spreadsheet files, divides them into multiple batches, and sends each batch via email separately. Ideal for distributing reports and data to recipients efficiently without manual intervention.

How it works

  1. 1.Trigger the workflow manually or based on a specific event
  2. 2.Read the spreadsheet file from the system
  3. 3.Split the data into predefined batch sizes
  4. 4.Send each batch via a separate email message
  5. 5.Repeat the sending process for all batches
  6. 6.Log the completion status of the operation

Use cases

  • Distribute monthly reports to the sales team
  • Send large customer lists divided into groups
  • Share performance data across different departments

Requirements

  • Email account configured in n8n
  • Spreadsheet files in compatible format (CSV or Excel)
  • Define recipient email addresses

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Email Send Spreadsheet File Split In Batches

Details

Trigger Automatic trigger
Nodes 6
Apps 3
Views 130
Downloads 84

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 (6)

On clicking 'execute'

Manual Trigger

#1

Send Email

Email Send

#2

Read Binary File

Read Binary File

#3

Spreadsheet File

Spreadsheet File

#4

SplitInBatches

Split In Batches

#5

Read Binary File1

Read Binary File

#6