All the changes you make in website table are reflected on google sheet , and also same goes for google sheet changes for website.
Google link : https://docs.google.com/spreadsheets/d/1aCFidvMYq99gL87eWtYs1WOnJoKsCpgNF0wMIEjsrpM/edit#gid=0
Currently using : sheet.best to turn google sheet in Rest API Note-> This service has one month free trial. Currect we are on Free version.
1.Please open this project in one tab and Google sheet into another tab.
2.Make changes into sheet and click sync button. Changes must have been reflected on website.
3.Make changes into website table(Edit, Delete, or Create new Row). Changes must have been reflected on Google sheet.
Github Repo: https://github.com/hemantvardani/AcessGoogleSheetFromWeb
Live Link: https://hemantvardani.github.io/AcessGoogleSheetFromWeb/
(Link is editable , so that you can make change in the sheet and see the effect on WebApp, and vice versa)