Password defend PDF paperwork generated from Google Sheets. Add distinctive passwords to every PDF file and save them securely to Google Drive or ship as e mail attachments.
The Document Studio add-on helps you create customized PDF paperwork from Google Sheets. You’ll be able to generate invoices, certificates, agreements, offer letters, student ID cards and different paperwork in bulk and save them to Google Drive.
Moreover, Doc Studio now provides the choice to defend the generated PDF paperwork with a password.
This performance is especially beneficial in situations the place the generated paperwork include delicate info that require additional safety to cease unauthorized entry. As an illustration, it’s possible you’ll generate invoices, or monetary studies and defend them with a password earlier than sharing them with purchasers or workers.
Add Passwords to PDF Paperwork
Let’s stroll by way of the steps of including passwords to PDF paperwork generated from Google Sheets utilizing Doc Studio.
Put together Wage Knowledge in Google Sheets
We have now a Google Sheet that incorporates the worker’s identify, and the wage quantity. We’ll use Doc Studio to generate particular person PDF wage slips for every worker after which add a password to every PDF doc earlier than saving them to Google Drive.
Create Template in Google Docs
We have now created a wage slip template in Google Docs that incorporates placeholders for the worker’s identify and the wage quantity. The info from Google Sheet will likely be merged into this template to generate particular person PDF paperwork for every worker.
Password Defend PDF Paperwork
Launch Doc Studio in Google Sheets and create a brand new workflow. In case you are new right here, please confer with the step-by-step guide or watch this video tutorial to get began.
Contained in the workflow, select the Google Sheet that incorporates the worker knowledge and the Google Docs template that you’ve ready for the wage slips. Subsequent, choose the folder in Google Drive the place the generated PDF paperwork will likely be saved.
Set the export format to PDF and allow the Password Defend PDF checkbox.
Distinctive Password for Every PDF Doc
You’ll be able to select to make use of a standard password for all of the PDF paperwork or, for added safety, set a singular password for every doc. For this instance, we’ll outline a singular password for every PDF doc utilizing the worker ID and the primary 4 letters of the worker’s identify, all in uppercase.
As an illustration, if the worker ID is E345 and the worker’s identify is Angus, the password for the corresponding PDF doc will likely be E345ANGU.
We’ll make use of Scriptlets to derive a singular password for every PDF doc dynamically.
{{ Worker ID }}{? "{{ Worker Title }}" | slice: 0,4 | upcase ?}The scriptlet above concatenates the worker ID with the first four characters of the worker’s identify, transformed to uppercase.
Generate PDF Paperwork
Save the workflow and run it to generate the PDF wage slips for all workers. The generated PDF paperwork will likely be saved to the desired Google Drive folder and every doc will likely be protected with a singular password.
Additionally see: Take away PDF Password from Gmail Attachments
