Question

New to Zapier: Overwrite Google Sheet with daily Gmail spreadsheet attachment in csv format

  • 31 January 2023
  • 2 replies
  • 146 views

Struggling to understand the bridge I’m missing here. I receive a daily email with a Report.csv attachment. I’d like to overwrite an existing Google sheet with the detail in that attached report.

 

Is this possible?

 

I’ve started with New Attachment in Gmail and seem to have that setup fine. then, I was moving to Update Spreadsheet Row in Google Sheets but can’t figure out how to connect the actual report data and have it fill in the sheet. I do not want to keep the previous data. 

 

Do I need to use the Formatter as a second step or a first step? If either, which Utility option do I select?

 

Thanks in advance for your patience!


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 @User2962 

Good question.

Have you tried using this Zap action: GDrive - Replace File

 

Userlevel 7
Badge +9

Hey @User2962! I am wondering if the workflow here might support your use case: 

Let us know how things are progressing - we want to make sure you’re good to go, here!