Register

Version Information for Google Sheets Add-on

ℹ️ 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.

What's New Banner.png

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

💡 Ideas delivered:

Watch Our Release Video

Previous Versions.png

Release dates Dec. 2020
Connection Modes  
Read-Only Connection Yes
Read/Write Connection Yes
Connection Types  
Connect to a Saved View Yes
Connect to a Module and Pivot and Filter -
Connection Options  
Clone a Connection Yes
Sign-in Options  
Username and password Yes
Single Sign-on Yes*

* Self-Service SAML only.

Comments

This is a really fantastic & detailed summary of such a new -- and exciting -- additional capability.  As much of a fan of MS-Excel as many of us are, Google Sheets has a whole series of (very) underrated aspects of its own.  


Sidenote:  As a relative newcomer to Anaplan, I was able to try this using the "Financial Reporting Tips & Tricks" sample on the AppHub and it worked immediately, which was just so cool 😎  There are a lot of amazing possibilities for this from the FP&A perspective especially.  Kudos!