Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I update all rows in a Google Sheet when the matching Dropbox Excel file is updated

  • June 1, 2025
  • 9 replies
  • 59 views
D

Hi All

We have a number of excel files in dropbox, they are pretty simple files - just around 20 rows of data. We manually copy that data into a matching google sheet so both files are the same. This was easy enough when we only had a couple to do each month but now we have over 20 and its a bit of a pain.

So what we want is to use zaps to automate that process, we want to sync the data in each file to the corresponding file in google sheets. So when the excel file is updated all the data (rows) in that file are copied up to google sheets so the two files are always the same. I’ve tried this a few times now and set up a zap when the dropbox file gets updated as the trigger but I then tried to set up the next step to update google spreadsheet rows but no matter what I do here it does not update the google sheet. I see all the column names listed but what do I put in here?  I've also seen conflicting advice on whether this is actually possible - help :)

 

 

Best answer by ken.a

Hi ​@DM9000,

Unfortunately, Dropbox is not supported as a storage source when using the Microsoft Excel app in Zapier. However, we have an existing feature request for this.

I have added you to the feature request. That does a few things:

- Bring this to the attention of the integration developers
- Help track interest in this feature being implemented
- Allows us to notify you via email if this feature becomes available in the future

While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!

Hopefully, this helps.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Mohammad_Shahzaib_Nawaz
Forum|alt.badge.img+2

​@DM9000 

It is because you have not mapped out the data coming from the Excel sheet (step 1), In relevant fields in Step 2.

Review this link for how to do that.

Link: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields

www.linkedin.com/in/mohammad-shahzaib-nawaz-986618136
D
  • DM9000Beginner
  • Author
  • Beginner
  • 4 replies
  • June 2, 2025

Hey Mohammad - thanks for this, appreciate your help.  :). Ok So I tried clicking the map field buttons already but what I see is this:

 

 

Nothing I see here matches my fields in the spreadsheet. The spreadsheet has Plan, Plan Target and other fields like that etc but the data shown here is file name, file ext, modified etc and other stuff like that. So that made me think that the data being retrieved from dropbox/excel was incorrect so I took a look at that next.

 

The initial setup is pretty basic - I just just picked the file really.

 

When I do a test it brings back this information shown below but I don’t see my fields (plan, Plan target etc) or even the sample data so I assume I’m getting this bit wrong but I can’t see many options to change what I’m retrieving

Thanks

Donald

Mohammad_Shahzaib_Nawaz
Forum|alt.badge.img+2

​@DM9000 

Your first step is not configure properly, as you want to update Google sheet on Update of Spreadsheet so you should use this in Trigger.

Search for Spreadsheet and select the below in it, select the correct sheet and then map accordingly.

 

 

www.linkedin.com/in/mohammad-shahzaib-nawaz-986618136
A
Forum|alt.badge.img+2
  • Adil WaqasBeginner
  • Beginner
  • 58 replies
  • June 3, 2025

I understand you're looking to automate the process of syncing your Dropbox Excel files with corresponding Google Sheets to save time and reduce manual work.

I can help you set up the Zap in Zapier to automatically update your Google Sheets whenever the Excel file in Dropbox is updated. I’ll ensure the correct fields are mapped in the "Update Spreadsheet Row" step so that all the data is transferred accurately.

 

 

D
  • DM9000Beginner
  • Author
  • Beginner
  • 4 replies
  • June 3, 2025

Hey Mohammed

That makes sense but I cannot get that trigger (I think) as all my excel files are in Dropbox and that does not give me that option.  All I have are these 3 options

 

Mohammad_Shahzaib_Nawaz
Forum|alt.badge.img+2

​@DM9000 

You have to change the trigger completely, this is the trigger you should use. 

 

www.linkedin.com/in/mohammad-shahzaib-nawaz-986618136
D
  • DM9000Beginner
  • Author
  • Beginner
  • 4 replies
  • June 3, 2025

Hi Mohammad. - Thanks again, when I pick Microsoft Excel as the trigger it only gives me 2 options for the file location: onedrive or sharepoint.

All our files are in dropbox so not sure how that would work using this trigger

 

Thanks

 

Donald

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • 6780 replies
  • Answer
  • June 4, 2025

Hi ​@DM9000,

Unfortunately, Dropbox is not supported as a storage source when using the Microsoft Excel app in Zapier. However, we have an existing feature request for this.

I have added you to the feature request. That does a few things:

- Bring this to the attention of the integration developers
- Help track interest in this feature being implemented
- Allows us to notify you via email if this feature becomes available in the future

While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!

Hopefully, this helps.

D
  • DM9000Beginner
  • Author
  • Beginner
  • 4 replies
  • June 4, 2025

Hi Ken

Thanks for adding me to the feature request - look forward to using that once it’s ready

 

Thanks

Donald

Terms & ConditionsAccessibility statement