google-sheet-parser-web

google-sheets-parser-web

Parses a Google sheets spreadsheet if it follows a basic format of equally structured rows that start with a heading row

e.g. A spreadsheet with the following structure

User	dateStarted	Role
John	22-01-1999	Manager
Bob	17-08-2005	Supervisor
Joe	03-12-2008	Clerk

will be parsed into the following JSON

[
  {
    "user": "John",
    "dateStarted": "22-01-1999",
    "role": "Manager"
  },
  {
    "user": "Bob",
    "dateStarted": "17-08-2005",
    "role": "Supervisor"
  },
  {
    "user": "Joe",
    "dateStarted": "03-12-2008",
    "role": "Clerk"
  }
]

Usage

import parseGoogleSheet from 'google-sheet-parser-web';

const parsedData = await parseGoogleSheet(mySheetUrl);