MS

Easy Database with IFTTT, Blogger, and Google Forms

I’d like to share with you a new tool that I’ve been working on for my colleagues. What I have noticed in recent years, is that every teacher has his or her favorite websites, classroom productivity and creativity tools, and general digital resources. I am constantly hearing about new ones as I visit classrooms and speak with teachers and students. I thought to myself, why not share these amazing resources with each other so that we can all benefit from what they offer? This in mind, I put together a database to store a collection of digital resources for teachers. 

Visit the Digital Resource Collection now!

So, let me tell you how I put this together, because I think it’s pretty cool. The digital resource collection is simply a blogger blog. I chose this tool as it is a Google Product, so it’s compatible with all of our other G Suite tools. I can easily access it using my work account, and I can control the privacy and accessibility with great detail (just like a Google Doc). Additionally, blogs have search and filtering capabilities built-in, along with commenting and easy sharing. I wanted to make it easy for teachers to share resources, so I figured a simple Google Form would be the best tool for the sharing of resources. I created the form and had all responses automatically sent to a Google Sheet (took about two minutes!). The problem was, how could I get the form submissions to automatically post to the blog? I found the answer in a great tool called IFTTT. IFTTT allows you to automate processes. It’s really easy and fun to use. I set up a service that would post a new blog entry every time a new row was created in the Google Sheet. You can completely customize this so that it looks the way you want. And that’s it - we now have a database that every teacher in the district can submit to by filling out a simple form.


BACK