How do I update all rows in a Google Sheet when the matching Dropbox Excel file is updated
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 :)
Page 1 / 1
@DM9000
It is because you have not mapped out the data coming from the Excel sheet (step 1), In relevant fields in Step 2.
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
@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.
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.
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
@DM9000
You have to change the trigger completely, this is the trigger you should use.
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
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.
Hi Ken
Thanks for adding me to the feature request - look forward to using that once it’s ready
. Ok So I tried clicking the map field buttons already but what I see is this:
