The Omnata Google Sheets Plugin now syncs entire folders

The Omnata Google Sheets Plugin has always supported bi-directional sync between individual Google Sheets and Snowflake. It now supports syncing multiple sheets from a Google Drive folder at once, using a filename pattern to control which files are included — the same multi-file capability already available in the Omnata MS Excel Plugin.

Two ways to use it

Sync a single sheet. Point the plugin at a specific Google Sheet in Drive, map it to a Snowflake table or view, and set a schedule. Push Snowflake data out to the sheet, ingest from it back into Snowflake, or both. Useful for reports your finance or ops team maintain in Sheets, or any file that needs to stay in sync with your warehouse.

Sync a folder of sheets. If you receive regular data files as Google Sheets — from a supplier, a third party, or an internal team — point the plugin at a Drive folder and specify a filename pattern. It will ingest every matching file it finds there automatically, without manual uploads or one-by-one configuration. The filename pattern means you can be selective: pull in only the files that match a naming convention, and ignore everything else in the folder.

The Google Sheets Plugin is free, and runs on your existing warehouse

The plugin is free on the Snowflake Marketplace. The only cost is the Snowflake warehouse compute used when a sync runs — and Omnata is efficient enough that an XS warehouse is more than sufficient. Syncs run inside your existing Snowflake account and can share a warehouse with other workloads without contention, so there's no need to provision anything separately.

Compare that to the alternatives — Google Cloud Dataflow, external SaaS integration tools, or a custom Apps Script export. All of them add either tool cost, infrastructure overhead, or both. Because Omnata runs as a true Native App inside your Snowflake account, your data never leaves your environment and there's nothing to stand up or maintain outside of it.

Get started now

Available free on the Snowflake Marketplace. Requires Omnata Sync (free core listing) and files hosted in Google Drive.

Documentation · Marketplace listing