I currently use Google Sheets to catalog our payment information and customer information, both for book-keeping purposes and for coaches to view class rosters including
| Student's name | Parent's name | Email Address | followed by columns for each month filled in with the amount they paid.
I currently update this by hand and am hoping there is a way to populate this format I have created with information from our our Wordpress/Woocommerce Website.
If possible I would like to be able to:
-Sort the raw payment information these sources give (.csv) and filter it into the appropriate spots, whether that's different "tabs" per coach or separate sheets entirely.
-Automatically Create Weekly Attendance rosters based on active students (2 or fewer months behind) for coaches to mark.
-Automatically Send Weekly Mass Emails based on the active roster, different mass email each week.
-Automatically populate a positive or negative indication of completion of a certain Form(s) on the appropriate coaches roster based on email address
-Automatically Send a monthly mass reminder email about due payments for variable amounts listed out on a coaches roster, sent only to emails with no payment recorded.
Looking for an individual skilled in both JavaScript and The Google Apps Script Editor and functions. less
Hi, I am really interested in your project as a highly skilled web developer
I am experienced in working with Google Apps Script for G Suite(Sheet, Doc)
I am sure that you will know about my skills/experiences while working on chrome extension task
I ensure all my works
Please contact me for a more detailed discussion
Thanks
Denis
$60 USD v 3 dneh
5,0 (4 ocen)
2,3
2,3
2 freelancerjev je oddalo ponudbo s povprečno vrednostjo $58 USD za to delo
Hey, I can do this easily for you. I'm a university student and a Javascript expert. For my univserity's IT department I made a similar program for checking off AV eqiupment in classrooms and storing all the data in a Google Sheet.