Best answer

Export email attachment data into Google Sheets

  • 16 August 2021
  • 6 replies
  • 806 views

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?

 

icon

Best answer by Troy Tessalone 16 August 2021, 17:24

View original

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

6 replies

Userlevel 7
Badge +14

Hi @YitzE 

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

I can set it up as Excel workbook or CVS

Userlevel 7
Badge +14

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.)

 

 

 

Userlevel 7
Badge +14

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.