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

Question

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?

KD - Ricksoft · Answer

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

Stiltsoft support · Answer

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).

Greg Wollf · Answer

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?