Typescript library to parse default googleSheetsApiResponse

Makes get any data from google sheets faster & easier

Usage

Let's say we have a table in Google Sheets that needs to be converted to json format

| title | name | number | mail |--|--|--|--| | someTitle1 | SomeName1 | 1 | [email protected] | someTitle2 | SomeName2 | 2 | [email protected] | someTitle3 | SomeName3 | 3 | [email protected] | someTitle4 | SomeName4 | 4 | [email protected] | someTitle5 | SomeName5 | 5 | [email protected]

To convert this table from google list format we can use this function: (typescript)

import * as googleSheetsParser from "@exezt-/google_sheets_parser";

new googleSheetsParser.SheetsParser().parseWithFetch({  
  sheetId: `SHEET_BOOK_ID`,  
  sheetName: `list1`,  
  query: `Select A,B,C,D`  
}, (someData: object) => {  
  console.log(someData)  
})

(javascript ES)

new googleSheetsParser.SheetsParser().parseWithFetch({  
  sheetId: `SHEET_BOOK_ID`,  
  sheetName: `list1`,  
  query: `Select A,B,C,D`  
}, (someData) => {  
  console.log(someData)  
})

Result of running this function will be:

let obj = 
{
  table: {
    row_0: [ 'someTitle1', 'SomeName1', 1, '[email protected]' ],
    row_1: [ 'someTitle2', 'SomeName2', 2, '[email protected]' ],
    row_2: [ 'someTitle3', 'SomeName3', 3, '[email protected]' ],
    row_3: [ 'someTitle4', 'SomeName4', 4, '[email protected]' ],
    row_4: [ 'someTitle5', 'SomeName5', 5, '[email protected]' ] 
  }
}

Raw google api response contains characters that can't be parsed to json, this function solves this throuble

Full api

Functions

// Parsing any string to json catching errors
parseToJSON: (str: string) => object;
// Parsing JSON to beautify object 
parseToObject: (val: any) => object;
// Function that sends request to googleSheets and returns ready object 
parseWithFetch: (fetchParams: FetchParams, callback: (stringData: object) => void) => Promise<void>;

Types

// Fetch params, uses for parseWithFetch function
type FetchParams = {  
  sheetName: string; // Name of google sheet
  sheetId: string; // Id of google sheet book
  query?: string; // Query to google list examples: 'Select *' or 'Select A,B,C'
};