Google Sheet API with NodeJS | Google Sheet as backend | Google Sheet CRUD operation with NodeJS
ฝัง
- เผยแพร่เมื่อ 3 มิ.ย. 2021
- 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:
(1) GCP account - console.cloud.google.com
(2) NodeJS installed on your system
(3) Some programming experience with NodeJS
The code used in this video can be found here
github.com/RajKKapadia/Youtub...
You can contact me to build any kind of Chatbot or need help with the backend of the Chatbot.
My Fiverr profile - www.fiverr.com/rajkkapadia
My Upwork profile - www.upwork.com/freelancers/~0...
My LinkedIn profile - / rajkkapadia
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. - วิทยาศาสตร์และเทคโนโลยี
![[Full Episode] MasterChef Junior Thailand มาสเตอร์เชฟ จูเนียร์ ประเทศไทย Season 3 Episode 3](http://i.ytimg.com/vi/A1XXYbV048k/mqdefault.jpg)
Mic quality is amazing, made me stay
Thanks Sir. Great work!
Great!
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
Hey, I am not sure about the PM2. May be you will need a different setup for it.
Can I create a Google Sheet using Express.js, perform CRUD operations, and share it with a Gmail account to view the data?
Yes, it is doable...
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
Hello, I am glad that my work helped you, but I am not 100% sure, but we cannot change the header values...
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??
Solved it by using row["User Name"]
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
Hello, I think if you followed my tutorial, I don't use JWT, I use service account json file to authenticate my request. This is one of the way to authenticate your request.
how we can get the private key and token information now one guide about this please can you mention
can you map the values I get for all rows into a useState array?
You can easily achive this, loop over the rows you get and push them into an array.
@@rajkkapadia can you give a sample snippet?. Thanks
I wanted to get rows filtering them by the user's email and date registery, is it possible??
Yes, it is possible, I have shown in the video as well...
@@rajkkapadia But is using for-loop the only way to do it? What I meant is if google sheets API allows us to make a query
@@randomicallyrandom no it doesn't have that capabilities... You can use Airtable for that...
@@rajkkapadia I see, thank you
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
I am unable to understand your error clearly... Can you explain it with more details...?
@@rajkkapadia At the beginning of the video, notice the function "useServiceAccountAuth()" was used in the line 47, i think it no longer used according to the documentation provided by the google-spreadsheet npm library. Do u have another solution?
@@anleuc3246 I think reading the documentation is the only solution...
@@rajkkapadia Yes i did, but the error keeps popping up non stop, can you make a video tutorial? Please sir
@@anleuc3246 Can you become a member of my channel..? I will record exclusive material for you...
Can we create Google sheet using nodejs??
Yes, you can do that, you need to look into the documentation of Google meet...
@@rajkkapadia okay. Thanks buddy..
Can it handle 100k user per second??
I am not sure of that, but it is google, it should, make sure your code handles that many requests...
@@rajkkapadia ok thanks
Hello! Great tutorial but i still keep getting this error "doc.useServiceAccountAuth is not a function"
Okay, I will check and maybe create an updated video as well...
@@rajkkapadia Great!
@@jocelynanahidvelardebarron7328 I have checked the code again, I think you need to install the packages first...