A couple years ago I made a video about the Google Sheets API and how to read and write data between your website and your sheet. Things have changed since then so this video will provide an update to make it work in 2021.
We're also using JExcel this time which will give a more professional look to the "client" slide of the sheet.
This is a live stream, and I have not fully implemented this yet, so you get the joy of watching all the troubleshooting that programmers go through.
Here's the goal.
Chapters:
0:00 Display JExcel Entries In Your Website
8:00 Setting Up Your Google Sheets API Project
20:00 Read Data From Google Sheets Using API
34:00 Update Data into your Google Sheets Using API
50:00 Integrate JExcel with Google Sheets
Show your support by subscribing for more.
https://www.brunstar.com/
Link to Code:
https://www.brunstar.com/knowledge/google-sheets-api-read-and-write-data/
