Google Sheets Student Awards & Certificates System

Job ID: 39020128

Budget: $30 – $100 AUD

I need a Google Sheets expert to help me complete a student awards spreadsheet I've started. The goal is to create a system that allows schools to easily enter student awards, assign awards based on a level system (bronze, silver, gold, platinum, diamond, School pin), and then automatically mail merge to print certificates.

The spreadsheet should store the following information for each student:
- Name and ID number
- Award level and date
- Teacher's name and comments

Ideally, you have experience with Google Sheets and script coding, and can help me solve the issues I have encountered. Your skills should include understanding of:
- Spreadsheet design
- Google Sheets coding
- Mail merge process

I am looking forward to finding a freelancer who can help me finalize and optimize this project.