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:
- change the page selection,
- refresh the connection,
- send and refresh the connection,
- request a new connection in that spreadsheet,
- clone a connection,
- change the settings for the Add-on in the spreadsheet.
Alternatively, to use the Add-on yourself, create a new spreadsheet and a new connection.