google-sheets-data
v0.1.1
Published
JavaScript library to read data from a public Google Sheet document
Downloads
37
Readme
Google Sheets Data
A library to read data out of a public Google Sheet Document
Installation
$ yarn add google-sheets-data
Usage
import GoogleSheetsData from 'google-sheets-data'
const sheetId = '1jNWarfCxUCnjby0fKPViY9j5h2XTB4k0InK9OWdd1-s'
const sheet = new GoogleSheetsData(sheetId)
const data = await sheet.getData()
How to make a Google Sheet public
1. Publish your Google Sheet: File -> Publish to the Web
2. Get the ID from the share URL for your Google Sheet: Share -> Get shareable link
For example this shareable link:
https://docs.google.com/spreadsheets/d/1jNWarfCxUCnjby0fKPViY9j5h2XTB4k0InK9OWdd1-s/edit?usp=sharing
Would have the ID of:
1jNWarfCxUCnjby0fKPViY9j5h2XTB4k0InK9OWdd1-s