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!