Is there any way to send an Excel received by email to Dataprep?
Every day I receive an email alert with an Excel file that I want to process through a Dataprep pipeline.
To do this, I need to:
-Save the file to disk
-Open the pipeline
-Run the pipeline
-Update the source
-Several clicks to select and open the saved Excel from disk
-Continue running the pipeline
-Download the result
Is there any way to reduce steps? In particular I would like to not have to update the pipeline source with the new Excel file by hand. I think there could be two ways:
-The one with least work would be forwarding the email with the file to a specific email address that somehow sends attachments to Dataprep.
-Another way would be having a folder (in Zoho Workdrive or in Google Drive) that is watched, and new files are opened by Dataprep.
I think that Dataprep can't do any of this. Perhaps Zoho Flow can?
I'd be grateful for any ideas. Thanks!