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.

I have a similar question to this post. I have done the update file and now have an xlsx file within google drive. 

 

I am wondering how or if it is possible to take that information and copy and paste that information and overwrite a specific tab of an existing google sheet. 

 

For background. I get an xlsx file emailed to me daily, I am not able to get it in any other form. I want to take that overwrite that information over the existing information in a specific tab on a google sheet. 

Hi @josephlcox17 

Good question.

Would this Zap trigger work for you: GDrive Replace File

 

Thanks for your quick response @Troy Tessalone . Currently I have the “Replace File” I do have in place, I misspoke and said update file. 

 

With this is in place, I am not sure where to go next and/or if this is the right first step. 

@josephlcox17 

Here’s a help article about how to use Files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

Try these Zap steps:

  1. Trigger: Gmail - New Attachment
  2. Action: Filter (for XLS)
  3. Action: GDrive - Replace File
    1. Map the file object from Step 1

@Troy Tessalone I have that in place, and the xlsx file is being replaced within my google drive. 

 

I do want to take the xlsx file and overwrite data on a different google sheet, on a specific tab, I have. 

@josephlcox17 

With the GSheets Zap, there is no action to replace a Worksheet.

There are actions to Create Worksheet and Create Row(s).

 

@Troy Tessalone Thank you. You are saying that it is not possible, is that correct?

@josephlcox17 

You’d have to programmatically find all the rows with data and delete that data first, which via a Zap would use a lot of Tasks and is not something I’d advise.

@Troy Tessalone Thank you for your responses!

Terms & Conditions