Viewing Your Data in Looker Studio

Use SyncRange's Google Sheets and BigQuery exporters to sync your data, then connect it to Looker Studio. Both destinations are native Looker Studio data sources. You can build dashboards without any extra connectors.

Overview

SyncRange exports your marketing and e-commerce data to Google Sheets or BigQuery on a schedule. Looker Studio (formerly Google Data Studio) can connect directly to both of these destinations. No third-party connectors are required. This approach gives you full control over your data sync schedule, the ability to combine multiple sources in one sheet or dataset, and dashboards that refresh based on your export schedule.

Native Data Sources

Google Sheets and BigQuery are built-in Looker Studio connectors. You can add them as data sources in Looker Studio without installing anything extra. Just authenticate with your Google account and select your sheet or dataset.

Two Ways to Connect

Choose the destination that best fits your use case. Both work seamlessly with Looker Studio.

Google Sheets

Export your data to Google Sheets with SyncRange, then connect that sheet to Looker Studio as a data source.

Best for smaller datasets and ad-hoc reporting
Easy to share and collaborate
You can edit data or add formulas before visualizing
Looker Studio connects via the native Google Sheets connector

Configure Google Sheets

BigQuery

Export your data to BigQuery with SyncRange, then connect your BigQuery dataset to Looker Studio.

Best for large datasets and data warehousing
Powerful SQL queries and joins
Scales to millions of rows
Looker Studio connects via the native BigQuery connector

Configure BigQuery

How to Set Up

Follow these steps to get your SyncRange data into Looker Studio.

Create Exporters in SyncRange

Set up one or more exporters to sync your data to Google Sheets or BigQuery. Connect your data sources (Shopify, Google Ads, Meta, etc.), configure your export destination, and choose a schedule. See Creating Exporters for details.

Let Your Data Sync

Once your exporters run, your data will appear in the selected Google Sheet or BigQuery table. Make sure at least one export has completed before connecting to Looker Studio.

Add a Data Source in Looker Studio

In Looker Studio, create a new report or open an existing one. Click Add data, then choose either Google Sheets or BigQuery from the connectors list. Both are native and require no installation.

For Sheets: Select the spreadsheet and the specific sheet/tab that contains your exported data.
For BigQuery: Select your project, dataset, and table that SyncRange populated.

Build Your Dashboard

Add charts, tables, and filters using your SyncRange data. Your Looker Studio report will refresh based on when Looker Studio loads the data. For Sheets, you can control refresh frequency in the data source settings. For BigQuery, data is queried when the report is viewed.

Data Refresh

Your Looker Studio dashboards show data from your Google Sheets or BigQuery tables. That data is updated by SyncRange according to your export schedule, not in real time from the source platforms.

SyncRange: Exports run on the schedule you set (daily, hourly, etc.). Check your exporter settings in SyncRange.
Looker Studio to Sheets: Looker Studio caches sheet data. You can set the cache expiration in the data source properties (12 hours, 4 hours, etc.) to control how often it fetches fresh data.
Looker Studio to BigQuery: BigQuery queries typically run when the report is loaded or when you manually refresh, so you'll see the latest data that SyncRange has written to your tables.

Tips for Best Results

Use consistent sheet tab names or BigQuery table naming so your Looker Studio data sources stay stable when you add new exporters.
For multi-source dashboards, export multiple data sources to the same Google Sheet (different tabs) or the same BigQuery dataset, then add each as a data source and use Looker Studio's blend feature to combine them.
Ensure your Google account has access to both the SyncRange-connected Google account (if using a shared sheet) and Looker Studio.