Alke Analytics for Google Sheets ™ connects your Alke Analytics account to Google Sheets, letting you build, run and schedule custom analytics reports without leaving your spreadsheet.

  Key features:
  - Custom reports — Choose dimensions, metrics, aggregations and filters from your Alke Analytics account to build exactly the report you need.
  - Multiple reports per spreadsheet — Each report gets its own sheet with auto-formatted headers and data. Manage all configurations from a single "Report configuration" sheet.
  - Date range presets — Use built-in presets (last 7 days, month to date, previous month…) or specify custom date ranges. Presets recalculate automatically on each refresh.
  - Dashboard URL import — Paste a URL from your Alke Analytics dashboard to instantly pre-fill organization, properties, date range and filters.
  - Scheduled refresh — Set any report to refresh automatically on a specific day and time each week. Last execution timestamp is tracked in the configuration.
  - One-click refresh — Refresh a single report or all reports at once from the menu.
  - Human-readable configuration — Report settings are stored in a visible spreadsheet table that you can review and edit directly.

  Getting started:

  1. Install the add-on and open a Google Sheet.
  2. Go to Alke Analytics > Settings and enter your API token.
  3. Open the sidebar, select your organization and properties, configure your report, and click Run Query.

  Requirements:

  An active Alke Analytics account with a valid API token is required. Visit alketech.eu to learn more.