The Google Workspace Sheets data provider in PADS4 allows you to connect to a Google Sheet and retrieve real-time spreadsheet data for digital signage.

​
Steps to Add/Modify a Google Workspace Sheets Connection in PADS4

​
1. Start the Data Provider Wizard

  • Open the Data Provider Wizard following the steps in Adding a Data Provider or Editing a Data Provider.
  • Select Google Workspace Sheets as the provider type.

​
2. Authenticate with Google Workspace

  • Click Authentication to open a web browser.
  • Log in to your Google Workspace account.
  • Grant PADS4 access to retrieve Google Sheets data.
If your network requires a proxy server, configure the Proxy Server settings for authentication. Click Next to proceed.

​
3. Select a Google Sheets File

  • Choose the Google Sheets file from which you want to retrieve data.
  • Select the specific Sheet (tab) inside the file.
  • Optionally, specify the column and data range to pull only relevant data.
  • Click Preview to check how the data will be displayed.
Click Next to proceed.

​
4. Complete the Setup

  • Click Finish to finalize the Google Workspace Sheets connection.
  • The PADS4 Viewer will now retrieve real-time spreadsheet data for display.

​
Important Considerations

  • Ensure Internet Access:
    • If using a PADS4 Data Server, ensure that Google Sheets API is accessible from the server.
    • If not using a Data Server, each PADS4 Designer and Viewer must have direct internet access.
  • Google Workspace Permissions:
    • The authenticated user must have sufficient access to view the Google Sheet.
  • Data Filtering:
    • Specify a data range to limit the number of rows retrieved.
  • Preview Function:
    • Use Preview to verify how the data will be structured before finalizing the connection.
By completing these steps, you can successfully integrate Google Workspace Sheets with PADS4 to display live spreadsheet data dynamically.