Reporting API

Is there a way to build a few API’s that will automatically fill different Google Sheets with different reports?
Example: All Sales Report, Email Report, Opportunity Report?

Thank you!