Payslip

Introduction

Payslip is Container-bound Script, for google sheet. It can help you send payslips only by one button click! Enjoy 😉

Installing

1. To create a bound script, open a Google Sheets file, then select Tools > Script editor. To reopen the script in the future, do the same thing. Because bound scripts do not appear in Google Drive, that menu is the only way to find or open the script.
2. Set some name for your project (a top left corner).
3. Copy all files from src folder to your project. You can manually create scripts files in the project and copy-paste files names and files contents. Or use clasp for this purpose.
4. Remove initially created .gs file from the project.
5. Close script editor tab and reload sheet page. After these manipulations you will see new menu item - Payslip Manager. You on the right way 🤘

Setting up

1. Open Payslip > Settings. In field Duplicate message to insert appropriate email.
2. Push the button Save settings.
3. In local project folder, go to assets. Import file Payslip Template.docx in to your Google docs.
4. Open your Gmail and create empty email draft.
5. Copy all content of the file in Google docs into this email draft.
6. Add some subject to the your draft. Example: MC: Payslip for {{month}} {{name}}.

7. Add label payslip-template to this draft.

8. Close the draft email.

Done 🏆