• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Forms
  • Sheets
  • General
  • Drive
  • Gmail
  • Sites
  • Apps Script
How to GApps

How to GApps

Your life changer for G Apps

  • About
  • Contact
  • Terms and Conditions
  • Privacy Policy
  • COOKIE POLICY

Apps Script

Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email

March 3, 2021 by SavoE 9 Comments

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

Google Form Script to AutoFill and Email a Doc Template

August 31, 2020 by SavoE 26 Comments

Google Form Script to Auto Fill 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

August 21, 2020 by SavoE 22 Comments

add timer to 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

August 3, 2020 by SavoE 179 Comments

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

Google Script Authorization: Review and Accept the Permission Guide

July 15, 2020 by SavoE 1 Comment

Review and Accept the Permission Guide

Every time you use a Google apps script class in your script that accesses your account or data, Google will inform you and ask for your consent. Also, every time you add a new class that accesses your data you will have to go through the process again.This process is not straight forward like click here to accept permissions, you will have to deal with a couple of dialogs, … [Read more...] about Google Script Authorization: Review and Accept the Permission Guide

« Previous Page
Next Page »

Primary Sidebar

Follow me on Twitter

Follow @HowToGApps

More to See

Google Sheets Script for Auto Numbering Google Form Responses

Google Sheets Script for Auto Numbering Google Form Responses

print Ctrl+P summary of responses

Share Google Forms Responses Without Giving Access

Create a Script to Send Emails from Google Sheet

Create a Script to Send Emails from Google Sheet

list of classes in Google Meet

How to Use Google Meet for Distance Learning

script to create and email a PDF

Google Spreadsheet Script to create and email a PDF on Form Submission

Recent Comments

  • Chandan Sharma on Create an Issue Tracking System with Google Form and Spreadsheet
  • yaya on Google Sheets Script for Auto Numbering Google Form Responses
  • SavoE on Create an Issue Tracking System with Google Form and Spreadsheet
  • Roy Stefanussen on Create an Issue Tracking System with Google Form and Spreadsheet
  • SavoE on Create an Issue Tracking System with Google Form and Spreadsheet

Buy Me A Coffee
Inspire me to keep the website up and running.




Footer




Recent

  • Google Spreadsheet Prank
  • Print Merge or Mail Merge for Google docs
  • Google Sheets Free Certificate Templates + Print Merge Script (email/PDF)
  • Google Form to Slides + Save to Drive and/or send it in email as a PDF
  • Google Form Script to Automatically Add New Choices from “Other:” Form Responses

Search

Copyright © 2022 · How to Gapps