Omnata Google Sheets Plugin

# About this connector

Use this connector to ingest data from, and push data to, Google Sheets.

Also included with the app are live-query [functions](https://docs.omnata.com/omnata-product-documentation/omnata-sync-for-snowflake/apps/google_sheets#functions) to interact with Google Sheets from notebooks and worksheets utilising the existing Omnata connection.

# **About Omnata**

Omnata is a bi-directional integration app for syncing data to and from SaaS endpoints and databases.

Omnata runs inside your account leveraging external access to connect directly to endpoints. We don’t handle your data or credentials in any external infrastructure.

**Value of our approach**

- Lower the cost of integration with no data volume charges
- Simplify your integration architecture with one app for both sync-directions
- A superior architecture for cyber-security conscious customers

**App features**

- Manage many apps, connections and syncs in one central location.
- A rich admin UI to understand sync status, trace record-level activity history, and troubleshoot errors.
- Fine-grained controls to optimize API and workload performance
- Git-style config branching and dbt integration.

## To get started with Omnata

1. Install the [Omnata Sync Engine](https://app.snowflake.com/marketplace/listing/GZSUZ13JOEUG/omnata-omnata-sync-engine) (free listing)
2. Install the Omnata Plugin for each SaaS apps you want to connect to

This plugin is for Google Sheets and is a free plugin that is built, maintained and supported by Omnata.

The product UI will step you through app installation, connecting to your app and creating syncs. You can also [visit our docs](https://docs.omnata.com/omnata-product-documentation/omnata-sync-for-snowflake/step-by-step-guides) for a step-by-step guide.

**Omnata plugin features**<br/>• Supports inbound and outbound data syncs.<br/>• Direct connect from Snowflake with no outside infrastructure.

**App specific features**

• You connect to Google Sheets using OAuth and your own credentials or a service account.

**Availability**

This plugin is Generally Available in all regions.

搜集汇总

背景与挑战

背景概述

该数据集描述了Omnata Google Sheets Plugin，一个支持Google Sheets数据双向同步和实时查询的免费插件，可直接与Snowflake连接。插件通过OAuth认证使用用户凭证或服务账户，提供丰富的管理功能和细粒度控制，适用于所有区域。