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

Подписаться 3,6 тыс.

Просмотров 16 тыс.

50% 1

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.

Наука

Опубликовано:

3 июн 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 42

@QuốcHuyNguyễn-r7r Месяц назад

Thanks bro. It's helpful for me

@sebbel3260 Год назад

Mic quality is amazing, made me stay

@kamusiimeraymond314 2 года назад

Thanks Sir. Great work!

@hiroyukinumaguchi1984 10 месяцев назад

Great!

@starchcode6021 2 года назад

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

@rajkkapadia 2 года назад

Hey, I am not sure about the PM2. May be you will need a different setup for it.

@robinkumar9829 2 года назад

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

@rajkkapadia 2 года назад

Hello, I am glad that my work helped you, but I am not 100% sure, but we cannot change the header values...

@hewaligogoi2395 Год назад

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??

@hewaligogoi2395 Год назад

Solved it by using row["User Name"]

@user-on7hj2ju9k 2 года назад

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

@rajkkapadia 2 года назад

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.

@miansaqlain8360 Год назад

how we can get the private key and token information now one guide about this please can you mention

@IamRobertMTV 3 года назад

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

@rajkkapadia 3 года назад

You can easily achive this, loop over the rows you get and push them into an array.

@IamRobertMTV 3 года назад

@@rajkkapadia can you give a sample snippet?. Thanks

@jasser4594 Месяц назад

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

@rajkkapadia Месяц назад

Yes, it is doable...

@randomicallyrandom Год назад

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

@rajkkapadia Год назад

Yes, it is possible, I have shown in the video as well...

@randomicallyrandom Год назад

@@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

@rajkkapadia Год назад

@@randomicallyrandom no it doesn't have that capabilities... You can use Airtable for that...

@randomicallyrandom Год назад

@@rajkkapadia I see, thank you

@Superuser-r1y 2 года назад

Can it handle 100k user per second??

@rajkkapadia 2 года назад

I am not sure of that, but it is google, it should, make sure your code handles that many requests...

@Superuser-r1y 2 года назад

@@rajkkapadia ok thanks

@kishoremaria8144 Год назад

Can we create Google sheet using nodejs??

@rajkkapadia Год назад

Yes, you can do that, you need to look into the documentation of Google meet...

@kishoremaria8144 Год назад

@@rajkkapadia okay. Thanks buddy..

@anleuc3246 Год назад

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

@rajkkapadia Год назад

I am unable to understand your error clearly... Can you explain it with more details...?

@anleuc3246 Год назад

@@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?

@rajkkapadia Год назад

@@anleuc3246 I think reading the documentation is the only solution...

@anleuc3246 Год назад

@@rajkkapadia Yes i did, but the error keeps popping up non stop, can you make a video tutorial? Please sir

@rajkkapadia Год назад

@@anleuc3246 Can you become a member of my channel..? I will record exclusive material for you...