Google Sheets for Confluence Product Documentation

Take the very first steps to use the Google Sheets app for Confluence.

• Installing the app
• Using the app

Installing the app

You can install the Google Sheets app from the Atlassian Marketplace by clicking the “Try it free” button in the top right corner of the page.

Using the app

Once the app is installed on your Confluence site, you can use it immediately.

On a page, enter edit mode and paste the URL of a Google spreadsheet.

The Google Sheets app renders the file in a few moments and authenticates you with the Google account you’re using in your browser.

You can publish the page immediately or adjust the layout options.

✅ You’ve just learned the fundamentals to use the Google Sheets app.

Learn how to add Google sheets to your Confluence pages.

• About Google spreadsheets
• Adding a Google sheet to your page
• Authentication
• Layout options
• Removing a sheet from your page
• Wrap up

About Google spreadsheets

Google spreadsheets are great for sharing information with your team, and with the Google Sheets app, you have everything in one place and always updated.

1. Expand/collapse preview
2. Show/hide toolbars
3. Advanced editing toolbars
4. Spreadsheet area

Adding a Google sheet to your page

Adding a Google sheet to your page is quite simple:

• Copy the URL from the spreadsheet on the Google Sheets site.
• On your Confluence page, enter edit mode.
• Paste the URL.
• If you aren’t signed in yet, you’ll need to authenticate with your Google account to view the sheet content.
  
  
• [Optional] Select the macro and click the edit button to make adjustments (you can edit this later).
• Publish the changes.

✅ All done. You can now view and edit your sheet on the Confluence page.

Authentication

All users must authenticate with a Google account to view and edit the spreadsheet on Confluence.

Layout options

You can edit the layout options at any moment. Select the macro in the page’s edit mode and click the edit button to change the layout options.

You’re in control of the preview layout of your spreadsheet:

• Width: You can define the width of the spreadsheet preview. The default is 100%.
• Height: You can define the height of the spreadsheet preview.
• Hide preview on load: If enabled, the spreadsheet loads when the page is open, but the preview is hidden. Users can click the chevron to open the preview.
• Show toolbars: If enabled, editing toolbars are shown. Users can click the switch to hide the toolbars.

Layout options for publish mode:

• Show headers: If enabled, column letters and row numbers are shown.
• Show sheet tab: If enabled, the sheet tab is displayed.
• Show interface: If enabled, the title and footer are displayed.

Removing a sheet from your page

To remove a spreadsheet from a page:

• Enter the page edit mode.
• Select the macro of the spreadsheet you want to delete.
• Click the “Delete” button.
  
  
• Publish the changes to the page.

✅ All done. The spreadsheet won’t show anymore on your page, but it’s still safe in Google Drive and you can add it again later if you need.

Wrap up

That’s all about adding and using the Google Sheets app on your pages.

If you still have questions about any topics covered on this page, visit our support portal and send us your questions. Our team is always happy to help.