Google Sheet API with NodeJS | Google Sheet as backend | Google Sheet CRUD operation with NodeJS

Hello friends,

Here in this video, I will explain to you how you can use Google Sheet as a backend to your project and do CRUD operation with NodeJS.

You will need:
(2) NodeJS installed on your system
(3) Some programming experience with NodeJS

The code used in this video can be found here

You can contact me to build any kind of Chatbot or need help with the backend of the Chatbot.

You can share your views on this video in the comment section.

If you like my work, subscribe to my channel for more new videos.

Enjoy the life, Feel the music.
Peace.

[robinkumar]

very helpful sir. i have a question, how to update the headerValue, for example your one of headerValue is 'email', i want to change it to something else. please guide

[hewaligogoi]

Hi, helped a lot. One question, in line no. 36 @ 07:08 (while printing the data with respect to its column name). My column name is something like ("User Name" instead of "user_name") which has space in it. Because of which I am unable to get the data. Can you please guide here, what to do in such case??

[randomicallyrandom]

I wanted to get rows filtering them by the user's email and date registery, is it possible??

[jasser]

Can I create a Google Sheet using Express.js, perform CRUD operations, and share it with a Gmail account to view the data?

[starchcode]

would this work on backend server with PM2? I made something similar but used google's library to authorise. works well when I run the app with Nodejs but not when I run the app with PM2 in the server

[IamRobertMTV]

can you map the values I get for all rows into a useState array?

[jocelynanahidvelardebarron]

Hello! Great tutorial but i still keep getting this error "doc.useServiceAccountAuth is not a function"

[kishoremaria]

Can we create Google sheet using nodejs??

[anleuc]

Hello sir, my IDE appear an error: "useServiceAccountAuth is not a function", and how can i fix it? Can you tell me, please. Thank you

[АртемТимофеев-яы]

hey man, when i try to work with google spreadsheet api i get one error all the time. Ive tried many things but every time error pops up - 'invalid_grant: Invalid JWT: Token must be a short-lived token (60 minutes) and in a reasonable timeframe'. If you just give some advice i'd really appreciate it man! Cheers

[ugochukwuamajor]

What if you want to update the password?