1. Extensions
  2. Google Sheets Add-on
  3. Connect Google Sheets with Anaplan
  4. Clone a connection

In the Google Sheets Add-on, you can clone an Anaplan connection to duplicate the connection and copy cell data into a new worksheet. If you edit the data in the new worksheet, the data in the original worksheet remains unchanged.

You must be signed in to the Google Sheets Add-on to clone a connection.

Note: if you clone a read-write connection, the new connection is also read-write. You can use the cloned read-write connection to update Anaplan. If you want to create a read-only connection with the same connection details, create a new connection in another worksheet.

To clone a connection:

  1. Go to the Anaplan sidebar.
  2. Click Clone connection.
    The Anaplan connection and cell data copy into a new sheet.

The new sheet is given the same name as the original sheet, with a number at the end. For example, Sheet name (1). You can rename the cloned worksheet at any time without affecting the connection.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.