# Sheets API

## Quick Start
- https://developers.google.com/sheets/api/quickstart/nodejs
- credentials.json
- get token.json
- Sample: https://github.com/kenu/oksheets

## google spreadsheet Module
```
npm i google-spreadsheet --save
```
- Create Google Service Account
  - https://console.cloud.google.com/apis/credentials
  - select `APIs & Services` > `Credentials` (`API 및 서비스` > `사용자 인증 정보`)
  - Click blue `+ CREATE CREDENITALS` and select `Service account` option
  - Enter name, description, click `CREATE`
  - You can skip permissions, click `CONTINUE`
  - Click `+ CREATE KEY` button
  - Select the `JSON` key type option
  - Click `Create` button
  - your JSON key file is generated and downloaded to your machine (it is the only copy!)
  - click `DONE`
  - note your service account's email address (also available in the JSON key file)

- Add Service Account email to SpreadSheets permission list

## ref
- Reading & Writing Cell Values
  - https://developers.google.com/sheets/api/guides/values#node.js_4
- Writing to Google Sheets using Node JS
  - https://blog.peterplucinski.com/writing-to-google-sheets-using-node/
- npm google spreadsheet
  - https://www.npmjs.com/package/google-spreadsheet