Skip to content

patbiber/gsuite-serial-letter

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

gsuite-serial-letter

G Suite Add-On for creating Serial Letters using Google Spreadsheets and Google Docs

How it works

  • Import your user data as csv in Google Spreadsheets
  • You can create Letter Templates in Google Docs with the syntax {{ key }} where key corresponds to the column of the csv file
  • The Add-On creates a folder with all the personalized letters as pdfs' that you can download or share
  • The Add-On interface is currently in german, since it is used in a german organisation, feel free to fork and change it
  • Not in the Chrome Web store because you have to pay for it

Getting Started

  1. Create a new project at: https://script.google.com/, if it is asking for the document type, use Spreadsheet
  2. Copy the code from the github and paste it into the Google Script project (code.gs, template.html)
  3. Test if it works:
  4. If its working fine, deploy it by going to 'publish > Provide as Web Add-on for Google Docs' and follow the instructions

Screenshots

https://docs.google.com/document/d/16pyYak3txJCaTSwKxSQrOykGRXNZZbQaUT4xm_p_-0s/edit#

About

GSuite Add-On for creating Serial Letters

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • HTML 57.4%
  • JavaScript 42.6%