###### tags: `分享`
slack ID ： Lo
可以叫我 羅 或者 直接連名帶姓叫我 羅章 都可以
連名帶姓的叫我，我一點都不會感到不禮貌, 請放心
---
### 把 google sheet 作為 ###
### Web App 的資料庫使用 ###
---
# [Google App Script](https://developers.google.com/apps-script/) #
* [App script 教學](https://www.minwt.com/pc/22105.html)
---
# Google Sheet API v4
---
# [API discovery document](https://github.com/google/google-api-javascript-client/blob/master/docs/start.md) #
---
1. 建立 **API_KEY**
2. 建立 **Oauth2 CLIENT_ID**
3. 新建 spreadsheet
4. 寫入資料
---
# [Google Api Console](https://console.developers.google.com/)
1. 建立專案
2. 建立 API_KEY
3. 建立 Oauth2 憑證
* [Browser Quickstart](https://developers.google.com/sheets/api/quickstart/js)
---
# Oauth2 登入
---
# [DISCOVERY_DOCS](https://developers.google.com/sheets/api/reference/rest)
https://sheets.googleapis.com/$discovery/rest?version=v4
---
# [SCOPES](https://developers.google.com/sheets/api/guides/authorizing)
https://www.googleapis.com/auth/spreadsheets
---
# 新建 spreadsheet
---
# 寫入資料
---
# 謝謝
{"metaMigratedAt":"2023-06-15T11:26:10.351Z","metaMigratedFrom":"Content","title":"[Google App Script](https://developers.google.com/apps-script/)","breaks":true,"contributors":"[{\"id\":\"111acc36-4797-4d6c-9b0f-ac6f5795c573\",\"add\":2115,\"del\":1067}]"}