/RetroSheet-TS

📃 Read write to Google Sheets without API for FREE (100%)

Primary LanguageTypeScript

RetroSheet-TS

Thanks to : Retrosheet by theApache64

Install

NPM

npm i retrosheet-ts

Usage ⌨️

Fetch Google Sheet Data.

Get Spreadsheet ID

Get Spreadsheet ID from spreadsheet url. get_spreadsheet_id.png

Get Data

import { fetchRetrosheetData } from 'retrosheet-ts';

const response = await fetchRetrosheetData("<Spreadsheet ID>", { sheetName: "notess", query: "select * limit 2" })
Output 
[
  {
    "created_at": "26/08/2023 17:37:06",
    "title": "Hello",
    "description": "Description"
  },
  {
    "created_at": "26/08/2023 17:37:28",
    "title": "Yogesh",
    "description": "Description"
  }
]

Write Data to Google Sheet.

Follow steps 1 - 4 from here

Get Form ID

Get form id Form URL get-form-id.png

Write data

import { writeRetrosheetData } from 'retrosheet-ts';

const request = {
    'Title': "test title",
    'Description': 'test Description'
}
writeRetrosheetData("<FORM_ID>", request)

Note: Keys of request must be the same as Form Field name.