Getting Started
Google Sheets from scratch using Datanable
How to use Datanable with Google Sheets?
Datanable is powered by BigQuery, allowing you to easily access your data on Google Sheets through a native integration. No add-ons are required!
Prerequisites
Prerequisites:
- You must have at least one active connection with an "OK" status.
- You must have performed a Google Data Share to ensure your data is shared with your Google account and available in Looker Studio.
Note: Please note that if you have just completed a Google Data Share, immediate access to the data may not be available. It can take up to 15 minutes for Google to grant access to the shared data. This delay applies only the first time a data share is created.
Steps to Connect Your Datanable Data into Google Sheets
Open Google Sheets. Once the list of available connectors appears, follow these steps:
- Click on "Data" in the menu bar.
- Scroll down and click on "Data connectors", then select "BigQuery".
- Locate
datanable-cloud. (If you don’t seedatanable-cloudand have just completed a Google Data Share, note that access may not be immediate. It can take up to 15 minutes for Google to grant access to the shared data.) - Choose the source you want to use, such as
meta_ads__{your_organization_id}. - Select a specific table, for example,
meta_ads__ad_daily, to access your daily ad insights. - Click "Add" to integrate the data into your report.
Repeat this process to add all the tables you wish to include.
