@itsravenous/google-sheets-public

2.0.0 • Public • Published

@itsravenous/google-sheets-public

Simple, zero-dependency package for fetching data from public Google sheets.

Installation

npm i @itsravenous/google-sheets-public

Setting up a public Google sheet

  1. Create an account at https://developers.google.com/
  2. Go to your Google Developer Console dashboard and click "Enable APIs and Services". Select Google Sheets.
  3. Go to the Credentials section of your account and create an API key. Note it down.
  4. Create a Google sheet and note down its ID (from the URL - https://docs.google.com/spreadsheets/d/THIS-PART-IS-THE-ID/edit#gid=0)

Usage

const { fetchSheet } = require('@itsravenous/google-sheets-public');

fetchSheet({ sheetId: 'your-sheet-id', tabName: 'Sheet 1', apiKey: 'your-api-key', callback: (error, values) => console.log(values) });

Package Sidebar

Install

npm i @itsravenous/google-sheets-public

Weekly Downloads

2

Version

2.0.0

License

GPL-3.0

Unpacked Size

3.52 kB

Total Files

4

Last publish

Collaborators

  • ravenoustom