googledocs2json

Googledocs to JSON

• One simple way to sync google rows/columns values to key/value JSON.
• First row is one column for each file
• First column is key for each value.

Install

$ npm install -g googledocs2json

Authorization / Config

Authorization is done using OAuth2, please get your client/secret key at https://console.developers.google.com,

Select your project -> Credentials -> Create Credentials -> OAuth client ID. Download the JSON-file and rename it to config.creds.json

config.creds.json

Save this file to the folder you want to generate the files in.

{
    "installed":
    {
        "client_id":"your_client_id",
        "project_id":"your_projectId",
        "auth_uri":"https://accounts.google.com/o/oauth2/auth",
        "token_uri":"https://accounts.google.com/o/oauth2/token",
        "auth_provider_x509_cert_url":"https://www.googleapis.com/oauth2/v1/certs",
        "client_secret":"your_secret_key",
        "redirect_uris":["urn:ietf:wg:oauth:2.0:oob","http://localhost"]
    },
    "spreadsheet_key" : "your spreadsheet key"
}

config.generate.json

Create this file in the folder you want to generate the files in.

• Range -> See Google Spreadsheet API v4 for more info.

{
  "range": "Sheet1!A1:C"
}

config.token.json

Stores your token after authentication

Example

Input

Key	en.json	sv.json
Car expenses	Cost for passenger cars	Personbilskostnader
Computers, advertisement and PR	Advertising and PR	Reklam och PR
Building costs	Property Cost	Fastighetskostnader
Freight and transport	Freight and transport	Frakter och transporter
Supplies and inventory	Consumable equipment and supplies	Förbrukningsmaterial och Förbrukningsinventarier

Run

$ g2j

Output

Two files were created. en.json and sv.json

{
  "Car expenses":"Cost for passenger cars",
  "Computers, advertisement and PR":"Advertising and PR",
  "Building costs":"Property Cost",
  "Freight and transport":"Freight and transport",
  "Supplies and inventory":"Consumable equipment and supplies"
}