Question

How to automate overwriting a Google Sheet with data from a daily XLSX email attachment?

  • 21 November 2023
  • 2 replies
  • 45 views

I receive a daily email with an XLSX attachment with more than 3000 rows. I’d like to overwrite an existing Google sheet with a column in that attached xlsx.

Here is my process:
Find new attachment (Gmail) --> Upload to google drive

New Google sheet in a Google drive --> Find Worksheet in Google Sheets

My main problem is that in Find Worksheet I need to select a file that is already uploaded to Drive but I want it to always change with the new attachment.

I have tried different things but I get errors. 

Any idea on the process?

 


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

2 replies

Userlevel 7
Badge +14

Hi @octavio.demarco 

Good question.

You’d likely have to use the GSheets API: https://developers.google.com/sheets/api/guides/concepts

 

Userlevel 7
Badge +14

@octavio.demarco 

Help article to reference: