When you just need to get a public google sheet as JSON
Install the package locally within you project folder with your package manager:
With npm
:
npm install get-google-sheet
With yarn
:
yarn add get-google-sheet
With pnpm
:
pnpm add get-google-sheet
Scl-AmSE11UHGqOAGs6TmgDpWPm-7Zob9mIb5vq_kb0
and Sheet1
.import { getGoogleSheet } from "get-google-sheet"; export const SHEET_ID = "SHEET_ID"; export const SHEET_NAME = "SHEET_NAME"; const result = await getGoogleSheet(SHEET_ID, SHEET_NAME); console.log(result);
For all configuration options, please see the API docs.
Got an idea for a new feature? Found a bug? Contributions are welcome! Please open up an issue or make a pull request.