Hi everyone,
I’m trying to build an automation using Make and would love some help.
Every day, I receive an email with these details:
• Label: x
• From: y
• Subject: z
• It includes an Excel file attachment with data I need.
Here’s what I want to achieve with Make:
- Automatically detect the latest email matching that label/sender/subject.
- Download the Excel attachment from the email.
- Extract the data from the Excel file.
- Replace the existing content in a specific Google Sheet with the new data daily.
*The target Google Sheet has a fixed file ID and sheet name, because it’s used as a data source by another sheet. These must remain unchanged!!
When I tried doing it with ChatGPT, it changes the sheet name in every day and I couldn’t find a solution.
Has anyone set up something like this with Make? I’d really appreciate guidance on which modules to use, any common pitfalls, or even a template to start from.
Thanks in advance!