:information: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 therelease notesto be notified of the pre-announcement (at the beginning of the month) and post-release announcement (the following month) and thefeature update(on release day).

Find outuse cases,benefitsand watchdemo videosabout the Extensions.

What's New Banner.png

Google Sheets Add-on: "All users can refresh a spreadsheet"

June 16, 2021
T他的版本允许任何用户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]

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

:light_bulb: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:smiling_face_with_sunglasses: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