About this integration

Integration Summary

Google Sheets is an office application that enables you to create and format online spreadsheets that are accessible from any workstation and that can be modified in real-time by any user with the relevant access rights.

You can then integrate this data in any  app using an Online CSV data source that points to the URL of the Google Sheets spreadsheet, and display it, for example, using a Data Viewer widget. Data will automatically be updated in the  app each time the content is modified in Google Sheets.
 

Notes

• You must have a Google account to be able to use Google Sheets.
• There must not be any empty row or column at the top of the spreadsheet. The first row must contain titles.
              
• In Google Sheets, you can disable an option so that published data is not automatically refreshed. If you do so, the data displayed in the  app will be static.

Procedure: How to integrate a Google Sheets spreadsheet

1. Go to Google Sheets and open the Google Sheets document you want.

• If you have not yet done so, log in using your Google account.
• You can open an existing spreadsheet:
  • Click on the spreadsheet you want in the list of spreadsheets. The document will open.
  • To return to the list of spreadsheets, click  at the top left.
• You can create a new spreadsheet:
  • Click  at the bottom right.
  • Enter data in the spreadsheet.
  • Select File > Rename to rename the spreadsheet.

2. Generate the URL pointing to your online Google Sheets spreadsheet.

• Select File > Publish to the web.
           
• In the Link tab:
  • Click Web page and select the Comma-separated values (.csv) option.
  • If your document contains several sheets, you can publish just one of them. To do so, click Entire Document and select the sheet you want to publish.
• Ensure that your data is constantly refreshed online when you modify your Google Sheets document:
  • Click Published content and settings.
  • Select the Automatically republish when changes are made box.
• Generate the URL pointing to your Google Sheets spreadsheet:
  • Click [ PUBLISH ].
  • Copy the link displayed.
             

3. Go to  and integrate the data from your Google Sheets document in an app.

• Open the app you want.
• Add a dynamic Online CSV data source pointing to the Google Sheets document:
  • In the Objects pane, click . Open the Online category and select the Online CSV data source.
  • Rename the data source so you can easily identify it.
  • Select Content > Base URI and paste the link generated by Google Sheets.
  • Select the Select First Row As Current Record box to indicate that the first row contains column headers.
  • Click [ PREVIEW ] to check the data.
             

• Display the data from the new data source using a Data Viewer widget:
  • In the Objects pane, click . Open the Basic category, then click and drag the Data Viewer widget to the Design pane.
  • Rename the widget so you can easily identify it.
  • Select the data source you previously created from the Content > Data Source drop-down list. The data from the Google Sheets spreadsheet will automatically be displayed.
  • Select the display mode you want using the Content > Default View drop-down list, i.e. Grid (formatted using Theme > Cell Style/Grid Style), Line (formatted using Line properties), or Tile (formatted using Tile properties).   See the description of properties.
  • Complete the form of the record in the Form section.

4. In your  app, check that the data from the Google Sheets document is correctly displayed.

• Click  to switch to preview mode and check the data displayed.
• Check that the data is automatically refreshed:
  • Go to your Google Sheets spreadsheet. Make a modification and exit Google Sheets.
  • Return to your  app. Switch to preview mode and refresh the screen (Note: Some time may be required before the data is refreshed).