I'm working on generating a regularly updated report. Currently the database I'm accessing only supports scheduled exports of data to an email. (Formatted as a CSV, XLSX, or PDF)
This would be fine, but I need to do post processing before the report is in a presentable manner. With computing automating repeated processes is ideal.
So have data coming in as CSV attachments, every email has the same title format, and every CSV report has the same number of columns.
I'm fine building a multiple step process, but I want to figure out an efficient way to get all the exported reports to be merged into a spreadsheet as they roll in, so that I can increase the frequency of the reports.