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:

  1. Created a survey with Google Forms
  2. Used Apps Script to automatically say thank you to 1,700 respondents
  3. Analyzed the response data in Google Sheets
  4. Used AI to help me understand the qualitative data
  5. Presented the results in Google Docs

This flowchart shows how the system is set up:

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

Three Ways To Use AI Tools With Google Sheets

AI course for Google Sheets

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.

But where does AI fit with Google Sheets?

And how do we use AI tools with Google Sheets?

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:

  1. Chatbots like ChatGPT or Bard
  2. Google Sheets Add-Ons
  3. Via the API and Apps Script (advanced)

Continue reading Three Ways To Use AI Tools With Google Sheets

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 AI can do with Google Sheets though, let’s start with a quick AI 101 to ensure we’re up to speed with the lingo.

Green Tea Image generated by Dall-E
Image generated by Dall-E, a deep learning model, using the prompt “a cup of tea with a green potion inside with thin swirling vapors rising out of it”

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