Available on Google Workspace Marketplace

Anaplan, meet Google Sheets

The browser-native connector that brings your Anaplan models directly into Google Sheets. Works on Mac, PC, and Chromebook — no Excel required.

Follow the setup guide and narrated walkthroughs from installation to your first refreshed report.

  1. Install
  2. Connect
  3. Add a model
  4. Create a report
  5. Refresh

Want a guided introduction? Request a live demo →

Anaplan moduleGoogle Sheets pivot
The aPlan4Sheets pivot dialog in Google Sheets, with six cost centers selected at Level 2 and dimension cards arranged into Rows, Columns, and Pages.
Build a pivot from an Anaplan moduleChoose a view, move dimensions, and select a hierarchy level.
Try the interactive demo
Product screenshot · Interactive simulation with fictional data · No sign-in
Explore the UX page to Sheet walkthrough →

Formatted UX Pages

From an Anaplan UX page to a formatted Sheet

Start from the page your team already uses in Anaplan. The connector finds the grid, opens it in the pivot window, and writes a formatted sheet you can refresh.

  1. Formatted UX Pages dialog with the Northstar Planning app expanded to its Budget Owner Review page, the page's grid discovered and selected for export
    1Browse UX PagesOpen an app, pick a page, choose Discover modules and select the grid you want. Combined grids keep their shared page filters.
  2. Pivot window opened from the UX page with Cost Center on Rows, Time and Line Items on Columns, and GAAP Basis and Versions on Pages, each shown as a card with its item count and selection badge
    2Export selected gridThe pivot window opens prefilled with the page's rows, columns, page selectors and shown items. Adjust anything before it reaches the sheet.
  3. Illustration of a budget review in Google Sheets with clear blue column headers, page selectors, and grouped cost-center rows
    3Create PivotA formatted sheet with frozen headers, rows grouped by hierarchy, the page selectors and a last-updated stamp.
  4. aPlan4Sheets sidebar with the Formatted UX Pages card expanded, offering Browse UX Pages, Repivot and Link beside the exported budget review
    4Repivot, Link, RefreshReopen the pivot window from the sidebar card, link pivots that share filters, and refresh on demand or on a schedule.

Product screenshots and a sample report illustration · Fictional model and figures · Walk through the UX page export →

The pivot window

Shape the report before it reaches the sheet

Every export opens in the same window, whether it starts from a UX page or a module view. Three controls do most of the work.

Pivot window after dragging the Time card from Columns into Rows: Rows holds Cost Center and Time, Columns holds Line Items, and Pages holds GAAP Basis and Versions; the Item Selector on the left shows the hierarchy levels and the three regions

Dimension cards you can move

Each dimension is a card with its item count and a selection badge. Drag a card between Rows, Columns and Pages and its selection travels with it. Here Time has just moved from Columns into Rows.

  • Click a card to open its Item Selector
  • Page cards can select several items and sum them
  • Add a compatible module beside the first with Add Module
Item Selector for the Cost Center card with Hierarchy Selectors open: All Cost Centers, Level 1, Level 2 and Cost Center, each with Select All, Deselect All and Only This, and Only This applied to Level 2 so 6 of 28 items are selected

Select a whole hierarchy level

Show Hierarchy Selectors lists every level of the list with Select All, Deselect All and Only This. One click isolates the six departments, and the card's badge updates to 6/28.

  • Search the tree, or expand it and tick single items
  • Default, All and None reset the selection
  • Add Formula creates a calculated field next to the line items
Show / Hide column combinations editor: a preview of the nested Time and Line Items columns with fictional values, two occurrences hidden, and a searchable list of the 357 combinations (355 shown) with Show all, Hide all and Apply Show / Hide

Show or hide exact nested occurrences

Nested columns multiply fast. Show / Hide previews the nested grid with live Anaplan values. Click a leaf header, or tick the list, to hide the occurrences you do not want, then apply. It works for rows too, and for each grid region of a combined UX page.

  • Page through the combinations and refresh the preview data
  • Order the occurrences you keep
  • Group rows by hierarchy in the written sheet

Product screenshots · Fictional model and figures · Try the end-to-end pivot workflow → · Try exact nested selections →

Latest workflows · October 2026

Build the report you actually need

Choose exact nested combinations, keep connected views in sync, and reuse your reporting setup across workbooks.

Exact nested selections

Keep different measures under each year instead of every measure repeated under every period. The interactive demo lets you tick the exact occurrences and watch the layout update.

Explore nested selections →

Row and column combinations

Under each zone of the pivot window, choose All or Show / Hide. Preview the nested grid, hide the occurrences you do not need, order the rest, and save the layout for refresh.

One filter, connected reports

Link compatible pivots in the same model so shared page selections stay in sync. Combine compatible module grids in one output.

Reuse your workbook setup

