This was an outstanding example of using the Google Sheets node, guiding the user carefully through the necessary Google Cloud services and settings. One additional step I found I had to perform (March 2023) was returning to the Google Cloud project, navigating to APIs and Services, and enabling the Google Sheets API for that project.
Funciona muy bien, lo acabo de conectar y lo único que me pidió a parte de lo que muestra en el video es, habilitar la Google Sheets API en la cuenta que estoy usando, todo lo demás funcionó perfecto.
DAMN....I get "SyntaxError: Unexpected non-whitespace character after JSON at position 1" but my version differs right from the textbox I hade a PEN and a + And you have the node-red@sheets filled in....??
First of all, thank you for the video. I just have one problem. I want to print data to both column A1 and column B1 using a single inject. However, even though I select the same row, it does not write the data to the same row, it writes one of them to the bottom row. How can I solve this problem?
Unfortunately not. And i think it cant be. But one of the videos about nodered in youtube, i saw a difficult solution, with using google form and google sheet and node-red together.
@@YaserAliHusen One more ... in Gsheet node, Field:Cell, I don't mange to send data to Sheet2! (sheet1! ok). Maybe any other config needed sending data to Sheet no. 2?
When you set up your project you need to tell google which APIs you intend to use. You have forgotten to add that you will be using the Google sheets API
I have the same error. Did you solve it? I am stuck in that error and I am not being able to solve it. If you have solved it, con you tell me how you did it?
Hey ! I'm a French guy and I expect my English writes is understandable. I was stuck and I thinked Google maked somes change. I solved the problem. You just need to put "A1" for gets or write in the cell. Or you just write "A1:B2" for area. And, if you want to select a unique sheet. First, you need to rename it, like BAGUETTE. And after, you put "BAGUETTE!A1" for the cell A1 of the BAGUETTE sheet.
2:47 You will need to rename the sheet below to match the variable. For example, in the clip, use Sheet1! A2:A1000 and name the sheet below Sheet1. If you want to name it in a different way, you can set it and enter the name to match. It work!!
This was an outstanding example of using the Google Sheets node, guiding the user carefully through the necessary Google Cloud services and settings.
One additional step I found I had to perform (March 2023) was returning to the Google Cloud project, navigating to APIs and Services, and enabling the Google Sheets API for that project.
Yes, we must enable Google Sheets API for the project.
In video, i already enabled it before
Your comment really helped me, thanks.
Excelent video, very easy to understand, thanks.
you really help me!! Thank you
Thank you for the great video!
Funciona muy bien, lo acabo de conectar y lo único que me pidió a parte de lo que muestra en el video es, habilitar la Google Sheets API en la cuenta que estoy usando, todo lo demás funcionó perfecto.
lo conectaste a google sheet?
como lo hiciste?
Very useful, thanks!
Thank's very much sir
Thank you , but i have an problem. i can write data to google sheet, but i put an inject and connect it two
makasih pak
sangat membantu
Sama2
DAMN....I get "SyntaxError: Unexpected non-whitespace character after JSON at position 1" but my version differs right from the textbox I hade a PEN and a + And you have the node-red@sheets filled in....??
First of all, thank you for the video. I just have one problem. I want to print data to both column A1 and column B1 using a single inject. However, even though I select the same row, it does not write the data to the same row, it writes one of them to the bottom row. How can I solve this problem?
Did you solve this?? I have the same situation
Unfortunately not. And i think it cant be. But one of the videos about nodered in youtube, i saw a difficult solution, with using google form and google sheet and node-red together.
İf i find the link i will share you
ua-cam.com/video/iXM2JuUTxfo/v-deo.htmlsi=99ld697o6wo5Yewb
@@OnurYazıcı-b2w thanks!
how to add function data/time formatter ? is there install new module from palette ?
Yes, that is additional module, you can find it: node-red-contrib-moment
Great tutorial. How can I put a three values (colomn A, B,C) and have it the same row?
Try to send an array payload
@@YaserAliHusen Great! Magic! All data on the same row !! 🙂
👍
@@YaserAliHusen One more ... in Gsheet node, Field:Cell, I don't mange to send data to Sheet2! (sheet1! ok). Maybe any other config needed sending data to Sheet no. 2?
hello is it the same if I use MQTT connection to send the data to the google sheet ?
I dont know, how google sheet receive data from MQTT broker?
@@YaserAliHusen you can receive data from MQTT with Node-Red then insert them into google sheets after
@@SmartChosk, oh yes
Great idea
my debug show "The API returned an error: Error: Unable to parse range: Sheet1!A2:A1000"
Do you have a solution?
Hi. What must be pasted @ Creds Google Service Accounts Credentials JSON under GSheet Node
Content of JSON file from google
You must download it,please watch full video
thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Halo pak, bagaimana jika mau menambahkan pada kolom B C dan seterus nya ya pak, jadi gk hanya satu kolum, terima kasih pak
terimaksih
Nice tutorial, u know how to send two different data in two columns?
You can send in json format
can you make tutorial video for it? i really need it, thank you@@YaserAliHusen
You may face one more error message at the end. Follow the url in the error output and enable google sheets api, then it will start working
When you set up your project you need to tell google which APIs you intend to use.
You have forgotten to add that you will be using the Google sheets API
it did not work and display this message in node-red debug : The API returned an error: Error: Unable to parse range: "sheet1!A1:B1,"
I have the same error. Did you solve it? I am stuck in that error and I am not being able to solve it. If you have solved it, con you tell me how you did it?
Hey ! I'm a French guy and I expect my English writes is understandable.
I was stuck and I thinked Google maked somes change. I solved the problem. You just need to put "A1" for gets or write in the cell. Or you just write "A1:B2" for area.
And, if you want to select a unique sheet. First, you need to rename it, like BAGUETTE. And after, you put "BAGUETTE!A1" for the cell A1 of the BAGUETTE sheet.
@@yohan4246 it doesn't work for me:(
2:47 You will need to rename the sheet below to match the variable. For example, in the clip, use Sheet1! A2:A1000 and name the sheet below Sheet1. If you want to name it in a different way, you can set it and enter the name to match. It work!!
is it all free?
Node-RED and google sheet are free
permisi pak cara mendapatkan json key?
dapat di console.cloud.google.com
@@YaserAliHusen izin bertanya lagi pak, node untuk time/date nya itu apa ya nama node nya🙏
@@aptanaazmi6470 ,kalau ga salah node-red-contrib-moment
@@YaserAliHusen terimakasih pak nnti saya coba