At a glance
Your Anaplan permissions apply
Every request to Anaplan carries your own credentials. The connector can only read the workspaces, models, views and cells you can already open in Anaplan.
Read from Anaplan, write to your sheet
Data flows one way: from Anaplan into the Google Sheet you chose. The connector does not write to Anaplan models. Exporting an AI result to a sheet is a separate, explicit step.
Runs on Google infrastructure
The sidebar is a Google Apps Script add-on. Heavier work runs in a connector service in the aPlan4Sheets Google Cloud project (us-central1). There is no third-party hosting.
Outbound requests are allow-listed
The add-on manifest limits the hosts it may call to Anaplan's authentication and regional API endpoints and the connector's own Google Cloud services.
Architecture
Three parts, all on Google infrastructure: the sidebar inside Sheets, the connector service that does the heavy lifting, and the Anaplan APIs. AI features add a fourth hop that only runs when you ask a question.
Authentication to Anaplan
- OAuth 2.0 / SSO is the recommended path. A tenant security administrator creates an OAuth client in Anaplan Administration and the user signs in through Anaplan's own login page; the connector never sees the password. The OAuth client walkthrough shows the administrator steps. Organizational accounts only.
- Basic Auth is available where SSO is not. If you choose it, your Anaplan email and password are kept in your own user-specific Apps Script storage so sessions can be renewed. They are not shared with other users and are cleared when you sign out.
- Tokens expire on Anaplan's schedule. Signing out clears the interactive tokens or credentials for the current method. Schedules keep a separate authentication record so they can run while you are away; deleting the schedule removes it.
What is stored, and where
| Item | Where | How long |
|---|---|---|
| Model and workspace selections, saved pivot, view and linked-report configurations | Google Apps Script properties for your account and the workbook | Until you remove them in the sidebar |
| Schedule definitions, connection records and execution leases | Workbook properties, plus Firestore in the connector's Google Cloud project | Until you delete the schedule |
| Authentication state: OAuth tokens, or Basic Auth credentials if chosen | Your user-specific Apps Script storage; a separate record per schedule in the connector service | Tokens expire per Anaplan; cleared on sign-out or schedule deletion |
| Model structure: module, line item, dimension and dependency metadata used by pivots and the AI Analyst | Compressed objects in Cloud Storage and capped in-memory caches in the connector service | Caches live minutes; stored structure is refreshed as the model changes |
| Cell values from your model | Written to the Google Sheet you chose; processed in memory by the service for that request | Not stored by the service; in-memory processing and short-lived caches only |
| Operational records: account email and domain, usage metadata such as request and token counts, failure diagnostics | Firestore and Cloud Logging in the connector's Google Cloud project | No automatic expiry today; deleted on request |
Google Cloud encrypts stored data at rest by default. Uninstalling the add-on does not by itself delete retained configuration or operational records; email ryan.domke@aplan4sheets.com to request deletion.
Google permissions the add-on requests
These are the permissions shown on the Marketplace listing, with the reason each one exists.
| Permission as Google shows it | Why the connector needs it |
|---|---|
| View and manage spreadsheets that this application has been installed in | Write exports, pivots and refreshes into the workbook where the sidebar is open. |
| See, edit, create, and delete all your Google Sheets spreadsheets | Scheduled refreshes update the workbooks you configured while the sidebar is closed, and workbook copies and linked reports are written to the files you chose. The connector opens only workbooks you configured; it does not browse your Drive. |
| See, edit, create, and delete only the specific Google Drive files you use with this app | Locate or create the files the connector makes for you, such as workbook copies and Slides exports. |
| Allow this application to run when you are not present | The time-based Google triggers behind scheduled refresh. |
| Connect to an external service | Calls to Anaplan's APIs and to the connector's own Google Cloud service. The manifest allow-lists those hosts and no others. |
| Display and run third-party web content in prompts and sidebars inside Google applications | The sidebar and its dialogs. |
| Send email as you | Optional refresh status notifications that you switch on per schedule. Nothing else is sent. |
| See your primary Google Account email address, and your basic profile | Identify your configuration and support requests, and keep the operational records described above. |
Scheduled refreshes
A schedule is a time-based Google trigger that runs as the user who created it, on an hourly, daily or weekly cadence. Timing is approximate because Google manages the trigger, and a run needs valid Anaplan authentication and an available source model. Status and errors appear in the sidebar; email notifications are opt-in. Deleting the schedule stops it and removes its definition and authentication record.
AI features
- What is sent. When you ask the AI Analyst a question, the connector sends your question together with the model metadata or query results needed to answer it. Nothing is sent until you ask.
- Where it is processed. The AI Analyst runs on Google Cloud Vertex AI (Gemini models) inside the connector's own Google Cloud project, under Google Cloud's Vertex AI terms. The Claude handoff is an optional pilot: it is available only where a customer configures the Claude connector, and it sends the selected context to Anthropic's Claude when you trigger that separate action.
- Review before export. Answers come back to the sidebar for you to read. A result reaches your sheet only when you export it, and no AI feature writes to Anaplan.
- What is recorded. Usage metadata such as token counts is kept with the operational records described above.
Transport, hosting and this website
- All traffic between the sidebar, the connector service, Anaplan and Google APIs uses HTTPS.
- The connector service runs on Google App Engine and Cloud Run in us-central1, with logs in Cloud Logging for diagnostics.
- Anaplan's regional endpoints are supported, so a model hosted in the EU, Canada or Asia-Pacific is read from its own region.
- This website is static, served over HTTPS, sets no cookies, runs no analytics or trackers, and contains no customer data. Every demo is a simulation with fictional data.
Your controls
- Sign out in the sidebar to clear the current method's tokens or credentials.
- Disable or delete schedules in the sidebar and check the confirmation.
- Uninstall from Extensions → Add-ons → Manage add-ons, then request deletion of anything retained.
- Report a concern to ryan.domke@aplan4sheets.com. Security reports are read by the developer directly.
Compliance
The add-on complies with Google Workspace Marketplace policies and the Google API Services User Data Policy, including the Limited Use requirements. Connector data is never used for advertising or sold. Read the Privacy Policy for the full retention and deletion terms and the Terms of Service for acceptable use.