Add rows to Google Sheets for new Dropbox files

First, we need to connect Dropbox and Google Sheets 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 Google Sheets to Zapier.

  Give Zapier access to your Google Sheets account, using Google Sheets 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 Google Sheets

  Choose this action: Create Spreadsheet Row (Create a new row in a specific spreadsheet.).

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

• 

  Customize data flow

  Configure the data that is exchanged between Dropbox and Google Sheets.

• 

  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 rows to Google Sheets for new Dropbox files!