Does anyone have any hints or tips for an automated workflow that would take an excel (probably really CSV) file that is an email attachment and automate getting contents copied then pasted to open rows in a tab within a different workbook? I get a weekly report from an online application site via formstack. I open the attachment, copy rows and paste them in a workbook where I am tracking applicant progress.
Any help would be greatly appreciated. I am not afraid of scripting languages but am certainly not an automation pro and do not have any specific tools beyond what is native in OSX Catalina.