So : I have a file named Merger in my Google Drive. I need to import every day the data that came automatically in a google sheet format in the Merge file. Be aware that the everyday file came with a different name (the name is changed with the date). The second thing to know is that the file came with 2 sheets inside. Only the second one is what I need. But I don’t want to append data but replace the previous one. How can I create this ? Thanks for your help. Regards.
You could try a service like IFTTT or Zapier.
Below an example with IFTTT. An applet that triggers every time you’re getting a new attachment by email. This attachment would be stored on Google Drive. You can replace an existing file (the file from yesterday).
Let me know if that works!