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