IFTTT Formula for Doing Admin (All Teachers)
I cannot describe how much admin time IFTTT has saved me.
For anyone who hasn’t used it, it’s called ‘If this then that’. It connects up different services on the web. Which sounds dull, until you realise how powerful it can be.
I hate admin – it’s the most boring, mind-numbing part of our job. But now, thanks to IFTTT, my admin is almost completely automated. And it’s totally free. Here’s the first trick I learned:
Like many of us, I have all my students in a Google calendar to remind myself who I’m teaching. It’s fast, free, and you can use it on all your devices.
I also keep a spreadsheet of all the lessons I’ve taught to make sure I don’t miss anything out come tax day. But updating the spreadsheet is a pain in the arse.
So I made an applet on IFTTT. It’s really simple: If one thing happens, another thing happens. In this case:
(IF THIS:) If an event on my Google calendar is about to begin,
(THEN THAT) it prints out a line to a Google spreadsheet with the date, name of student and teacher who taught the lesson.
Now, when I check on my admin sheet, all my lessons are already laid out. That’s 700 lines of text that I didn’t have to write, and loads of hours of admin saved. All for free.
Let me know if you have any questions – I’d be happy to help you set it up for yourselves. Just wanted to preach about how much I love it.