A new file in the folder — data straight into the sheet

The scenario watches a folder in Microsoft OneDrive, parses the new file and adds the data to Microsoft Excel 365.

  • The sheet updates the instant a file arrives
  • The format is checked, the data cleaned
  • Data lands in Microsoft Excel 365 by fields
  • Nothing moved by hand