googledocs2json

1.0.1 • Public • Published

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"
}

alt tag

Readme

Keywords

Package Sidebar

Install

npm i googledocs2json

Weekly Downloads

2

Version

1.0.1

License

ISC

Last publish

Collaborators

  • fisshy