Add-on for Google Sheets Release Notes

See Add-on for Google Sheets for more information.

Version 1.2.0 — October 2026

The Jedox Add-on for Google Sheets is now available from the Google Workspace Marketplace. This release enables you to work with Jedox data directly in Google Sheets by inserting stored Views and PALO functions to build integrated reports.

  • Stored Views — Insert Jedox Views into your spreadsheet while maintaining a server connection.

  • PALO functions — Enter PALO functions directly into cells to query the Jedox In-Memory DB.

  • Alias support — Use aliases in Views and PALO function arguments (e.g., from PALO_ESELECT in PALO_DATA).

  • Single sign-on (SSO) — Authenticate using OAuth 2.0 / OpenID Connect (OIDC) for a seamless user experience with fewer authentication prompts.

  • Calculation triggers — Control PALO function recalculation on demand using calculation triggers as the first function argument.

  • Session recovery — Automatic session recovery and error handling for seamless reconnection.

  • Migration support — Migrate Jedox Web Spreadsheets or Excel reports to Google Sheets. See Migrating Reports to Google Sheets for guidance on function naming and formula adjustments.

 

Updated October 19, 2026