External access via Google Sheets, daily automation and script to delete rows
We have created this project to solve the problem we had in the spreadsheet of the external access video: • External access to our home's Web servers ...
In which once a day and also as soon as our IP changes, it adds a row to this spreadsheet, having to delete them manually from time to time since we are only interested in the content of the last row.
We created a script in Google Apps Script which is a JavaScript dialect for Google services: https://developers.google.com/apps-sc...
This script first checks that the sheet contains more than two rows of data and if so, it deletes the rows from the second to the second to last, leaving only the header row and the last row that appeared in the sheet as the second and last.
Then we create a trigger that runs this script once a day.
Code for Paste:
https://drive.google.com/file/d/1lQpr...
"External access"
#googlesheets #googlesheetstutorial #googlesheetsautomation #automation #script #javascript #sheets #scheduling #webdevelopment #everyday #tutorial #datascience #externalaccess #homeassistant