automate manually process from websites

How to automate manually process from different websites, crm & dsahbaords.
Every day with username and password to web dashboard of companies we manage online campaigns for them.

Some of the dashbaord should be access with Selenium, some have API. etc
After login, export a simple report, in excel/csv format.

Need to prepare the data, and push it back to CRM via our simple API request.