Looker Studio recently announced new features, including direct integrations with Google Sheets, allowing users to create reports directly from Google Sheets. If a report is not saved, it will be deleted after 24 hours.
Creating a Report
To create a new report from Google Sheets:
- Navigate to the desired Google Sheet.
- Click on Extensions in the toolbar.
- Select Create a new report under the Looker Studio section.
4. Configure report options if needed.
5. Click Create. Looker Studio will open in a new tab and generate the report.
6. If you don't have a Looker Studio account, you'll be prompted to create one.
7. Click Save and share to save the report. Unsaved reports will be deleted after 24 hours.
8. After saving, you can edit and share the report.
Options
- Use first row as headers: Uses the first row as field names.
- Include hidden and filtered cells: Includes or excludes hidden/filtered data.
- Include selected range: Defines a specific cell range using standard column-row syntax (e.g., A1:Z26).
Updating the Data Source
When creating a report from Google Sheets, Looker Studio generates a new data source. To update it:
- Manually refresh the report data if the Sheet data changes.
- Refresh data source fields if columns are added or edited.
Things to Consider
- Default report name:
Looker Studio Reporting - <timestamp>. - Data must be in a tabular format.
- Merged cells are not supported.
- Header row must be a single row.
- All cells in a column should be of the same type.
- Date fields must be formatted using the Date data type.
Want to know more, read the full documentation here.
