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

How to G Apps

Your life changer for G Apps

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

Apps Script

Google Form Script to AutoFill and Email a Doc Template

August 31, 2020 By SavoE 22 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 to Google Form Quiz

August 21, 2020 By SavoE 18 Comments

add timer to google form quiz

Finally, I fund 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 to Google Form Quiz

Create an Issue Tracking System with Google Form and Spreadsheet

August 3, 2020 By SavoE 57 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 Leave a 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

Create an Inventory Management System with Google Form and Spreadsheet

July 12, 2020 By SavoE 84 Comments

create inventory management system f

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

Google Sheets Script for Auto Numbering Google Form Responses

June 4, 2020 By SavoE 80 Comments

Google Sheets Script for Auto Numbering Google Form Responses

In the previous article, Add Auto Number to Google Form Response Sheet, we used a formula to automatically add numbers to Google Form responses in the sheet. The formula was easy to implement and you can also use text mixed with numbers. But the main problem with using this solution is that it always resets the numbering, so if you delete a response all the following responses … [Read more...] about Google Sheets Script for Auto Numbering Google Form Responses

Create a Script to Send Emails from Google Sheet

May 22, 2020 By SavoE 2 Comments

Create a Script to Send Emails from Google Sheet

Sending the same email but with some personalized content to a group of people can be a boring and time-consuming process. The best solution to this is to have all the data in the sheet and use a process called MailMerge. But this option is not available in google sheets. So,  in this how-to, we will create a script to send emails from google sheet using the data from the … [Read more...] about Create a Script to Send Emails from Google Sheet

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

March 5, 2020 By SavoE 407 Comments

script to create and email a PDF

In this how-to, we will use a script to create and email a PDF on Form submission automatically. So, this script is going to be triggered by submitting the Google Form and it will convert the sheet in PDF. In the next steps, the script is going to save the PDF in your Drive and send it as an attachment in an email.Check this article if you want to AutoFill and Email a Doc … [Read more...] about Google Spreadsheet Script to create and email a PDF on Form Submission

Primary Sidebar


Inspire me to keep the website up and running.

Latest How Tos

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

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

publish to the web Google Sheets

Embed Google Form, Sheet, Chart and Doc in WordPress

print Ctrl+P summary of responses

Share Google Forms Summary of Responses Without Giving Access

list of classes in Google Meet

How to Use Google Meet for Distance Learning

Add Auto Number to Google Form Response Sheet

generate invoice google forms and sheets

Generate Invoices using Google Form and Sheets

Recent Comments

  • Hossam on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Fulvio on Create an Issue Tracking System with Google Form and Spreadsheet
  • Fulvio on Create an Issue Tracking System with Google Form and Spreadsheet
  • SavoE on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Hossam on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Hossam on Google Spreadsheet Script to create and email a PDF on Form Submission
  • Sapna Jha on Create an Issue Tracking System with Google Form and Spreadsheet
  • Uday on Add Auto Number to Google Form Response Sheet
  • SavoE on Google Spreadsheet Script to create and email a PDF on Form Submission
  • SavoE on Google Spreadsheet Script to create and email a PDF on Form Submission


Inspire me to keep the website up and running.

Copyright © 2021 · How to Gapps

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT