Short answer
HubSpot's KB: export a report as CSV or Excel, or email it; recurring emails can be daily, weekly or monthly. Single-object reports export properties in the Selected properties section; custom reports export Configure tab fields. Only Single object, Event-based and Customer journey reports can be sent as files by email.
1. Reports list
Reports in my demo portal.

2. Google Sheets
For a live sheet, a workflow can write rows. See Google Sheets action.