Save your Google Spreadsheets as CSV or JSON.
npm install grunt-gss> Save your Google Spreadsheets as CSV or JSON.
~0.4.0If you haven't used Grunt before, be sure to check out the Getting Started guide, as it explains how to create a Gruntfile as well as install and use Grunt plugins. Once you're familiar with that process, you may install this plugin with this command:
``shell`
npm install grunt-gss --save-dev
Once the plugin has been installed, it may be enabled inside your Gruntfile with this line of JavaScript:
`js`
grunt.loadNpmTasks('grunt-gss');
and clientSecret
$3
1. Check out demo file here.
2. and gid could be found in the URL of your spreadsheet
3. Do it as usual under File > Share
4. Without proper permission set, you will get a File not found error from Google
$3
1. clientId and clientSecret are from your Google API key
* json set true to save as JSON, otherwise raw CSV is saved
* prettify works for JSON format only, 2 spaces indention
* ~~typeDetection apply one of these: parseInt, parseFloat, or split(',')~~ Removed since v1.0.0
* an object containing col:type mappings. Possible types are:
* array - split(",")
* number -
* string -
* undefined -
* or a callback function accepting and returning whatever can be parsed by JSON.parse
* output string will be passed to this callback and the return will be saved~~Note 1: If both typeDetection and typeMapping are true, typeDetection will be executed first, and followed by typeMapping overriding the outcome. That is, value passing totypeMapping callback may not be string.~~
Removed since v1.0.0~~Note 2: It a col of typeMapping is not found in the CSV at all, and type is a callback funtion, it will be called with (rowObj), and save to output if return value is not undefined.~~
#### The Task
Demo is setup with this sheets.
coffeescript
gss:
example:
options:
# from your Google API key
clientId: '785010223027.apps.googleusercontent.com'
clientSecret: 'nwQ2UedRysgbNZl6jE3I77Ji'
json: true # json or csv
prettify: true # available if options.json
files: [
options:
mapping: # available if options.json
col1: 'array'
col2: 'number'
col3: 'string'
col4: 'undefined'
col5: (val, row) ->
# 2d array
val.split('|').map (v) -> v.split ','
colNotExist: (val, row) ->
# val is undefined, and since this is the LAST mapping entry,
# the row obj passed in has already been converted accordingly
# {col1:["1","2"],col2:123,col3:"string",col5:[["1a","1b"],["2a","2b"]]}
JSON.stringify row
wrap: (out) ->
# grunt.log.error out
out
dest: 'test/Sheet1.json'
src: 'https://docs.google.com/spreadsheets/d/18DpYlL7ey3OTbXnTeDl82wD4ISq6iU2Gv5wCQjJsMuQ/edit#gid=1428256717'
,
options:
# if false, all other options will be ignored
json: false
dest: 'test/Sheet2.csv'
src: 'https://docs.google.com/spreadsheets/d/18DpYlL7ey3OTbXnTeDl82wD4ISq6iU2Gv5wCQjJsMuQ/edit#gid=1369557937'
]
`#### Output Sheet1.json
javascript
[
{
"col1": [
"1",
"2"
],
"col2": 123,
"col3": "string",
"col5": [
[
"1a",
"1b"
],
[
"2a",
"2b"
]
],
"colNotExist": "{\"col1\":[\"1\",\"2\"],\"col2\":123,\"col3\":\"string\",\"col5\":[[\"1a\",\"1b\"],[\"2a\",\"2b\"]]}"
},
{
"col1": [
"element1",
"element2"
],
"col2": 24.777,
"col3": "string2222",
"col5": [
[
"3",
"4"
]
],
"colNotExist": "{\"col1\":[\"element1\",\"element2\"],\"col2\":24.777,\"col3\":\"string2222\",\"col5\":[[\"3\",\"4\"]]}"
}
]
`#### Output Sheet1.json
csv
col1,col2,col3,col4
234,sheet,yes,no
`
Release History
* 2014-08-05 v1.0.4 Set 0 as number default instead of null
* 2014-08-04 v1.0.3 Migrate to new
and refactor
* 2014-07-24 v0.6.0 Add option "wrap" to process output before save, and pull request #3
* 2014-07-19 v0.5.1 Create col on the go by type` callback