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.