---
title: Google Sheets
description: Learn how to connect and configure Google Sheets connections in Infoveave to access and update spreadsheet data.
---

import { Steps } from '@astrojs/starlight/components';

# Google Sheets

A Google Sheets connection allows Infoveave to securely access your Google Sheets files for retrieving and updating spreadsheet data used in dashboards, workflows, and reports.

## Adding a Google Sheets Connection

To create a new Google Sheets connection:

<Steps>
1. Go to **Administration** > **Connections**
2. Click **New Connection** and select **Google Sheets** from the available connectors
3. In the **New Google Sheets Connection** form, provide the required configuration details
</Steps>

## Connection Parameters

When setting up a Google Sheets connection, provide the following details:

| Field | Description |
|-------|-------------|
| **Name** | A unique name to identify your Google Sheets connection |

Google Sheets uses secure Google OAuth for authentication.

## Authentication

To authenticate your Google Sheets account:

- Click **Connect to Google Sheets**
- Select the Google account that owns or has access to the required spreadsheets
- Grant the necessary permissions for Infoveave to read and update your Google Sheets data

After successful authentication, Infoveave stores the OAuth token securely.

## Steps to Validate and Save

<Steps>
1. Once you complete authentication, click **Validate** to verify the connection
2. If validation is successful, click **Save** to store the connection
3. You can now use the Google Sheets connection as a datasource in your Infoveave dashboards and workflows
</Steps>

## Example Use Cases

With a Google Sheets connection configured, you can:

- Use spreadsheets as Datasources for dashboards  
- Update Sheets automatically through workflows  
- Combine Sheets data with databases, APIs, or analytics sources  
- Build monitoring dashboards using spreadsheet-based KPIs  
- Automate reporting by pulling and pushing data to Sheets  
- Enable business users to manage data directly in Google Sheets while syncing with Infoveave