Google Docs doesn't have the Print Merge or a Mail Merge option available, so if you want to create multiple documents from the data you have in your spreadsheet you have to use an Add-on. Usualy these add-ons have limited options and are missing some of the needed functions. I have been using this Google spreadsheet script to do a Print merge for a while and I have made small … [Read more...] about Print Merge or Mail Merge for Google docs
Sheets
Google Sheets Free Certificate Templates + Print Merge Script (email/PDF)
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)
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