json string that can be parsed as a valid JSON object.* allow the value to be empty or an array.+ allow the value to be an array of this type.? if the cell is empty, don't add the attribute (no default value).array.bool JSON encoded array of boolean.įor some of the basic types ( int, float and string), the following wildcard symbols are available:.array.string JSON encoded array of string.array.float JSON encoded array of number.array.int JSON encoded array of integer.empty cell) the attribute is optimized out and removed completely. Note that these values are displayed as TRUE or FALSE in Google Sheet. If a value doesn't match with the type defined, an error is returned in the callback. If no type is specified, the column (or row when spreadsheet is defined as keyvalue) is ignored. The following types can be defined to tell the script how to parse the values in the spreadsheet. Var syncSpreadsheet = require ( 'sync-google-sheet' ) var params = Available types either: clientSecretPath the path to the json file that contain your Google secret key.fileId the file id of the Google sheet you want to download.Npm install sync-google-spreadsheet -save Usage Its file id is: 1tDyLD2f_P2n9etVESzx-_CJdiH1VgXL8B9VYmEVA6pQ Install the library The file id is a 44 characters hash string inside the shareable link.įor instance, consider the spreadsheet at the following address: In the Google sheet you want to export, clic on the SHARE button (top-right corner) and check that it's sharedĪs Anyone with the link can view.

See the 'Usage' section below Prepare the spreadsheet Set the Google Sheet as readable Clic the Create credentials dropdown button and select API keyĬopy and paste the provided string as the apiKey parameter.From the developer console, go to the Credentials menu.(Be carrefull with this secret key, don't commit it in your code!) API Key json file that contain a private key to access documents in your Google drive. select default as Service account, and JSON as Key type.Clic the Create credentials dropdown button and select Service account key.From the same Google developers console, go to the Credentials menu.API Key: Simplier to create and use, but less secure.The library needs one of the following access keys to download the spreadsheet document: Activate the API by clicking the ACTIVATE button.

From your Google developer account, go to the Library menu (left side) and find the Google Sheet API.

Google developers console is at this address: A simple Node-js library to download Sheet from Google Drive and parse it to structured JSON.

Excel google drive sync