gsheet
dataconnector
Our great sponsors
| gsheet | dataconnector | |
|---|---|---|
| 4 | 11 | |
| 67 | 114 | |
| - | - | |
| 4.0 | 1.6 | |
| 4 days ago | about 2 years ago | |
| Go | Go | |
| MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
gsheet
-
Query Google Sheets as virtual tables with SQLite extension – libgsqlite
I wrote a little cli[1] that is a bit easier than curl for getting data to and from google sheets as csv. I do think this sqlite extension would be even more convenient if it supported writing data with INSERT/UPDATE.
1: https://github.com/cristoper/gsheet
-
googlesheetsparser - a library for dynamically parsing google sheets into golang structs
I maintain several Go programs that mostly just copy data from google sheets, process it, then upload it back to a google sheet. My current approach is to parse the sheets as CSV, then serialize it back as CSV (I'm the author of cristoper/gsheet), but the idea of parsing it directly to Go structs is interesting.
- gsheet is a CLI tool (and Golang package) for piping csv data to and from Google Sheets
- gsheet is a cli tool for piping csv data to and from Google Sheets
dataconnector
- dataconnector: NEW Data - star count:100.0
-
Data studio connector
I haven't looked at Data Studio in particular but for Google Analytics and other Google data sources you have to use OAuth2 so I'm guessing Data Studio would be the same. There's an OAuth2 library for apps script and you can see how we used it in our code (using React): https://github.com/brentadamson/dataconnector
- Data Connector - Connect to any API in Google Sheets. Backend is written in Go. Sheets Add-on written in React.
- Connect to any API in Google Sheets
What are some alternatives?
csvq - SQL-like query language for csv
ImportJSON - Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
trdsql - CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
disgoauth - Easy-to-use Discord OAuth2.0 Implementation for Go
octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
fosite - Extensible security first OAuth 2.0 and OpenID Connect SDK for Go.
drive - Google Drive client for the commandline
bgg-hotness - Track BGG Hotness in google sheet
rclone - "rsync for cloud storage" - Google Drive, S3, Dropbox, Backblaze B2, One Drive, Swift, Hubic, Wasabi, Google Cloud Storage, Azure Blob, Azure Files, Yandex Files
fastschema - A simple and schema-based headless CMS
googlesheetsparser - googlesheetsparser is a library for dynamically parsing Google Sheets into Golang structs.
oidc - Easy to use OpenID Connect client and server library written for Go and certified by the OpenID Foundation