Add new Dropbox files to a Microsoft Excel spreadsheet

First, we need to connect Dropbox and Microsoft Excel to Zapier.

• 

  Create Zapier account.

  Create Zapier account if you don't have one.

• 

  Connect Dropbox to Zapier.

  Give Zapier access to your Dropbox account, using Dropbox credentials.

• 

  Connect Microsoft Excel to Zapier.

  Give Zapier access to your Microsoft Excel account, using Microsoft Excel credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

• 

  Set up a Trigger action for Dropbox

  Choose the following trigger: New File in Folder (Triggers when a new file is added to a folder. Make sure the number of files/folders in the watched folder does not exceed 4000.).

• 

  Then set up an Action for Microsoft Excel

  Choose this action: Add Row (Adds a new row to the end of a worksheet.).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between Dropbox and Microsoft Excel.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Add new Dropbox files to a Microsoft Excel spreadsheet!