ℹ️ How to use this page: Next to most features, you will find links to additional content (these open in a new browser tab).
- [blog]: Most features are explained in a blog, along with screenshots, for a quick overview of the features and benefits.
- [video]: Some features are discussed and demoed in a video, as part of our longer release video.
- [user guide]: Most features have a dedicated article which provides step-by-step instructions on how to use them.
- [training]: A micro-lesson is available for this feature in our Learning Center. Some lessons may cover multiple features, so several links can point at the same training content.
- The remaining features are self-explanatory and don't need an article or video.
Subscribe to the release notes to be notified of the pre-announcement (at the beginning of the month) and post-release announcement (the following month) and the feature update (on release day).
Find out use cases, benefits and watch demo videos about the Extensions.
Google Sheets Add-on: "All users can refresh a spreadsheet"
June 16, 2021
This version allows any user with access to refresh the connection and data on a sheet. This new capability extends the ability for more users accessing a sheet to keep the connection and data up-to-date with the latest information. [user guide]
💡 Ideas delivered:
| Release dates | Dec. 2020 | June 2021 |
| Connection Modes | ||
| Read-Only Connection | Yes | Yes |
| Read/Write Connection | Yes | Yes |
| Connection Types | ||
| Connect to a Saved View | Yes | Yes |
| Connect to a Module and Pivot and Filter | - | - |
| Connection Options | ||
| Clone a Connection | Yes | Yes |
| Connection Owner Restriction** | Yes | - |
| Sign-in Options | ||
| Username and password | Yes | Yes |
| Single Sign-on | Yes* | Yes* |
* Self-Service SAML only.
** Only the user who created the first connection in a spreadsheet can refresh the spreadsheet and use the add-on
Google Sheets Add-on: "Read/write connections to saved views"
December 2, 2020
Retrieve, read, and write Anaplan data through the Add-on. Install the add-on now! [user guide]
Easily Produce Robust Analysis and Reports
- Sign in using username and password or SSO (📌 Only self-service SAML is supported, not classic SSO. Please refer to our user guide for more details) [training] [user guide]
- Create module view connections, read-only or read/write [user guide] [video] [training] [training]
- Clone a connection [user guide] [video]
- Change the page selectors [user guide]
- Refresh one or multiple connections [user guide] [video]
- Send and refresh a read/write connection [user guide] [video]
- Option to apply styling and formatting from either Anaplan or Google Sheets [user guide]
- Rapidly create repeatable and ad-hoc “what-if” analyses and reports in Google Sheets [user guide]
💡 Ideas delivered:
- Google Sheets add-on - similar to this idea
