dataconnector
Connect to any API, website or database in Google Sheets. (by brentadamson)
gsheet
gsheet is a CLI tool (and Golang package) for piping csv data to and from Google Sheets (by cristoper)
dataconnector | gsheet | |
---|---|---|
11 | 4 | |
114 | 67 | |
- | - | |
1.6 | 4.0 | |
about 2 years ago | 7 days ago | |
Go | Go | |
Apache License 2.0 | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
dataconnector
Posts with mentions or reviews of dataconnector.
We have used some of these posts to build our list of alternatives
and similar projects.
- 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
gsheet
Posts with mentions or reviews of gsheet.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-18.
-
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
What are some alternatives?
When comparing dataconnector and gsheet you can also consider the following projects:
ImportJSON - Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
csvq - SQL-like query language for csv