Once a Google worksheet has been connected to an Anaplan module, the data is displayed in Google Sheets.
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.
You can view and work with your data in the familiar Google Sheets environment.
The Google Sheets Add-on enables you to create either a read-only connection or a read-write connection between Google Sheets and Anaplan.
If your worksheet has a read-only connection you can edit Anaplan data in Google Sheets, but the source data in Anaplan is unchanged.
If your worksheet has a read-write connection, you can edit your data and update Anaplan with your changes using Send and refresh.
Only the connection owner for a particular spreadsheet can:
- refresh or send and refresh a connection,
- preview connection details, or
- change the page selection.
If you're not the connection owner you can still view and edit data as normal in Google Sheets.
Learn how to:
- Show and hide the sidebar
- Refresh a connection
- Send and refresh a read-write connection
- Insert columns and rows in a worksheet
- Rename columns and rows in a worksheet
- View dimensions
- Change page selection