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.

Hi All,

I’m constantly downloading reports and using them to replace data on Google sheets. 

If I were to get the report to show up in my Gmail inbox, does anyone know how I can automate the process so that the attachment file is automatically used to replace Google Sheets data?

 

Hi @YitzE 

What type of file is it? (e.g. CSV, XLS, etc.)

I can set it up as Excel workbook or CVS

Hi @YitzE 

Try these Zap steps…

  1. Trigger: Gmail - New Attachment
  2. Action: Filter (for the desired file format, etc.)
  3. Action: GDrive - Replace File

Hi troy,

 

Thanks for your assistance

To clarify, I have a Google sheet with multiple tabs. I do not want to replace the whole workbook. I’m looking to take the data from the CSV and use it just to replace the data on a specific tab starting from a specific cell and onwards (i.e. delete and replace data on tab ‘123’ from row 3 and on etc.)

 

 

 

Hi @YitzE 

You might want to explore a different option such as GAS (Google Apps Script) to handle this type of task.

OK. Thank you.

Terms & Conditions