Shell Programmer for getting information from microsoft Office 365

We would like a scheduled script to run and collect information from multiple Office 365 tenants and store the reports in sharepoint site, the credentials and any information needs to be collected from an excel spreadsheet