This article explains how to use your synced Google Sheets with Google Looker Studio for reporting.
Connecting to Looker Studio
Yes, you can connect your synced Google Sheets to Google Looker Studio to build custom reports and dashboards on top of your backed-up data. This is a good option if the built-in Pivot and Charts tabs in the Google Sheets do not meet your reporting needs.
Note: Google Drive sync is designed to make your backed-up data accessible. If your project or board structure changes, a new Google Sheet may be created, which means you would need to re-link your Looker Studio reports. For this reason, we do not recommend relying on it as a primary reporting tool.