/
Google Sheets for Confluence – Quick Start

Google Sheets for Confluence – Quick Start

Google Sheets for Confluence is an app that lets you embed live spreadsheets and reports directly into your pages. Instead of static attachments, teams get dynamic content that stays visible, updated, and connected to their documentation.

It's built for teams tired of switching tabs. Project managers, analysts, and IT admins get real-time dashboards and secure data without leaving their workspace. The Confluence Google Sheets integration means less jumping around, quicker decisions, and collaboration that actually flows.

Setup is straightforward. It takes just a few steps to configure, data refreshes automatically, and access controls meet enterprise security standards. For organizations looking to embed Google Sheets in Confluence, it's the most effective way to streamline reporting and improve teamwork without forcing people to work differently.

How to embed Google Sheets in a Confluence page

gsheets confluence hero.mp4

 

Auto mode

  1. Copy the public URL address of your Google Sheets file

  2. Paste it into your Confluence editor

  3. (Optional) Edit the viewer settings

Manual mode

  1. Copy the URL address of your Google Sheets file

  2. Open the Google Sheets macro in Confluence typing /sheets

  3. Paste the URL of the file into the corresponding section

  4. (Optional) Edit the viewer settings

The recommended minimum width is 1350 px. You should set your Confluence page to full width since fixed width is 760px.

If you click on the Google Sheets icon in the embedded viewer, the application may crash. Please refresh your browser page if this occurs. We are aware of this issue but since it is caused by a limitation of the Google platform it can’t be fixed at the moment.

Advanced options

Tab gid

Each tab in your published Google Sheets has a gid, visible in the tab’s URL:

https://docs.google.com/spreadsheets/d/e/.../pubhtml#gid=XXXXXXXXXX

The first tab usually has gid=0, which is the default option in Google Sheets for Confluence, but you can override it by pasting the gid identifier of the tab you want to show as default tab.

image-20260714-144343.png


Cell range

In your Google Sheets, highlight the cells you want to limit the embed to. The exact range will be displayed in the upper-left corner of the spreadsheet (in the example, D2:F6).

image-20260714-143211.png

In Google Sheets for Confluence, open the app’s settings and enter the cell range in the dedicated section and confirm.

With standard Google Sheets share URLs, the defined cell range will be highlighted by default.

image-20260714-145025.png
Standard mode

With publish mode URLs, the embedded view will be limited to the defined range.

image-20260714-145158.png
Publish mode


Publish mode only options

When embedding a Google Sheets spreadsheet in Publish mode, you can select additional options, each one letting you show/hide parts of the published spreadsheets UI.

image-20260714-145350.png

 

FAQ

  1. What is Google Sheets for Confluence?

Google Sheets for Confluence is a plugin that allows you to embed live Google spreadsheets directly into Confluence pages. Unlike static attachments, the content stays updated in real time, enabling better reporting and collaboration.

 

  1. How do I embed a Google Sheet in a Confluence page?

You can use two modes:

  • Auto mode: paste the public Google Sheets URL directly into your Confluence page.

  • Manual mode: open the “Google Sheets” macro (/sheets), paste your file URL, and configure display options.

 

  1. Can I control what parts of the spreadsheet are visible?

Yes. Advanced options let you toggle sheet navigation (Widget), row/column headers, and the spreadsheet’s title/footer (Chrome).

 

  1. Do I need special permissions to use the app?

You need at least viewing rights on the Google Sheet. Access controls follow enterprise security standards, so only authorized users can see the data.

 

  1. Does the spreadsheet update automatically in Confluence?

Yes. The embedded sheet refreshes automatically and always reflects the latest data from Google Sheets.

 

  1. What happens if the embedded viewer crashes?

If you click the Google Sheets icon inside the embedded viewer, the application may crash due to a Google limitation. Simply refresh your browser page to restore functionality.

 

  1. Is there a recommended page layout for embedding Google Sheets?

Yes. We recommend setting your Confluence page to full width for best readability. The minimum width for embedded sheets is 1350px.

 

  1. Can I embed multiple Google Sheets in one Confluence page?

Yes. You can add as many sheets as needed, each with its own macro or pasted URL.

 

  1. Is my data secure when embedding Google Sheets in Confluence?

Yes. Data access respects Google’s native security and your Confluence permissions. Presago follows strict enterprise security practices .