Can you pull specific information from a Google Sheet into a Series of Confluence Pages?

Greg Wollf
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 4, 2024

Here's my situation...

I have been tasked with setting up a section in Confluence that has to do with displaying information about a number of servers we use for work. Each server has 5 relevant fields that need to be displayed. The content for each of these fields exists in a Google Sheet. I need to make it so that the content for these five relevant fields is pulled from the Google Sheet for each server page in Confluence such that when someone edits the content in the spreadsheet the information in the Confluence pages is updated along with it.

What is the best way to do this?

2 answers

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2024

Hi @Greg Wollf ,

We can suggest trying our app - Table Filter, Charts & Spreadsheets for Confluence.

The Table from CSV macro can help you to connect to Google Sheets and display your data as a regular Confluence table. All the changes made to the Google Sheet are passed to your Confluence page.

Furthermore, your table can be filtered, aggregated, and visualized if required.

Greg Wollf
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 4, 2024

Thanks for the suggestion Stiltsoft. Your app sounds lovely and I can see how we could use it for a lot of things, but we're a very small company and can't afford the fancy stuff just yet. Are you aware of any 'vanilla' solutions?

Like Stiltsoft support likes this
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2024

As I know, it can't be done natively.

There is a standard Office Excel macro but it won't support the live synchronization (you just upload your file as an attachment and view it through the macro).

0 votes
Kayd
Contributor
October 10, 2024

Hello Greg, welcome to the community!

If your team has fewer than 10 users on Confluence, you might want to give ScriptRunner for Confluence Cloud a try. It has the capability to call external APIs, including Google Sheets API, which could help you grab specific cell values from your sheets. But you would need to script your way through it.

Here's a helpful resource with an example script to get started: ScriptRunner API Example

Kind Regards 
KD

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events