This is hopefully an easy one for some of the more experienced Makers in this community.
My scenario is monitoring a Gmail account looking for new emails from a specific sender with a Specific subject line and then taking the attached file from the email and moving it to an FTP location.
This in itself is all very easy and not a problem.
I have a number of similar scenarios like this working without issue.
I have a file arriving now that I need to do the same job with however the File Name of the attached Excel file changes every day since it contains a date at the end of the file name.
The system reading from the FTP location (where I need to deliver the file) does not support this and requires a fixed file name.
Effectively, I need to overwrite the file in the FTP each day instead of adding a new one.
Please note: SFTP is not supported by the end location, so I don’t think I can use the SFTP “rename file module”. (correct me please if I am wrong and you know how to use this module with Standard FTP)
The incoming email always has only one file attached so the Gmail Iterate attachment module has no problem selecting the file. I could use a regular expression to select the incoming filename (which is always the same apart from the date at the end) but not sure which module to put this into and what to do next.
Ideally what I want to have is logic that says: grab the attachment from the email and whatever the filename is change it to xxxx.xlsx and move it to FTP location yyyyyyy
It sounds really simple and probably is.
Come on geniuses, let me know what I have missed
I knew it would be something really simple.
I think I had even tried that but since the output operations data size was “0” in the final module I had assumed it hadn’t worked.
Looking at the receiving FTP now, I can see it did actually work just fine.
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
Hope this helps! Let me know if there are any further questions or issues.
