Free Solution for Doc Sign with Google Forms, Docs, Sheets, and Gmail: GAS109

August 18, 2024

Free Solution for Doc Sign with Google Forms, Docs, Sheets, and Gmail: GAS109

Introduction

If you are looking for a free solution to sign your document with Google Forms for you users, you may find the right place. In this Google Apps Script project, I am sharing a workaround using Google Forms to collect data from users and email then a sign request URL for collecting their signature.

YouTube

Check this project introduction video on YouTube if you prefer to watch video instructions.

Demo

Try to submit this form below to get an email for signing.

https://forms.gle/Z2kM3y4CiFiKnCD68

You will be sent with a similar email like this, and you can try the sign link to add your signature.

How you can add your signature in the sign web app.

You will be sent with a signed email with the signed document. We can have placeholders in the document, and the value we collect from the form can be used to replace these placeholders.

Instructions (6 Steps)

Follow the steps below to set up your own project.

Step 1

Make a copy of my project to your Google Drive with the link below.

FormSign - Document Signature with Google Forms: GAS109

* The linked form in my project will not be copied to yours, make sure you create a form on your Google Drive and link it to the copied Google Sheets.

Step 2

Complete the authorization step by clicking any of the buttons from the menu “FormSign”. Follow the guide below if this is new to you.

A Complete Guide to Authorize GAS Project

Step 3

Install the trigger from the custom menu “FormSign”. It will create a trigger to watch the form submit events in the form which is linked to the Google Sheets, for sending the email with the sign request URL.

Step 4

Deploy the project as a web app for the sign request URL, you will get the URL after the deployment. Follow the guide below if you are not familiar with the deployment process.

A Complete Guide to Deploy GAS as Web App

Step 5

Update URL in the “Settings” tab with your own Web App URL in cell B5.

Step 6

Other configurations in the “Settings” tab. Check the notes in column C and don’t change the keys in column A since they are used in the script. Submit a test from your form to run a test, if everything is set up correctly, you should be able to see the similar email in the demo section above.