It's not that easy to find free certificate templates online, there are a lot of results, but a few of them are really free, also there are almost no templates in spreadsheet format. So, I have decided to share my Google Sheets certificate template together with a script that will help you to do a Print Merge and get the Certificates in PDF or send them automatically … [Read more...] about Google Sheets Free Certificate Templates + Print Merge Script (email/PDF)
Sheets
Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
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
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:I have also created a Google … [Read more...] about Create an Issue Tracking System with Google Form and Spreadsheet
Create an Inventory Management System with Google Form and Spreadsheet
I know you have your Spreadsheet where you track your Stock/Inventory list and probably you have formulas there to do analysis on the data, and some pivot tables and charts. But you have to be on your computer to add or reduce the quantity or check the current status. This solution is very simple and you can use it on your mobile and check the Inventory on the go.With this … [Read more...] about Create an Inventory Management System with Google Form and Spreadsheet