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.
Self Service SAML must be configured in order to sign in to the Google Sheets Add-on with SSO. Talk to your tenant administrator to confirm if Self Service SAML is configured.
If Self Service SAML is not configured, sign in with your Anaplan email address and password.
The Google Sheets Add-on is part of your Anaplan subscription. No additional subscription is required.
When you create a connection, any data it contains is hosted on Google Cloud Platform. As a result, data in your connections may be located in a different jurisdiction to your Anaplan data.
Note: Google Chrome is supported for the Anaplan Google Sheets Add-on. Other browsers are not supported.
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.
Read-write connections enable you to update data in your Anaplan model through Google Sheets.
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. You can use all of the features of the add-on:
- Install the Google Sheets Add-on
- Sign in to Google Sheets Add-on
- Connect a Google worksheet to an Anaplan module
- View and edit data in Google Sheets
Standard Google Sheets limits for worksheets apply. You're limited to:
- 1,000,000 cells per worksheet
- 18,278 columns per worksheet
- 200 worksheets per spreadsheet
- 50,000 characters in any single string
You are not limited in the number of rows you can have in a worksheet. You cannot create a connection to a module that contains a dimension with more than one million items.
Be aware that any connection between Anaplan and a new worksheet will use at least 26,000 cells from the 1,000,000 in the worksheet. This is to protect any custom data you enter into cells outside the data you retrieve from Anaplan.