Web Page Visitor Counter Part 3 - Putting it all Together

Now that I finished building the software "LEGO" that I needed to do in order to have some way of displaying the number of visitors that I had on my website, the time had finally come to stop pounding away on the keyboard and to work on something that was a wee bit more tangible.

Before I started work on creating my Google Sheets and ThingSpeak applications, I first made a couple of quick purchases on eBay for the various electronic bits that I would need to make my visitor counter a reality.

Web Page Visitor Counter Part 2 - Adding Thingspeak

In my last post, I stated that I wanted to build an IoT device that would display the number of visitors to this very website.

As I mentioned in my last post, I was finding it a bit difficult to find an easy way to read my visitor count via an API call to the IoT device that I would use to display the visitor count.  After some poking around I figured that I could obtain that data via a combination of Google Sheets reports and a ThingSpeak API application.

In my last post, I focused on the building of the Google Sheets report. This time around I will be focussing on building the ThingSpeak logic to read the Google Sheets report and to create a data pipe that my IoT device can use.

Again, this is going to be more of a post about software than spending quality time in the shop, but trust me, we will be back in the shop soon enough.