1. Extensions
  2. Google Sheets Add-on

Use the Anaplan Google Sheets Add-on to create a connection between an Anaplan module and a Google worksheet. This enables you to work with your Anaplan data in Google Sheets.

The Google Sheets Add-on is in early access (EA), and is only available to participants of the EA program.

Find out more about early access or how to register your interest in our current EA programs.

The Add-on is part of your Anaplan subscription — no additional subscription is required.

Connect Google Sheets to Anaplan

When you create a connection, you can choose whether the connection is read-only or read-write.

Read-only connections enable you to work with your Anaplan data in Google Sheets without updating the data in your Anaplan model. 

You can also create a read-write connection to use the Add-on to update data in your Anaplan model.

Once you've created a connection, you can view, and edit the data in Google Sheets. You can also perform calculations using Google Sheets formulas.

When you create a connection, you become the connection owner for the spreadsheet. Only the connection owner can use the Add-on in that spreadsheet. If you are not the connection owner, you can still view and edit the data using Google Sheets, but you must contact the connection owner to:

Alternatively, to use the Add-on yourself, create a new spreadsheet and a new connection.