Use Anaplan Add-on for Google Sheets to create a connection between an Anaplan module and a Google worksheet.
Note: Self Service Security Assertion Markup Language (SAML) must be configured to sign in to the add-on with Single Sign-On (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 add-on is part of your Anaplan subscription. No additional subscription is required.
When you create a connection, Google Cloud Platform hosts any data your connection contains. 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 add-on. Other browsers are not supported.
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 to:
- Install the add-on.
- Sign in.
- Connect a Google worksheet to an Anaplan module.
- View and edit data in Google Sheets.
- Change your settings.
Standard Google Sheets limits for worksheets apply. You're limited to:
- 1 million cells per worksheet
- 18,278 columns per worksheet
- 200 worksheets per spreadsheet
- 10 million cells per spreadsheet
- 50,000 characters in any single string.
There's no limit to 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 1 million items.
Note: A connection between Anaplan and a new worksheet uses at least 26,000 cells from the 1 million in the worksheet. This is to protect any custom data you enter into cells outside the data you retrieve from Anaplan.