Install from Google Workspace Marketplace
Add aPlan4Sheets to your Google Sheets in one click.
aPlan4Sheets is a Google Sheets add-on available on the Google Workspace Marketplace. It installs directly into your Google Sheets — no desktop software, no downloads, no IT tickets.
- Visit the aPlan4Sheets Marketplace listing
- Click "Install" and grant the required permissions
- Open any Google Sheet — the add-on is now available
Google Workspace Admin? You can install aPlan4Sheets domain-wide from the Admin Console, so every user in your organization has access automatically.
Open the Sidebar
Launch the aPlan4Sheets interface inside Google Sheets.
Once installed, the connector lives in your Extensions menu. Open it to reveal the sidebar where all the magic happens.
- Open any Google Sheet
- Go to Extensions → Anaplan Connector for Sheets™ → Open Sidebar
- The aPlan4Sheets sidebar will appear on the right side of your spreadsheet
Tip: The sidebar will remember your last session. If you've previously logged in, you may already be connected when you reopen it.
Connect to Anaplan
Authenticate with your Anaplan account — two options available.
aPlan4Sheets supports two authentication methods. Choose the one that matches your organization's Anaplan setup.
Option A: OAuth / SSO
Best for organizations using Anaplan SSO (single sign-on). This is the most secure method — your credentials are never stored by the add-on.
- Click the "Login with Anaplan SSO" button in the sidebar
- A popup window will open — complete your organization's SSO login
- After successful authentication, the popup closes automatically
- You'll see "Authentication Successful" in the sidebar
Option B: Email & Password
For Anaplan accounts that use direct email/password authentication (no SSO configured).
- Enter your Anaplan email address in the email field
- Enter your Anaplan password
- Click "Login"
- You'll see a confirmation that you're connected
Security note: aPlan4Sheets never stores your credentials on external servers. All authentication uses Anaplan's official API, and tokens are stored securely in your browser session.
Configure Your Model
Select which Anaplan workspace and model to connect.
After logging in, you'll need to add at least one Anaplan model to start working with data.
- Click the "Add Model" button in the sidebar
- Select your Workspace from the dropdown — all workspaces you have access to will appear
- Select the Model from the second dropdown
- Click "Save" to add the model to your configuration
Multi-model support: You can add multiple models from different workspaces. This is great for teams that pull data from several Anaplan models into a single reporting sheet. Just repeat the steps above for each model.
Create Your First Pivot
Pull Anaplan data into a custom pivot layout.
The Pivot feature lets you pull data from any Anaplan module view and arrange dimensions exactly how you need them — rows, columns, and page filters.
- Navigate to the "Pivot" tab in the sidebar
- Search or browse the available modules in your connected model
- Select a saved view (or use the default view) and click "Configure"
- Drag dimensions to arrange them:
- Rows — dimensions that appear as row headers
- Columns — dimensions that appear as column headers
- Pages — dimensions used as filters (select specific items)
- Select items for each page dimension to filter your data
- Click "Execute" to pull the data into your sheet
Tip: The pivot layout mirrors what you'd see in Anaplan's own UI. If you've used page selectors in Anaplan, you'll feel right at home.
Export Anaplan Views
Pull pre-configured Anaplan exports directly into Sheets.
If your Anaplan model has pre-defined export actions, you can run them directly from Google Sheets and land the output in your spreadsheet.
- Switch to the "Exports" tab in the sidebar
- Click "Fetch" to load the available export definitions from your model
- Select the export you want to run from the list
- Click "Export" to execute it and pull the data into your sheet
Tip: Exports use the same definitions configured by your Anaplan model builder. Great for standard reports that don't need custom pivot layouts.
Refresh Your Data
Update all your configured sheets with fresh Anaplan data.
Once you've set up your pivot views and exports, you can refresh everything at once — no need to reconfigure each connection.
- Use the "Refresh Sheets" feature in the sidebar
- All configured connections in the current spreadsheet will re-pull data from Anaplan
- Your data updates in place — formatting and formulas you've added around the data are preserved
Auto-refresh: Enterprise users can schedule automatic refreshes so reports are always up to date — no manual clicks required. Contact us to learn more.
Tips & Troubleshooting
Common questions and quick fixes.
Session expired / token error
Anaplan authentication tokens expire after a period of inactivity. If you see an authentication error, simply log in again using the same method (SSO or email/password). Your configurations are preserved — you won't lose any setup.
"Unverified app" warning screen
When first authorizing the add-on, Google may show an "unverified app" warning. This is normal during the verification process. Click "Advanced" at the bottom left, then click "Go to Anaplan Connector for Sheets™ (unsafe)" to proceed. The app is safe — this screen appears for all new Workspace add-ons.
Slow first load
The first time you open the sidebar or load a model's modules, it may take a few extra seconds. This is normal — aPlan4Sheets is fetching metadata from Anaplan's API. Subsequent loads will be faster as the data is cached locally.
Need help?
Can't find what you need? Contact our team — we typically respond within one business day and can help with setup, configuration, or any issues you encounter.