Google Sheets Wrapper

yarn add f12-google-sheets

This project requires a Google Cloud Service Account credentials file.

Usage

Get all rows

import GoogleSheets from 'f12-google-sheets'

const gs = new GoogleSheets({
  credentialsPath: path.join(__dirname, '../../credentials.json'), // Path to the Google Cloud service account credentials file
  spreadsheetId: 'abcde' // Id of the google sheet
})

const rows = await gs.getAll()