TechEducator Podcast 106 (Google Forms)

In this episode of the TechEducator Podcast, we explore powerful Add-ons for Google Forms and Google Sheets.  Also in this episode, we have a visit from Andrew Stillman, one of the amazing authors of these Google Add-ons.

The TechEducator Podcast is a weekly round table discussion about current topics in educational technology.  For more information, please visit

Many great ways to participate in the TechEducator Podcast.

  1. Follow us Live on Video:
  2. Leave a Voice Mail:
  3. Email:
  4. Twitter: @TechEdShow (
  5. Hashtag: #TechEducator


  1. Jeff Bradbury – – @TeacherCast
  2. Jeff Herb – – @JeffHerb
  3. Sam Patterson – – @SamPatue
  4. Jennifer Judkins –
  5. David Saunders @DesignSaunders
  6. Josh Gauthier @mrgfactoftheday
  7. Jennifer Scheffer – @JLScheffer

Google Forms & Add Ons – Beyond the Survey

  • Using Google Forms for automated workflows

  • “Tool kit” of Add-Ons for Forms & Sheets used for automation

    • Forms Add-Ons

      • formRanger – auto-populate a drop down list of response options from a spreadsheet

      • formLimiter – set maximum responses or close form to new submissions at specific time/date

    • Sheets Add-Ons

      • autoCrat – mail merge using spreadsheet data

      • syncData – pushes data from “master” sheet to other sheets

      • copyDown – Copy spreadsheet formulas down to any new rows that result in form submissions

  • Learn more about Data Validation in Google Forms – Blog Post

The TechEducator Podcast would like to thank Andrew Stillman for joining us on the program today.


Thank You For Your Podcast Reviews

Are you enjoying Educational Podcasting Today or other shows on the TeacherCast Network, please share your thoughts with the world by commenting on iTunes today.  I enjoy reading and sharing your comments on the podcast each week.

Ask Me Your Podcasting or WordPress Question

Are you interested in starting your own podcast? Do you need help creating an awesome WordPress website?  I am available for 1:1 consulting.  Please visit my homepage and I will help you launch your personal brand today!

Contact Me

Check Out More TeacherCast Programming

View LIVE Professional Development from TeacherCast

Need a Presenter?