The Live Table from Google Sheets macro allows you to output a table from a Google Sheets data source.

Connecting Live Tables with Google

1. Open Google Cloud console https://console.cloud.google.com/.

2. Open a project picker.


3. Create a new project.

4. Switch to the APIs & Services section from the created project.

5. Open the Enabled APIs & services section.6. Click the Enable APIs and services button.

7. Search Google Sheets API in API Library and click Enable.

8. Add more APIs to extend the app’s functionality:

  • Google Drive API
  • Google Forms API
  • Google Calendar API
  • Google Analytics Data API
  • Google Analytics Admin API.

9. Click OAuth consent screen in the APIs & Services section.

10. Choose Data Access → Add or remove scopes.

11. Copy the following scopes:

https://www.googleapis.com/auth/userinfo.profile,

https://www.googleapis.com/auth/userinfo.email,

https://www.googleapis.com/auth/spreadsheets.readonly,

https://www.googleapis.com/auth/drive.readonly,

https://www.googleapis.com/auth/forms.responses.readonly,

https://www.googleapis.com/auth/forms.responses.readonly,

https://www.googleapis.com/auth/calendar.readonly,

https://www.googleapis.com/auth/analytics.readonly
CODE


12. Click Add to table → Update

13. Copy Callback URL from Confluence Administration → Apps → Live Tables → Google → Callback URL. 

14. Switch to the Clients tab in the the Google Auth Platform section in Google Cloud:

  • Choose Application type: Web application
  • Add a Client name

15. Paste Callback URL in the Authorized redirect URLs.

16. Create OAuth client ID.

17. Copy Client ID and Client secret.

18. Paste in Confluence Administration → Apps → Live Tables → Google

19. Save Google OAuth configuration.

Using the Live Table from Google Sheets macro 

Add the Live Table from Google Sheets macro on a Confluence page:

1. Paste the URL of your Google Sheet. It will automatically be converted into the macro.

2. Or insert the macro on a page:

  • Start entering /Live Table from Google Sheets, select the macro.
  • Or, in the editor pane, click Insert elements -> View more, find the macro, and insert it on the page.
  • Insert the Google Sheets URL.

3. Click the Connect Google button once Google OAuth is configured.

4. Allow the app access to your Google account once. 

5. Publish the page.

The tables generated by the macro in Confluence automatically update to reflect changes in the connected Google Sheet.

Check the current user connections and permissons via the Apps → Live Tables → Your permissions.

Working with the table

The table shows the file data available to the viewer when the macro loads.

To filter data, create charts, or process the table, combine the Live Table from Google Sheets macro with Table Filter, Charts & Spreadsheets macros.

Use Table Toolbox to nest the macros.To edit and analyze the table data in a spreadsheet, use Spreadsheet from Table.