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?
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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.