Security and data handling

What the connector can reach, what it keeps, and where

A plain-language account of how aPlan4Sheets moves data between Anaplan and Google Sheets, written for the people who review add-ons before a finance team installs them. The Privacy Policy and Terms of Service are the governing documents; this page explains them.

Last reviewed: October 29, 2026

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.

Data flow between Google Sheets, the aPlan4Sheets sidebar and service, Anaplan APIs, and AI providers YOUR GOOGLE WORKSPACE Google Sheet Your workbook. Exports, pivots and refreshes are written here. aPlan4Sheets sidebar Google Apps Script, runs as you. Holds your sign-in, model choices, saved configurations and schedules in Apps Script storage. Time-based triggers run schedules. APLAN4SHEETS GOOGLE CLOUD Connector service App Engine and Cloud Run, us-central1. Builds pivots and formatted grids, runs scheduled refreshes, serves the AI Analyst. Firestore, Cloud Storage, Cloud Logging AI providers Vertex AI (Gemini) for the AI Analyst. Claude handoff: optional pilot, only where a customer configures it. ANAPLAN Anaplan APIs Authentication and regional API endpoints. Your model and data permissions. writes results direct reads with your credentials All connections use HTTPS.

Authentication to Anaplan

What is stored, and where

ItemWhereHow long
Model and workspace selections, saved pivot, view and linked-report configurationsGoogle Apps Script properties for your account and the workbookUntil you remove them in the sidebar
Schedule definitions, connection records and execution leasesWorkbook properties, plus Firestore in the connector's Google Cloud projectUntil you delete the schedule
Authentication state: OAuth tokens, or Basic Auth credentials if chosenYour user-specific Apps Script storage; a separate record per schedule in the connector serviceTokens 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 AnalystCompressed objects in Cloud Storage and capped in-memory caches in the connector serviceCaches live minutes; stored structure is refreshed as the model changes
Cell values from your modelWritten to the Google Sheet you chose; processed in memory by the service for that requestNot 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 diagnosticsFirestore and Cloud Logging in the connector's Google Cloud projectNo 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 itWhy the connector needs it
View and manage spreadsheets that this application has been installed inWrite exports, pivots and refreshes into the workbook where the sidebar is open.
See, edit, create, and delete all your Google Sheets spreadsheetsScheduled 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 appLocate 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 presentThe time-based Google triggers behind scheduled refresh.
Connect to an external serviceCalls 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 applicationsThe sidebar and its dialogs.
Send email as youOptional refresh status notifications that you switch on per schedule. Nothing else is sent.
See your primary Google Account email address, and your basic profileIdentify 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

Transport, hosting and this website

Your controls

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.