1. Extensions
  2. Google Sheets Add-on
  3. Considerations

The following considerations may affect your use of the Anaplan Google Sheets Add-on.

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.

Browser limitationGoogle Chrome is supported for the Anaplan Google Sheets Add-on. Other browsers are not supported.
Same email address requirementTo sign into the Google Sheets Add-on, you must use the same email address for both your Anaplan and Google accounts.
Cell extract count limit

There's a limit of 1,000,000 Anaplan cells per worksheet.

However, there's no limit to the number of worksheets you can use to display Anaplan data in a spreadsheet.

List size limitWe only support lists up to 1,000,000 items.
If a list is longer than this it cannot be loaded in Google Sheets.
Temporary limit to lists

For a temporary period, the Add-on can only retrieve views where any list used in page selectors contains fewer than 200 items.

This limit will be lifted in a subsequent release.

Temporary issue when removing columns or rows from nested headers

If you remove more than 30 items from a nested list in a worksheet connected to an Anaplan saved view, you may be unable to refresh the connection. When this happens, the Retrieving data dialog states that data cannot be retrieved.

You can close the dialog and discard the refresh, but the connection to Anaplan cannot be refreshed again. Create a new connection to continue working with the view in Google Sheets. 

Google Sheets spreadsheet limit

Standard Google Sheets limits for spreadsheets apply. You're limited to:

  • 5,000,000 cells per spreadsheet,
  • 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.

Be aware that any connection between Anaplan and a new worksheet will use at least 26,000 cells from the 5,000,000 in the spreadsheet. This is to protect any custom data you enter into cells outside the data you retrieve from Anaplan.

Browser issue when you add or remove a large number of columns or rows

In some instances, when you add or remove a large number of columns or rows in a Google Sheets worksheet (independent of the Add-on), the browser tab may crash. This usually only occurs if you add or remove more than 100 rows or columns at once.

This issue can affect the Add-on if a large number of rows or columns are added in Anaplan before you refresh the connection. This does not affect the connection. Normally, you can continue to work with your data if you reopen the worksheet. In some cases you may not be able to reopen the worksheet. If this happens, create a new connection and work with your data there.

When a connection is created, it contains the data that's in the Anaplan saved view at that time. Therefore, columns or rows added or deleted prior to the new connection do not cause a problem.

To prevent this issue, create a new connection whenever a large number of columns and rows is added or removed from the Anaplan saved view.

Subsidiary viewsThese are not available in the Google Sheets Add-on.
You can connect to a module with subsidiary views in it, but the Add-on detects these and filters them out.
Slightly slower speeds on first extract or refreshThe first extract or refresh of data from Anaplan into the Add-on may take a few seconds.
Once the data is loaded into memory, future extracts or refreshes of the same connection will be quicker. 
Once extracted to a grid location, Anaplan data cannot be movedThe location of extracted data is determined by the starting cell you select when you make a connection.
If you try to move the grid or copy data to another worksheet (or another location within the same worksheet), the connection to Anaplan breaks.
LocalizationCurrently, the Google Sheets Add-on only supports English. 
Brought-Forward configuration

If the Brought-Forward configuration for a line item is changed in a module, and you subsequently click Refresh in the Google Sheets Add-on, the change is only applied after you've signed out and in again.

If you do not interact with the Google Sheets Add-on for more than 30 minutes you'll be automatically signed out. The next time you sign in, the change will be applied.

Customer Proxy SupportWe do not currently support proxies. If your company uses proxies, please contact Anaplan Support.
Formatting and style settingsYou can choose to apply Anaplan styles and formatting in a worksheet. 
Temporary performance issues when you apply Anaplan styling

If you apply Anaplan styling this can slow down the refresh speed as the data updates the styling. The effect is more noticeable the more rows and columns there are in your connection.

Consider unchecking Apply Anaplan styling if you experience performance issues on refresh.

This is a temporary issue that we expect to resolve in a subsequent version.

Settings are stored at the spreadsheet levelIf you make changes to settings in the Google Sheets Add-on they're applied at the spreadsheet level, rather than at the worksheet level.
Connection owner

Only the user who creates the first connection in a spreadsheet can use the Add-on features in that spreadsheet. This user is the connection owner, and only they can create new connections, clone connections, refresh a connection, or configure settings in that spreadsheet.

If you are not the connection owner for the spreadsheet, contact the owner to request changes, or start a new connection in your own spreadsheet.

Session expires after 30 minutesYou'll automatically be signed out of the Add-on after 30 minutes of inactivity. To continue using the Add-on, sign in again.

Precision differences

You can enter values with up to 17 decimal places in Anaplan. Google Sheets supports values up to 15 decimal places. This can cause a Google Sheets value to be detected as a value change when you perform a Send and refresh.

When your connection includes a value with 17 decimal places, the 15th decimal digit may be rounded up when displayed in Google Sheets.  This happens when the 16th decimal digit is five or greater.

If you want the 15th digit to be the same in Google Sheets and Anaplan, you can re-enter the value in Google Sheets. Google Sheets does not round the 15th digit up or down; it simply displays the first 15 decimal digits you enter.

Even if the values are the same in Google Sheets and Anaplan to 15 decimal places, if the value in Anaplan has 16 or 17 decimal places, this is detected as a value change.

Precision differences between Google Sheet and Anaplan may be complicated by floating-point math. The method Anaplan uses to calculate floating-point math may mean that the digit in the 17th decimal place is rounded up or down when entered.

For example:

  1. Enter 0.12345678901234567 into a cell in Anaplan.
    The value displays in Anaplan as 0.12345678901234566 (due to floating point math, the 17th digit rounds down to six).
  2. Connect a Google worksheet to a module containing the cell.
    The value of the cell in Google Sheets is 0.123456789012346 (the 15th digit is rounded from five to six).
  3. Re-enter the value in Google Sheets to 17 decimal places.
    Google Sheets accepts the number as 0.123456789012345 (the 15th digit is not rounded up).
  4. Send and refresh the connection.
    Send and refresh detects a value change, as the value in Anaplan has 17 decimal places (0.12345678901234566), while the value in Google Sheets has only 15 (0.123456789012345).
  5. Either:
  • Click Submit to submit the shorter value to Anaplan.
    The value in Anaplan updates to 0.123456789012345.
  • Click Refresh all data.
    The value in Google Sheets updates to 0.123456789012346.