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. 

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

You're limited to:

  • Read-only connection: up to 700,000 cells per sheet, with styling disabled.
  • Read/write connection: up to 120,000 cells per sheet, with styling disabled.

These limits include empty cells within a worksheet. We recommend removing any unnecessary empty rows and columns to optimize your use of the connections. You can't 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.