Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / Data Sync & ETL

Data Sync & ETL

Sync Finance CSV Files from OneDrive to Excel Tables

When a new file appears in a watched OneDrive folder, it extracts CSV data, updates an Excel table and logs the update on a sheet.

Import it free Sign in to open it

The steps

  1. Triggers if new file in watched folder
  2. Not CSV
  3. Extracts data from csv
  4. Microsoft OneDrive2
  5. Cleans the output
  6. No Operation, do nothing
  7. Logs the update on sheet
  8. Gets the new file infos
  9. Downloads the new file
  10. Checks if it's CSV format
  11. Prepares the fields to put in the excel table
  12. Updates the excel table

Similar automations

Forms & SurveysLog Conference Feedback Forms to Excel on OneDrive10 stepsWeb Scraping & ResearchScrape Websites to Sheets, Excel and Emailed CSV10 stepsFiles & Cloud StorageRead and Write Excel Files from Drive, OneDrive, FTP12 stepsFiles & Cloud StorageWork with Files in Microsoft OneDrive3 steps