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-sheets-parser-web';

const parsedData = await parseGoogleSheet(mySheetUrl);