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: "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:

Previous Versions.png

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

💡 Ideas delivered:

Watch Our Release Video

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!

Hi,

Does Google Add-In allow to Pivot and Filter the way it's possible in Excel Add-In? I was only able to connect, but on 'Preview' data format seems to be uneditable. Would appreciate your support.

Kind regards,

Monika