FM
FlowMarket
Docs, PDF & OCR Intermediate ⚡ 15 n8n Nodes

Automatically update stock portfolio from OneDrive to Excel

Seamlessly Sync and Update Data from a csv in OneDrive to Excel with n8n This workflow is perfect for users who need a reliable, automated way to transfer an...

🔌 Nodes & Integrations Used (5)

Microsoft One Drive Trigger Stop And Error Extract From File Microsoft One Drive Microsoft Excel

📖 Implementation & Setup Guide

Seamlessly Sync and Update Data from a csv in OneDrive to Excel with n8n

This workflow is perfect for users who need a reliable, automated way to transfer and organize data from OneDrive into Excel—especially for tasks like portfolio tracking, inventory management, and record-keeping. By monitoring your OneDrive folder for new CSV files, it performs data cleaning, transformation, and real-time updates in an Excel sheet, ensuring only new or changed records are added.

---

How it Works

  1. **Automated Monitoring**: Every minute, the workflow scans a designated OneDrive folder for new files.
  2. **File Verification**: It checks if the detected file is in CSV format; if not, the process stops with an error message.
  3. **Data Extraction and Cleaning**: CSV data is loaded, and irrelevant headers are removed before mapping to specified columns in Excel.
  4. **Excel Update**: The workflow maps data to your Excel sheet, updating only new or modified entries based on a unique identifier ("Ticker/ISIN").
  5. **Cleanup**: To keep your OneDrive organized, processed files are deleted after updating Excel.

---

Setup Steps

  1. **Connect OneDrive and Excel Accounts**: Link your Microsoft OneDrive and Excel accounts in n8n.
  2. **Designate Folder and Worksheet**: Specify the OneDrive folder for monitoring and the Excel sheet for data updates.
  3. **Configure Sync Frequency and CSV Validation**: Set the monitoring frequency to every minute and ensure the workflow identifies CSV files accurately.

Once configured, this workflow offers a hands-free, efficient solution to keep your OneDrive and Excel data synchronized effortlessly.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save _Automatically_update_stock_portfolio_from_OneDrive_to_Excel.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Docs, PDF & OCR Workflows

View All in Docs, PDF & OCR →