Although AI has been around for decades, it’s only really been available to the public in its current form for the past year or so. And with the rise of these generative AI tools, like ChatGPT and Google Bard, AI is more accessible than ever.
In this post we’re going to look at how to use the most popular AI tools with Google Sheets. You’ll see how easy it is get started and learn that AI isn’t rocket science. It’s simply another useful tool that can save you time when you work with Google Sheets.
Specifically, we’ll look at three ways to use AI tools with Google Sheets:
In this post, we’ll explore an easy way to track link clicks on a website using Google Sheets and Apps Script.
This setup is simple and not comparable to the sophisticated event tracking configurations in dedicated analytics software. However, it’s a nice, lightweight alternative that could be useful in limited scenarios. If nothing else, it’s a nice example showing how to create a webhook with Apps Script and Google Sheets to log data.
In this image you can see that when a link is clicked, it’s logged in a Google Sheet with information about the link:
In this post, we’re going to create a tool that calls the Fathom Analytics API and pastes website traffic data into Google Sheets:
But first, a quick backstory:
Earlier this year (2022), Google announced the sunsetting of the old implementation of Google Analytics, in favor of GA4.
At the time I was running the old Google Analytics software, implemented through Google Tag Manager (along with Facebook’s pixel tracker).
It was time for me to update my web analytics software.
But I didn’t want to just shove GA4 into my existing tag manager setup. From what I’d heard, GA4 was difficult to use and way overblown for my needs.
So I cast around for alternative analytics software and landed on Fathom.
Fathom Analytics is a lightweight, easy-to-use, privacy-focused analytics software that is perfect for my website.
It was ridiculously easy to set up and I’ve been delighted with how easy it is to use. I jump in and can quickly see everything I need to know for my website:
This post explores how to connect to the Teachable API using Apps Script. You can use this setup to return data about your online courses and show it in Google Sheets.
For example, here’s a running 30-day window into the enrollment, engagement, and completion rates of my online courses:
As a creator, it’s super useful to see these sorts of insights. They inform your future strategy and help identify areas of the business to improve. The standard Teachable dashboard is very limited and doesn’t show you this kind of information.