This tutorial describes how to leverage google apps script and Google sheets to remind you of your due subscription on Time for free of cost.

Introduction

Yes it is possible 🙂 with very small google apps script programs. You can use and customise this program to use in and combine with any services.

This article will guide you how we track our domain and server due dates. It will help to save costs while starting a small business with a small portfolio of clients.

Start from here

Note: Please follow if you haven’t followed this 📝 Blog

To get started copy 👉 This sheet

Appscript Part

By copying this sheet you will also get the code for the setup, I will explain later in the blog.

You will have a basic sheet setup. Fill the details for the website and renew the date accordingly.

How to Test Properly

First Test the main function by running in the editor. It will show unverified because you have not verified this app on google cloud, No problem you will need to click on Advance. Then click the unsafe option. No Problem you can verify your script later.

This will not remind automatically, We need to set up a trigger for the function.

You can add and customise this code according to your needs and requirements.

Feel free to drop a comment if you need more tutorials like this.

Creativity 🪔

• You can create anything for reminder or notification.
• You can add multiple services like Email.
• You can use Zapier type services as well.
• You can send your server to pause the user.
• HestiaCP and other Hosting panels provides API so we can use it on Google Sheets as well.

This list is very long and it is free to use. You do not need to pay for sass tool once you developed your desired solution.