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”).
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.
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 :(
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?
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
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?
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?
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' } ]
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?
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!
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.
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”).
Thanks for helping!!!!
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.
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 :(
i know how to do that! it isnt that dificult
nice tut
Could you share a github repository of this example?
This was super helpful and saved me a bunch of time. Thank you!
Thank you very much exactly what i was looking for. Very helpful.
Thanks for the tutorial.
Thanks so much! Great help 😃
Thank you!
Really helpful, thanks a lot!!!
very cool, thank you!
hi sir, can you update tutorial using the new next.js 13.4 with app dir?
Awesome!
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?
Thanks bro
Muito obrigado my friend! Ajudou demais...
dude. this was a god send for me. Thank you
This was super helpful, thank you for your clear explanation and code example!
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?
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
in vercel under settings > environment varibles add the stuff from your .env.local and it worked for me @hakimhamili
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?
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?
@@alancoronado9835same, did you figure it out ?
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.
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'
}
]
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?
is there any way to block users to post multiple requests in short time or does this api automatically blocks.
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!
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.
try adding NEXT_PUBLIC_ prefix to environment variables, that solved my issue in production with Vercel
@@carlos__z Ok, i'll try it, thanks you!
@@agustorres4281yo don’t do that!!!
7:30 plugins
dude can you share your code please?
github.com/icodestuff-io/nextjs-google-sheets
my sheet dont update when i do de request, help me
how is the performance?
Could you share a github this example
erreur 500 héberge sur vercel
no sauce code? bs
PLEASE LINK YOU GITHUB
Sir I am able to done this in my local but in production it fail with status 500 internal server error. Any idea pleaseee 🥲
vous avez trouve une solution our cela ?
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)
Great video, thanks a lot!