Spliting payments with friends? Keep track of payments and send automated email reminders via a simple and easy Google sheet template and a Google Apps Script.
Just fill in the sheet template and copy the js & html into its Apps Scripts.
- ✔️ Simple, ready to use Google Sheet template
- ✔️ Calculates total payments
- ✔️ Ready to run Google Apps script
- ✔️ Simple HTML template for emails
- ✔️ Sends out reminder emails to other members
- ✔️ Sends payment status report email to owner
- Download the xlsx file and upload to your Google Drive.
- Fill in the Google Sheet template.
- File > Save as Google Sheets. This will copy the xlsx into a Google sheet file so that you can use a Google Apps Script with it.
- Extensions > Google Apps Script to start installing the scripts.
- Paste all of notifyPeople.js into Code.gs
- Hit
+and add a new HTML file. Name it notifyEmail and paste all of notifyEmail.html. Do the same for ReportEmail.html. - Before this script runs properly, it needs to be authenticated. Click
runand you'll see a pop up to authenticate &review permissions. - This window like below will appear (yes, this is perfectly normal). This is to authorize the Apps Script application to access the sheet when running it for the first time. Choose an account & click allow. Click on show advanced & Go to [your project title].
Add a Trigger to allow your script to run automatically periodically. In the Apps Script page of your script,
- Click on
Triggerson the left toolbar menu with the clock icon. + Add Triggeron the bottom right.- Fill the form as below. Set the non-highlighted ones to your requirements.
- Things under the
EDITcomments can be customized to your liking. - Links to the sheet can be inserted in the html of the emails.
If you found this helpful, please consider giving this a ⭐ on Github and share it with your friends
If you have any feedback, please reach out at mmagsmbol@gmail.com or issue a pull request
Thank you