> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pads4.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting to Google Workspace Sheets

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.