Today I coded a google script that tracks clicks.
Published the script as a web app and can track any link you put in the sheet.
Watch it on youtube I walk through how it works, and how you can get it to work too. (that links uses the click tracker!)
Same principle as a click tracker or link shortener you would build with a nodejs and mongodb. But instead of a database and code, it's a google sheet and google script.
Better Sheets Members can copy the whole sheet and the script today. Everyone else can Watch it on youtube. Clicking that link will redirect you through the google script to the youtube video.