{"repo":"turbot/steampipe-plugin-googlesheets","free":true,"listed":false,"github":"https://github.com/turbot/steampipe-plugin-googlesheets","clone":"git clone https://github.com/turbot/steampipe-plugin-googlesheets.git","description":"Use SQL to instantly query spreadsheets, sheets, and cell data from Google Sheets. Open source CLI. No DB required.","language":"Go","stars":31,"topics":["steampipe","steampipe-plugin","postgresql","postgresql-fdw","googlesheets","googlesheetsapi","hacktoberfest","sql","backup","etl"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Google Sheets Plugin for Steampipe Use SQL to query data from Google Sheets. - Get started → - Documentation: Table definitions & examples - Community: Join #steampipe on Slack → - Get involved: Issues Quick start Install the plugin with Steampipe: Configure your credentials and config file. Run steampipe: Query all the sheets in your spreadsheet: A table is automatically created to represent each sheet mentioned in the configured sheets config argument. For instance, if using the following configuration: To get details for a specific table, inspect it by name: You can query data from the Students sheet using the sheet's column names: You can also query data from a sheet by cell address: Engines This plugin is available for the following engines: Engine Description --------------- ------------------------------------------ Steampipe The Steampipe CLI exposes APIs and services as a high-performance relational database, giving you the ability to write SQL-based queries to explore dynamic data. Mods extend Steampipe's capabilities with dashboards, reports, and controls built with simple HCL. The Steampipe CLI is a turnkey solution that includes its own Postgres database, plugin management, and mod support. Postgres FDW Steampipe Postgres FDWs are native Postgres Foreign Data Wrappers that translate APIs to foreign tables. Unlike Steampipe CLI, which ships with its own Postgres server instance, the Steampipe Postgres FDWs can be installed in any supported Postgres database versio","default_branch":null,"files":null,"tree":[],"storefront":"/r/turbot","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/turbot/steampipe-plugin-googlesheets/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}