Google Forms and Google Apps Script
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md
form-limiter.js
form-notifications.js
form-pdf.js

README.md

1. Google Forms Email Notifications

This Google Apps Script lets the owner of Google Form automatically send email notifications when a form is submitted. You can email one or more recipients in CC or BCC as well.

Open the Google Spreadsheet associated with the Form, go to Tools > Script Editor and paste the Apps Script code. You need to Run > Initialize to setup the Form Submit trigger.

2. Google Form Limiter

Use Google Apps Script to easily schedule your Google Form. You can configure the form to automatically open and/or close at a certain date and time. Similarly, the script can be configured to turn off your form after a certain number of responses have been submitted.

Open the Google Form in edit mode, go to the Script editor and paste the code. Choose Run > Initialize to setup the clock and form submit triggers.

3. Google Forms PDF Generator

Use Google Apps Script to generate PDF documents from Google Forms responses. You can configure the script to automatically email the generated PDF as a file attachment via the Gmail service. The Google Docs template should include placeholders enclosed inside double angle brackets like <<First Name>> and these should match the question titles in the Google Form.

Open the Google Spreadsheet associated with the Google Form, go to the Script editor and paste the code. Choose Run > Initialize to setup the form submit trigger.

Requirements

Google Apps Script Developer 👨🏼‍💻

Amit Agarwal is a web geek and author of labnol.org, a popular tech how-to website. He frequently uses Google Apps Script to automate workflows and enhance productivity.

Reach him on Twitter @labnol or email amit@labnol.org