Google Sheets

​

Connect to Enhanza

1. Start by creating a new Google Sheet.
2. Make sure you are logged in with a Google account that exist as user or has data access.
3. Navigate the menu to Data > Data connectors > Connect to Bigquery.
4. Choose project enhanza.
5. Click directly on Saved queries and query editor, the view to access any data.
6. Now you can choose one of these option:
   • Write custom queries - for data analysts.
   • Let Enhanza help you write them - for busy people.
   • start with our prepared views - easy to get started.

​

Write custom query

1. Use Bigquery Studio to compose your query.
2. Paste it into you the dialogue box in Google Sheets.

​

Let Enhanza help you

​

Use prepared views

1. Paste the below query in the dialogue box in Google Sheets.
2. Replace [schema_type] with one of these:
   • fortnox_flat for standard tables like vouchers, invoices etc.
   • fortnox_reports for more purpose built views like balance_report.
   • custom for custom views that Enhanza has built for you.
3. Replace [workspaceId] with your unique workspaceId.

SELECT
  CASE
    WHEN table_schema LIKE "%_flat_%" THEN "flat"
    WHEN table_schema LIKE "%_reports_%" THEN "reports"
    ELSE table_schema
    END AS schema_type,
  table_name,
  'SELECT * FROM `' || table_catalog || '.' || table_schema || '.' || table_name
    || '`' AS query,
FROM `enhanza`.`[schema_type]_[workspaceId]`.INFORMATION_SCHEMA.TABLES
ORDER BY table_name;

4. From the result:
   1. select you table_name,
   2. copy that query and
   3. start over from the top and paste the query in the dialogue box.

​

Video tutorial