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 ```json [ { "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.