Building Uptime Monitor with Google Sheets
Nowadays, I’m working with Google Cloud Services. I’m exploring new ways to built things easier and cheaper. This post shows you how to build an uptime monitor with Google Sheets and app script features.
You can use this script for any reason. You can check your websites or HTTP service statuses with Google servers for free!
Google allows us to write our codes in the Google Docs ecosystem. So we can build our extensions or plugins. In this case, I told you how to build an uptime monitor with a logging system.
If you do not need to know technical stuff you can get a copy of my file from here directly.
How did I build this?
We need to create a function that gets URLs from the sheet. Then we’ll check all URLs one by one to get HTTP statuses. After that, we’ll write the status and timestamp back to the sheet.
How to create an uptime monitor with Google Sheets
How to create an uptime monitor with Google Sheets
1. Create a Google Sheets File
Go to https://sheets.google.com then create a Google Sheet file
2. Prepare the document
We need these columns to script work.
3. Paste the script to script editor
Go on menu Tools->Script Editor. Then paste the codes below.
4. Go to the triggers page
In the script editor, you will see the Triggers menu on left. Click there and configure a trigger that allows us to run our script automatically.
5. Create a trigger
Click the Add Trigger button on the right bottom.
6. Configuring the trigger
We’ll set up the trigger as a cron job. You need to set options like in the photo below
The script that includes code
I hope this will be good for you.
See you in the next tutorial!
