Sending an email to wish your customers a happy birthday it's usually a thing that big companies do. There is a good reason for that, it's an expensive upgrade to the system you are using, or simply you need to get an external app and pay a monthly subscription.But, you can make your own system for free using only a simple script and a Google Spreadsheet. This automated … [Read more...] about Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
Embed Google Form, Sheet, Chart and Doc in WordPress
You have a plugin for that too, but adding more plugins to your WordPress site can make it slower, and trust me, you don't need one for this. It's easy and you don't have to be an expert to throw in a Google Form or a chart from a Google Spreadsheet to your WordPress post. Embed a Google Form in WordPress post (classic and block editor) First, you need to get the embed code of … [Read more...] about Embed Google Form, Sheet, Chart and Doc in WordPress
Google Form Script to AutoFill and Email a Doc Template
I have used a similar solution for creating documents from a template, but it was a spreadsheet script and used a sheet as a template. Later on, I switch to a Google Doc template, as it was easier for my coworkers to change the content.Since nobody here was interested in the spreadsheet, I decided to readapt the Script to work from Google Form and directly create the … [Read more...] about Google Form Script to AutoFill and Email a Doc Template
Add Timer in Google Form Quiz
Finally, I found a way to add a timer to a google form, and yes, it forces the user to submit the form after a given time. It's not like all the other plugins that will only close the form to not accept responses and the users that are in the process of filling in the form will lose their answers. Imagine the student who spends an hour answering the question to be only 1 minute … [Read more...] about Add Timer in Google Form Quiz
Create an Issue Tracking System with Google Form and Spreadsheet
Based on the solution in this how-to you will be able to build a Ticketing System, also known as Issue Tracking System, using Google Form, Google Spreadsheet, and Google Script. The solution is very simple to implement and you can easily add some more functionality and use it on the go.Basically, with this Issue tracking system you can:Open a TicketEnter the Issue … [Read more...] about Create an Issue Tracking System with Google Form and Spreadsheet