So for context, I'm working on a project where we have 80 schools with 4000 students and 400 mentors that we have matched up to have coaching sessions in 3 weeks.
Each school has their own business account with microsoft, that we have added for them.
I have a spreadsheet for each school, with 100 students on for example. That have the date, time, the title for their meeting, and the email address of the mentor.
I need a way to automate adding all 100 meetings for that school, in a calendar that I own and control, across 5 days. I am struggling, please help
In essence, I need to figure out a way to book in up to 100 meetings, from an csv or spreadsheet into a calendar, and invite 100 separate people to 100 separate meetings

Report
All responses (
Answers (