How to integrate Dropbox – Google Sheets bundle using Zapier?

Automate Dropbox and Google Sheets using Zapier to automate row creation when files are added or updated. Streamline tasks and boost efficiency in minutes!

Creating a new row in the spreadsheet when a new file is uploaded or an existing one is updated on Dropbox

How the integration works:

• A new file on Dropbox is made or updated
• Zapier creates a new row in the Google Sheet

1. On the “Home” tab, click on “Create”

2. In the dropdown menu, select “Zaps”

Setting up the trigger event

3. Trigger event is the event that occurs in the target app and informs Zapier to start the Zap.

4. Select the trigger event app

5. In the dropdown menu, select “New or Updated File” and click on “Continue”. This way, the trigger will only activate when a file is created or updated.

6. Select your Dropbox account and click “Continue”

7. Fill out the required fields and click on “Continue”

8. Test the trigger by clicking on the corresponding button

9. If everything is correct, the system should display all the information. Click on “Continue with selected record”

Setting up the action in Google Sheets

10. Select the target app

11. Select “Create Spreadsheet Row” as an action to do when a file was created or updated

12. Select your Google account and click “Continue”

13. Fill out the required fields and click “Continue”

14. Test the connection between Dropbox and Google Sheets

15. If everything was done correctly, you should see the test data in your spreadsheet

16. Click “Publish”

17. After that, the Zap is now created, set up and working.