The width: We’d like to have the Google sheet be full width.There are 3 things that I would like to address. You will be presented with a layout that looks like the image below. Once the sheet is successfully presented in the preview window save your macro, then save the parent Confluence page. If you can see the Google sheet preview, Great! Don’t worry about how small the sheet is being presented, we’ll fix that shortly. If you’re not seeing the preview, firstly check that you have copied across the full URL, secondly check that you have permissions to view the actual Google sheet. Once you have pasted in the URL, click the “Preview” option to see a preview of your Google sheet and ensure that the sheet is being pulled in correctly. Once in the edit mode of your Confluence page, edit the iFrame macro and paste in the URL of your Google sheet into the URL field of the macro window. If you don’t see the option, you may need to speak with you Confluence administrator to see if the macro is available, or whether you can install an additional macro such as Bob Swift’s HTML macro to do the trick. If your see the ‘iFrame’ macro option, select it. Add in the required iFrame macroįrom the macro’s dialogue box, search for “iFrame” in the top right-hand corner of the modal window. If you haven’t already created a dedicated page to house your Google sheet, go ahead and create one. Create your page that will house your Google Sheet Once the add-on is installed, the process outlined below is the same for either route. However, if you don’t have this macro available, then I encourage you to look for an alternative add-on. This tutorial will focus only on using Confluence’s iFrame macro. To circumvent this issue I used Bob Swift’s HTML macro to achieve the desired result. However, I have seen older self-hosted versions of Confluence which didn’t include the ‘iFrame Macro’. The reason I am pointing this out is, the macro that allows us to embed a Google Sheet into a Confluence page is call the ‘iFrame’ macro. In this tutorial, I will be using Atlassian’s cloud hosted version of Confluence. Once we have gone through the steps discussed below, we’ll have a layout that looks like the following. The Goal: To embed a Google Sheet into a Confluence page It’s an estimate for a fictitious digital product.
I know right, amazing!įor this tutorial, I am going to be working with the following Google sheet. That’s right edit Google Sheets right within Confluence. Hi, thanks for popping by! In this post, I am going to show you how to work with Google sheets right within Confluence.
0 kommentar(er)
