Security News
tea.xyz Spam Plagues npm and RubyGems Package Registries
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
gsjson
Advanced tools
Readme
A simple Node.js command-line tool to export Google Spreadsheets to JSON files.
npm install -g google-spreadsheet-to-json
> gsjson --help
Usage: gsjson <spreadsheet-id> <file> [options]
Options:
-h, --help output usage information
-V, --version output the version number
-u, --user [user] User to login
-p, --password [password] Password to login
-t, --token [token] Auth token acquired externally
-y, --tokentype [tokentype] Type of the informed token (defaults to Bearer)
-w, --worksheet <n> Worksheet index
-c, --hash [column] Column to hash the final JSON
-i, --vertical Use the first column as header
-l, --list-only Ignore headers and just list the values in arrays
-b, --beautify Beautify final JSON
A spreadsheet ID can be extracted from its URL.
gsjson abc123456789 data.json
gsjson abc123456789 data.json -t authtoken
Since Google now enforces OAuth 2.0, this module offers an argument for the auth token. One of the methods to acquire a temporary token:
Public spreadsheets can only be used without authentication if the option "File > Publish to the web" is used in the Google Spreadsheets GUI, even if the spreadsheet is visible to everyone. This problem won't occur when authenticated.
Id | Name | Age | Newsletter |
---|---|---|---|
1 | Joisse Wendell | 25 | TRUE |
2 | Brand Katelin | 16 | FALSE |
3 | Gloriana Goldie | TRUE |
Command:
gsjson abc123456789 data.json -b
Output:
[
{
"id": 1,
"name": "Joisse Wendell",
"age": 25,
"newsletter": true
},
{
"id": 2,
"name": "Brand Katelin",
"age": 16,
"newsletter": false
},
{
"id": 3,
"name": "Gloriana Goldie",
"newsletter": true
}
]
Id | Name | Age | Newsletter |
---|---|---|---|
1 | Joisse Wendell | 25 | TRUE |
2 | Brand Katelin | 16 | FALSE |
3 | Gloriana Goldie | TRUE |
Command:
gsjson abc123456789 data.json -b -c id
Output:
{
"1": {
"id": 1,
"name": "Joisse Wendell",
"age": 25,
"newsletter": true
},
"2": {
"id": 2,
"name": "Brand Katelin",
"age": 16,
"newsletter": false
},
"3": {
"id": 3,
"name": "Gloriana Goldie",
"newsletter": true
}
}
Id | Name | Age | Newsletter |
---|---|---|---|
1 | Joisse Wendell | 25 | TRUE |
2 | Brand Katelin | 16 | FALSE |
3 | Gloriana Goldie | TRUE |
Command:
gsjson abc123456789 data.json -b -l
Output:
[
[
1,
"Joisse Wendell",
25,
true
],
[
2,
"Brand Katelin",
16,
false
],
[
3,
"Gloriana Goldie",
null,
true
]
]
Id | 1 | 2 | 3 |
---|---|---|---|
Name | Joisse Wendell | Brand Katelin | Gloriana Goldie |
Age | 25 | 16 | |
Newsletter | TRUE | FALSE | TRUE |
Command:
gsjson abc123456789 data.json -i
Output:
[{"id":1,"name":"Joisse Wendell","age":25,"newsletter":true},{"id":2,"name":"Brand Katelin","age":16,"newsletter":false},{"id":3,"name":"Gloriana Goldie","newsletter":true}]
google-spreadsheet-to-json is free and unencumbered public domain software. For more information, see the accompanying UNLICENSE file.
FAQs
A simple command-line tool to export Google Spreadsheets to JSON files
The npm package gsjson receives a total of 2 weekly downloads. As such, gsjson popularity was classified as not popular.
We found that gsjson demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Tea.xyz, a crypto project aimed at rewarding open source contributions, is once again facing backlash due to an influx of spam packages flooding public package registries.
Security News
As cyber threats become more autonomous, AI-powered defenses are crucial for businesses to stay ahead of attackers who can exploit software vulnerabilities at scale.
Security News
UnitedHealth Group disclosed that the ransomware attack on Change Healthcare compromised protected health information for millions in the U.S., with estimated costs to the company expected to reach $1 billion.