Clone a connected workbook with its saved-view and pivot configurations, then reconnect under the receiving user's own access.

AI Analyst, with a review step

Ask about model structure and data, review the answer, and explicitly export a result to Sheets. The Claude handoff is a pilot that requires a configured Claude connector; availability depends on your environment. It is not unattended Anaplan write-back.

See the illustrative AI workflow →

Your complete Anaplan suite for Google

From natural language queries to executive dashboards — everything your FP&A team needs, right inside Google Sheets and Slides.

Ask in plain English

Query your Anaplan models with natural language. Ask "What were Q1 expenses by department?" and review an answer with model context and results you can export.

Formatted UX Pages

Browse your Anaplan apps and pages, discover the grids on a page, and export one with its formatting, row groups and page selectors intact.

Quick dashboards & slides

Use connected data for Google Sheets charts and Google Slides reporting. Review AI-generated KPIs, findings, and narrative before sharing.

Automated refreshes

Schedule hourly, daily, or weekly refreshes. Refresh connected reports on a recurring cadence, with status and error feedback when a refresh needs attention.

Built for Anaplan power users

Everything you need to work with Anaplan data in Google Sheets.

Saved views & exports

Pull from pre-defined exports, saved views, or default module views — exactly as configured in Anaplan. No manual mapping required.

Powerful pivot engine

Dimension cards you drag between Rows, Columns and Pages, hierarchy level selectors, and Show / Hide for exact nested occurrences, all before the report reaches the sheet.

Anaplan UX formatting

Preserve Anaplan's cell formatting, conditional styling, and summary rows in Sheets. Build dashboards fast — no reformatting from scratch.

Scheduled auto-refresh

Schedule recurring data refreshes and check their status. Google-managed trigger timing is approximate; authentication and source-model availability still apply.

Enterprise AI exploration

Ask about modules, formulas, dependencies, and data using the AI Analyst. Review results before exporting to Sheets; see our Privacy Policy for AI data handling.

Linked configs & cloning

Sync page dimensions across multiple connections via linked configs. Clone existing connections to spin up new views in seconds.

Why aPlan4Sheets

Built for Anaplan teams who live in Google Sheets.

🌐

Works everywhere

Mac, PC, Chromebook — runs entirely in your browser. No desktop software to install.

⚡

Fast & familiar

Pivot, filter, and format Anaplan data directly in Google Sheets. Scheduled auto-refresh keeps data fresh.

👥

Real-time collaboration

Share Anaplan-connected sheets with your team. Collaborators see the shared workbook; connected data updates when its configured refresh runs.

See it in action

Real screenshots of the connector on a fictional model. Try the workflows yourself or follow a narrated walkthrough.

Anaplan and Google Sheets resources

Practical guides for connecting Anaplan models, supporting Mac and Chromebook users, automating reporting, and evaluating Google Sheets workflows.

Now in beta

Explore the beta

aPlan4Sheets is currently in beta. Review the Marketplace listing and setup guide to evaluate the connector.

Frequently asked questions

What is aPlan4Sheets?

aPlan4Sheets is a Google Sheets add-on that connects directly to your Anaplan workspace. It lets you pull Anaplan model data into Google Sheets, configure views and layouts, and refresh data with a single click — all from your browser.

Is aPlan4Sheets in beta?

Yes. aPlan4Sheets is currently in beta and available through the Google Workspace Marketplace for evaluation.

Does it work on Mac?

Yes. Since aPlan4Sheets runs in your browser through Google Sheets, it works on any operating system — macOS, Windows, ChromeOS, and Linux. No virtual machines or workarounds needed.

How do I get started?

Follow the setup guide to install aPlan4Sheets from the Google Workspace Marketplace, connect to Anaplan, and create your first report. Your organization may need to approve installation and configure the OAuth client. You can also preview the steps in the installation walkthrough.

Is my Anaplan data secure?

aPlan4Sheets supports Anaplan OAuth/SSO and Basic Auth, subject to your organization's configuration and permissions. Interactive authentication state is retained in Google Apps Script storage. If you choose Basic Auth, your Anaplan email and password are also retained to authenticate and renew sessions. Schedules can retain separate authentication records in workbook-specific Apps Script storage and the Google-hosted execution service. Google-hosted services process requests and write results to your Sheets over HTTPS. See the Privacy Policy for full storage and retention details, AI processing, and operational usage records.

What Anaplan modules are supported?

Connect accessible Anaplan modules, saved views, exports, and supported UX grid widgets. Configure rows, columns, page selectors, line-item selections, and compatible combined grids. Availability depends on source structure and Anaplan permissions. The workflows shown here retrieve Anaplan data; exporting an AI result to Sheets is not Anaplan model write-back.

Explore the connector

Review the demos and setup guide to see how aPlan4Sheets works inside Google Sheets.