Google Sheets & NextJS

[@slamonega]

Could you share a github repository of this example?

[@riceisgood81]

Thanks for this video! It was incredibly helpful in getting me unblocked at the Service Account auth step. As of today, it looks like the opts parameter is deprecated but everything inside the object is now its own parameter. I had to directly pass in credentials and scope. Also, with the new app router, you don’t need an API route. I was able to use the new Server Actions (“use server”).

[@buckle42]

Would be so so so helpful if you could please post an update to this using Next.js 13's new src/app routing method for APIs. No one on the internet knows how to do this for some reason including stackoverflow :(

[@wildchamo]

i know how to do that! it isnt that dificult

[@CodyWilson11]

Just want to say thanks for the amazing demonstration and complete walkthrough. I also adopted your google chrome new tab life counter. You've earned a sub.

[@Realreal12345]

This was super helpful and saved me a bunch of time. Thank you!

[@himanshuagarwal7925]

Thank you very much exactly what i was looking for. Very helpful.

[@ocrit285]

hi sir, can you update tutorial using the new next.js 13.4 with app dir?

[@jeremydudet]

dude. this was a god send for me. Thank you

[@VMNthemaster]

Hi there, first of all, thanks for the video, it worked for me I just wanted to ask that in my project, I have to create a new spreadsheet for every new set of data; how to do that?

[@ReiSodaSteven]

Thanks for the tutorial.

[@KhoaTran-fr1jo]

nice tut

[@leveritablesamuel]

Thanks so much! Great help 😃

[@ArjunKrishna-r4b]

Thanks for helping!!!!

[@victordavilaamelinckx5284]

Awesome!

[@totiruiz5913]

This was super helpful, thank you for your clear explanation and code example!

[@yuenchen4882]

Really helpful, thanks a lot!!!

[@andreymorozow4225]

very cool, thank you!

[@tochukwungene]

Thank you!

[@lua.alvaro]

Muito obrigado my friend! Ajudou demais...

[@dingleferry736]

Super helpful, thanks! I've been able to get this working locally, but when I try to deploy it through Vercel, I get hit with a POST error:500 every time I try to submit. Any suggestions on how I can troubleshoot this?

[@alancoronado9835]

I am also getting this error, i think its because the public doesnt have access to GOOGLE_CLIENT_EMAIL, GOOGLE_PRIVATE_KEY, and GOOGLE_SHEET_ID. Though I still want the public to be able to send their data so I am a bit confused on what to do here without giving them that information. Did you figure it out?

[@vanshvansh4360]

​@@alancoronado9835same, did you figure it out ?

[@ba55junke]

You need to add the .env.local vars to vercel in the settings > environment varilbles add the 3 from the .env.local and it should work.

[@kzzesama1959]

is there any way to block users to post multiple requests in short time or does this api automatically blocks.

[@Jota.G]

Thanks bro

[@nocturnedev8034]

Hi I did the same think as you but I got code: 401, errors: [ { message: 'Invalid Credentials', domain: 'global', reason: 'authError', location: 'Authorization', locationType: 'header' } ]

[@mileicampeonmundial]

how is the performance?

[@agustorres4281]

Hi man, thanks a lot for this tutorial however when i deploy to vercel or heroku and click in the submit button the server response is 503 (service unavailable). Any help will be appreciated!

[@itsbrex]

I ran into the same issue with another project deployed on Vercel with the latest Vercel release. There was nothing in the change log but other people are having issues with POST requests in API routes. I was able to fix my issue (separate project) by switching it to GET request with query parameters, but that obviously wouldn’t work with a form submit.

[@carlos__z]

try adding NEXT_PUBLIC_ prefix to environment variables, that solved my issue in production with Vercel

[@agustorres4281]

@@carlos__z Ok, i'll try it, thanks you!

[@Michael-Martell]

@@agustorres4281yo don’t do that!!!

[@Michael-Martell]

This isn’t working anymore unfortunately… (atleast for me) it says api failed due to access control checks. On Google it says that Google may have removed access for service accounts. Or could it be a next 13 issue? The post request looks like it needs restructured. Anyone else get this working recently?

[@hakimhamaili]

The problem am having is it is not pushing data to the spreadsheet on production, all of my env vars are working fine and i do get logged that the data is there, but when i check its not pushed, i use vercel for host deployement

[@ba55junke]

in vercel under settings > environment varibles add the stuff from your .env.local and it worked for me @hakimhamili

[@ba55junke]

Did anyone sus out how to get this to work in vercel? cuz I am Hella stuck and whats the point??? if you can't make it work on the web?

[@sanjibsaau]

Could you share a github this example

[@quanganho6859]

dude can you share your code please?

[@Icodestuff]

github.com/icodestuff-io/nextjs-google-sheets

[@patrycksilva4440]

my sheet dont update when i do de request, help me

[@starless0021]

7:30 plugins

[@EPANOUI243]

erreur 500 héberge sur vercel

[@luisbarbosa5597]

no sauce code? bs

[@sernn2327]

Sir I am able to done this in my local but in production it fail with status 500 internal server error. Any idea pleaseee 🥲

[@EPANOUI243]

vous avez trouve une solution our cela ?

[@carlos__z]

for use in Production, don't forget to add the NEXT_PUBLIC_ prefix to all 3 environment and also in Vercel (or the deploy site you are using)

[@afraz3301]

PLEASE LINK YOU GITHUB

[@tumi_tigur]

Great video, thanks a lot!