How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses

This post describes how I designed and ran an audience survey with over 1,700 responses, using Google Forms, Sheets, Apps Script, and ChatGPT. I’ll show you the entire process from end-to-end, including how I: Created a survey with Google Forms Used Apps Script to automatically say thank you to 1,700 respondents Analyzed the response data … Continue reading How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses

What AI Can Do For You As A Google Sheets User. Is The Hype Justified?

In this post, we’re going to take a 40,000 ft view of the Artificial Intelligence (AI) landscape and see how you can use it alongside Google Sheets to boost your productivity. And, at the end of the post, I’ll answer the question about whether I think the AI hype is justified. Before looking at what … Continue reading What AI Can Do For You As A Google Sheets User. Is The Hype Justified?

Bullet Chart in Google Sheets with Sparklines and Named Functions

In this post, we’ll build a named function that creates a miniature bullet chart in Google Sheets, as shown in this GIF: Bullet charts are variations on bar charts that show a primary measure compared to some target value. They’re highly effective because they capture a lot of information in a small, neat design. To … Continue reading Bullet Chart in Google Sheets with Sparklines and Named Functions

How To Create A Google Sheets Drop-Down Menu

In this post, we’ll look at how to create a Google Sheets Drop-Down Menu. Here’s an example of a drop-down menu to record the status of deals in a real estate deal pipeline: Drop-down menus are great for data entry and making your Sheets dynamic. In this post, we’ll explore both of these techniques with … Continue reading How To Create A Google Sheets Drop-Down Menu