Instead of exporting data manually, you can connect your DataHawk-powered BigQuery database directly to Google Sheets. This gives you automatically refreshed data inside a Google Sheets file — no downloads, no copy-pasting.

<aside> 💡

Estimated setup time: under 5 minutes.

</aside>

Prerequisites

• An activated DataHawk-hosted BigQuery database.
  • If you haven't set one up yet, go to ‣
• Your data sources (Amazon / Walmart accounts) should be connected and collecting data.
  • If you did not connect any data sources, go to ‣
  • ‣ for more context info
• Your Google email address must be registered on your BigQuery database page
  • Go to your DataHawk App Account, Setup > Destinations > BigQuery > Access. DataHawk uses this to share access to templates.

Set up

https://demo.arcade.software/km1FjOLRWaL4KiOuIPkj?embed

Step 1 — Connect your BigQuery database

1. Open or create a Google Sheets file.
2. In the navigation menu, click Data > Data Connectors > Connect to BigQuery.
3. Select the BigQuery project that DataHawk created for you.
4. Select the schema you want to access (e.g. PRODUCT, SELLER, ADVERTISING).
5. Either select a table to load it entirely, or write a SQL query to load partial data.
6. Click Connect, then Create an Extract.

Note on case sensitivity in BigQuery queries: When writing SQL queries in Google Sheets' BigQuery connector, use the following casing conventions:

• Project name: lowercase (e.g. sales-datahawk-bigquery)
• Schema: UPPERCASE (e.g. PRODUCT)
• Table name: lowercase (e.g. product_sales_rank)
• Surround the full path with backticks: project.SCHEMA.table

Step 2 — Create an Extract

After connecting, you'll initially see only a preview of the data. To get the full results, create an Extract.

An Extract lets you: