A free solution for signing document with Google Workspace & Apps Script: GAS109
Introduction
If you are looking for a free solution to sign the document with Google Forms, you may check this one. By using Google Forms & Apps Script, we send the respondent an email with the sign request which is a Web App.
Demo
Try to submit this form below to get an email for signing:
https://forms.gle/Z2kM3y4CiFiKnCD68
An email to the respondent:
Sign App:
Signed Email:
Configurations
App Settings:
| App: | ||
| name | FormSign | |
| url | Update with yours | The URL of the sign web app |
| urlDocumentPub | Update with yours | The URL of the document for user to view in the web app |
| urlDocument | Update with yours | The URL of the document template for user to sign (support placeholders in file name) |
| urlFolder | Update with yours | The URL of the folder for saving the signed document |
| headerEmail | Email Address | The field name in the form for email address to the respondent |
| headerName | Full Name | The field name in the form for the respondent |
| headerUuid | _uuid | Added column by the script |
| headerSignStatus | _signStatus | Added column by the script |
| headerSignUrl | _signUrl | Added column by the script |
| headerSignedDate | _signedDate | Added column by the script |
| headerSignedDocument | _signedDoc | Added column by the script |
| headerSignedPdf | _signedPdf | Added column by the script |
| Signature: | ||
| signaturePlaceholder | {{signature}} | The placeholder in the sign document template |
| signatureWidth | 200 | The signature image width in the signed document |
| Sign Email: | ||
| signSubject | New FormSign Request {{Full Name}}: GAS0109 | Support placeholders |
| signBody | Hi {{Full Name}}, Use this link below to sign the document.<a href=”{{_signUrl}}”>Sign</a> Thanks,Ashton | Support HTML body & placeholders |
| [signBcc] | Comma-separated email addresses | |
| Signed Email: | ||
| signedEmailEnabled | TRUE | Send the email to user after sign |
| signedSubject | Signed by {{Full Name}} with FormSign: GAS109 | Support placeholders |
| signedBody | Hi {{Full Name}}, You’ve signed the document successfully.<a href=”{{_signUrl}}”>Sign Status</a> Thanks,Ashton | Support HTML body & placeholders |
| [signedBcc] | Comma-separated email addresses | |
| [includeSignedPdf] | TRUE | Attach the signed PDF as an attachment in the email |
Deployment
- Make a copy of my project from this link.
- Install the trigger from the custom menu “FormSign”.
- Open “Apps Script” by going “Extensions > Apps Script” in the menu of the copied Spreadsheet.
- Create a new Deployment for “Web App” and complete the authorization process for the first time.
- Update URLs in the “Settings” tab with your own links.
