Pull CSV/Excel from URL, Process Thoroughly, Populate Selected Airtable Fields

Hi,

we are doing a lot of local Excel work where report files are downloaded, stored in a certain location and then processed using VBA macros.
Now, I’m looking to automate that process in the cloud and move it a little further by bringing the resulting values into Airtable.

What are ways to properly process these CSVs/Excel spreadsheets based on a specified rule set and then send the results to Airtable where rows will be updated based on a set of rules again? What allows for similar changes as the VBA macros when it comes to processing the original reports?

Thanks,
Jan