Google Sheets API test case. Based on YouTube lesson.
- Create a public Spreadsheet with named scopes
- Copy Spreadsheet ID
- Generate Next.js/Nuxt.js app
- Add googleapis package
- Create Google Cloud Project
- Create Service Account
- Add key, place json-file in root of the Next.js project and add it to .gitignore
- Add variables GOOGLE_APPLICATION_CREDENTIALS and SHEET_ID in .env.local
- Auth and request API
- Render response