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)
📖 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
- **Automated Monitoring**: Every minute, the workflow scans a designated OneDrive folder for new files.
- **File Verification**: It checks if the detected file is in CSV format; if not, the process stops with an error message.
- **Data Extraction and Cleaning**: CSV data is loaded, and irrelevant headers are removed before mapping to specified columns in Excel.
- **Excel Update**: The workflow maps data to your Excel sheet, updating only new or modified entries based on a unique identifier ("Ticker/ISIN").
- **Cleanup**: To keep your OneDrive organized, processed files are deleted after updating Excel.
---
Setup Steps
- **Connect OneDrive and Excel Accounts**: Link your Microsoft OneDrive and Excel accounts in n8n.
- **Designate Folder and Worksheet**: Specify the OneDrive folder for monitoring and the Excel sheet for data updates.
- **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:
- Click the Direct Download JSON button above to save
_Automatically_update_stock_portfolio_from_OneDrive_to_Excel.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Docs, PDF & OCR Workflows
View All in Docs, PDF & OCR →Add articles to a Notion list by accessing a Discord slash comma
This workflow allows you to add articles to a Notion reading list by accessing a Discord slash command. Prerequisites - A Notion account and [credentials](),...
Adobe PDF Services API Automation
Production-ready n8n automation template for Adobe PDF Services API Automation built by AhiXLight. Seamlessly connects HTTP Request, Execute Workflow Trigger, Dropbox with 20 configured nodes.
Adobe PDF Services API Workflow
Production-ready n8n automation template for Adobe PDF Services API Workflow built by AhiXLight. Seamlessly connects HTTP Request, Execute Workflow Trigger, Dropbox with 20 configured nodes.
AI Brand Voice Content Generator
Production-ready n8n automation template for AI Brand Voice Content Generator built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Information Extractor, HTTP Request with 27 configured nodes.