Sending Data from ESP32 To Google Sheets

GSheet32 Arduino Library

• Go to google Spreadsheets Click Links
• Create a new sheet or if it already exists select the sheet
• Copy and save your sheet id from the link in your sheet
• Go to Extensions -> Apps Script
• Copy the code in /Code Apps Script/Script.txt to code.gs
• Replace the program var sheet_id with the sheet id you saved
• Click apply -> New Deployment
  
• select type -> web application
  
• Set access to anyone and hit apply
  
• Follow the steps to give google account Permission
• Once done, Save the deployment id or GAS_ID
  

• You can visit Examples
• Print Data to Google Spreadsheet (Max 5 column)

  Sheet.sendData("C","D","E","F","G"); 
  

• if you want to add space in 1 column then change the space to %20, or you can type it with the help of url encode

  Sheet.sendData("Hello%20World"); 
  

This project is released under The MIT License (MIT)