gsheets

##GSheets API

Default: /config/credentials.json

.env

GSHEETS_CREDENTIALS=/path/to/credentials.json

await GSheets.select({
    sheet_id: SHEET_ID,
    range: RANGE,
    where: {...}
})

await GSheets.insert({
    sheet_id: SHEET_ID,
    range: RANGE,
    records: [
        {...}
    ]
})

await GSheets.prepend({
    sheet_id: SHEET_ID,
    range: RANGE,
    where: {...}
})

await GSheets.append({
    sheet_id: SHEET_ID,
    range: RANGE,
    where: {...}
})

await GSheets.update({
    sheet_id: SHEET_ID,
    range: RANGE,
    where: {...}
})

await GSheets.delete({
    sheet_id: SHEET_ID,
    range: RANGE,
    where: {...}
})