Try   HackMD

Node-RED 連結MQTT 資料上傳至 Google Sheet服務

LHB阿好伯, 2021/03/20

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

tags: Node-RED

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

安裝節點

https://flows.nodered.org/node/node-red-contrib-google-sheets

搜尋google就可以看到本次使用的node-red-contrib-google-sheets套件

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

在使用這節點之前需先完成
新增一個Google服務帳戶
下載服務帳戶的JSON金鑰
授予該帳戶訪問Google Sheet API的權限
最後再與服務帳戶的電子郵件地址共享Google Sheet
例如 nodered@nodered-12345.iam.gserviceaccount.com

連結google服務

建立服務帳戶

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →
點擊我建立服務帳戶

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

取得帳戶金鑰

點選帳戶信箱

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

建立或新增金鑰

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

貼到節點中

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

開啟Google Sheet & Drive API

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

共用試算表

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

測試結果

建立一個最基本的節點測試

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

節點資料

[{"id":"86531bb5.4a6e48","type":"tab","label":"流程2","disabled":false,"info":""},{"id":"bb9215b2.f64bc8","type":"mqtt in","z":"86531bb5.4a6e48","name":"MQTT","topic":"","qos":"0","datatype":"utf8","broker":"","x":170,"y":180,"wires":[["8268adb1.6c9df"]]},{"id":"8268adb1.6c9df","type":"GSheet","z":"86531bb5.4a6e48","creds":"","method":"get","action":"","sheet":"","cells":"","flatten":false,"name":"Google  Sheet","x":440,"y":180,"wires":[[]],"inputLabels":["1"],"outputLabels":["2"]}]

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

試算表ID位置

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Node-RED 連結MQTT 資料上傳至 Google Sheet服務

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

JavaScript自1970年1月1日（UTC）

使用R Shiny抓取Google Sheet資料繪製圖片

參考資料

https://flows.nodered.org/flow/a36ccbcfc43c264cda892383fe034fe3
https://flows.nodered.org/node/node-red-contrib-google-sheets

🌟全文可以至下方連結觀看或是補充
https://hackmd.io/@LHB-0222/NodeRED-GSeet

全文分享至

https://www.facebook.com/LHB0222/

https://www.instagram.com/ahb0222/

有疑問想討論的都歡迎於下方留言

喜歡的幫我分享給所有的朋友 \o/

有所錯誤歡迎指教

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →
全部文章列表

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Last changed by 
 
阿好伯
分享自身所學到的一些東西 規劃主題應為6大類 1.Excel 2.統計軟體_R_SPSS 3.其他軟體使用心得 4.專業知識紀錄 5.好書分享 6.生活記事 希望有人喜歡，也幫助到更多人
0
3
5904

Read more

Raspberry Pi網路攝像機_實物投影機

[color=#40f1ef][name=LHB阿好伯, 2021/07/16]:earth_africa:

Mar 11, 2025
R語言常用好用套件紀錄

hackmd-github-sync-badge

Jan 25, 2025
Ntfy介紹_自行架設及使用說明

[color=#40f1ef][name=LHB阿好伯, 2024/10/22]:earth_africa:

Jan 23, 2025
List Comprehension

[color=#40f1ef][name=LHB阿好伯, 2020/12/21]:earth_africa: Python語法簡單易學且非常簡潔 今天要來學習的Comprehension即是Python的Pythonic語法之一 可以運用在任何可疊代的物件(Iterable Object)上 將前面學的Loops迴圈濃縮在一行程式碼即可完成多行的任務 讓我們的程式碼更簡潔增加可讀性 清單(List)的Comprehension 如Loops迴圈中大大多數程式語言都可以使用for loops

Jan 15, 2025
Read more from 阿好伯
Published on HackMD