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:

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

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

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

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