Bear Brown
← All N8N workflows
Automation & utilitiesFtpGoogle DriveHTTP RequestManual TriggerMicrosoft One Drive

Working with Excel files

Configured with Ftp, Google Drive, HTTP Request, Microsoft One Drive, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗12 nodes · MIT
Workflow preview
Files / mediaRead Binary FileRead Binary FileTriggerOn clicking 'execute'Manual TriggerFiles / mediaWrite Binary FileWrite Binary FileFiles / mediaDownload from GoogleDriveGoogle DriveFiles / mediaDownload from MicrosoftOneDriveMicrosoft One DriveWeb / APIDownload Excel FileHTTP RequestTransformWork out AgeEdit FieldsFiles / mediaUpload to SFTPFtpFiles / mediaUpload to Google DriveGoogle DriveFiles / mediaUpload to MicrosoftOneDriveMicrosoft One DriveIntegrationRead Spreadsheet FileSpreadsheet FileIntegrationWrite Spreadsheet FileSpreadsheet File

Node categories in this workflow

  • Files / media
  • Trigger
  • Web / API
  • Transform
  • Integration

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Read Binary FileFiles / mediaRead Binary FileSee node parameters
On clicking 'execute'TriggerManual TriggerSee node parameters
Write Binary FileFiles / mediaWrite Binary FileSee node parameters
Download from Google DriveFiles / mediaGoogle Drivedownload
Download from Microsoft OneDriveFiles / mediaMicrosoft One Drivedownload
Download Excel FileWeb / APIHTTP RequestSee node parameters
Work out AgeTransformEdit FieldsSee node parameters
Upload to SFTPFiles / mediaFtpupload
Upload to Google DriveFiles / mediaGoogle DriveSee node parameters
Upload to Microsoft OneDriveFiles / mediaMicrosoft One DriveSee node parameters
Read Spreadsheet FileIntegrationSpreadsheet FileSee node parameters
Write Spreadsheet FileIntegrationSpreadsheet FiletoFile

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleDriveOAuth2Api
  • microsoftOneDriveOAuth2Api
  • sftp

Workflow notes

Working with Excel files

Working with Excel files

  1. Load the spreadsheet file into the workflow (.xls, .xlsx, .csv).
  2. Convert the file with Spreadsheet File node. This allows other nodes to access the data.
  3. Transform and manipulate the spreadsheet data as needed
  4. [Optional] Convert back to a spreadsheet file
  5. [Optional] Save file locally or upload to a server

ℹ️ This template shows how to work with spreadsheet files themselves. Use the Microsoft Excel 365 node to interact with the Microsoft Office 365 cloud platform.

Read Binary File

Fetches a local file

2. Convert the file into JSON format

2. Convert the file into JSON format

JSON data can be used by nodes

Download Excel File

Fetches file from server

Working with Excel files

Working with Excel files

Purpose and structure

This folder contains the Working with Excel files workflow. Its executable nodes use ftp, googleDrive, httpRequest, manualTrigger, microsoftOneDrive, readBinaryFile, set, spreadsheetFile, writeBinaryFile. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

On clicking 'execute'

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Microsoftonedrive/0276_Microsoftonedrive_Readbinaryfile_Automation_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • 1A. From a public URL
  • 1. Load file into workflow
  • 1C. From a cloud platform
  • 4. [Optional] Convert node data back to .xls file
  • 3. Manipulate or transform your spreadsheet data
  • 4B. To a webserver via (S)FTP
  • 5. Save or upload new file
  • 4A. To a local filesystem
  • 4C. To a cloud service
  • 1B. From the local filesystem

More in Automation & utilities

1/ Add Your credentials2. Refresh Pipedrive tokens6