gsheet-to-db

Example for gsheet-to-db GitHub repo link

https://github.com/saurabhgkp/gsheet-to-db-example

Easy to use and implement

SheetDB will turn your sheets into a JSON API, easy to integrate with other tools and all programming languages.

operations

You can read and edit your spreadsheet with GET, POST, PUT and DELETE requests with just a few lines of code.

FAQ

In Google Sheets you have to set data in header vale by manually first Field must be an 'id' and remaining is upto you

| id | Name | Status | Salary | | ------------- | ------- | -------- | -------- | | 1 | Wilson | FullTime | $40,000 | | 2 | saurabh | FullTime | $120,000 | | 3 | herry | FullTime | $40,000 |

 id |	 Name |    Status |	Salary
this field Are Add by manually field
may Different (As you Want 'id' is First Field !importent)

passing data in body is like

{
    "B":"herry",
    "C":"FullTime",
    "D":"$40,000"
}

always use capital letters ===> Don't A, This is use for 'id' use B C D to the Z for passing data

prerequisite

Activate Google Sheets API. Go to the Google console developer and enable Google Sheets API. https://console.cloud.google.com/apis/dashboard And get JSON key. DO NOT commit the JSON key! Add the file to .gitignore now and import it into the code! Or use environment variables.

Installation

Install my-project with npm

  npm i gsheet-to-db

Import

const { Gsheet } =  require("gsheet-to-db")

const  gdata  =  new  Gsheet("./keyFile.json", "spreadsheetId", "sheetName")

 let  data1  =  await  gdata.findAll()
 let  data2  =  await  gdata.findById(id)
 let  data3  =  await  gdata.create(data)
 let  data4  =  await  gdata.deleteById(id)
 let  data5  =  await  gdata.updateById(id, data)

Code Explanation

"./keyFile.json" this keysFile you can get it from Google console developer

spreadsheetIdyou can get from spreadsheet URL for example https://docs.google.com/spreadsheets/d/1JmpRfmEfSdVAxAu2SRvzsnswI1-ln-3F_1xtlg/edit?pli=1#gid=0 here after /d/ and before /edit is your spreadsheetId ="1JmpRfmEfSdVAxAu2SRvzsnswI1-ln-3F_1xtlg"

sheet name can be found at the bottom of spreadsheets by default is something like "sheet1"

let data3 = await gdata.create(data) here data must be started from "B" not "A". "A" is reserved for "id" for example

{
    "B":"herry",
    "C":"FullTime",
    "D":"$40,000"
    ...
}

for any help, you can DM me on LinkedIn

🔗 Links