How to design a quiz

[deshudesham]

How do I design thousands of different MCQ quizzes, assign grading to answers, save user scores, all of this from data saved on a google sheet.

also if I can put a 30 second timer for each question

the data has column names such as 

quiz topic A

question 1

option 1

option 2

option 3

option 4

correct option

question 2

option 1

option 2

option 3

option 4

correct option

quiz topic B

question 1

option 1

option 2

option 3

option 4

correct option

question 2

option 1

option 2

option 3

option 4

correct option

And so on