coder0107git

Creating Quizzes in Google Form using Google Forms Service with Google Apps Script

This is a sample script for creating quizzes in Google Form using Google Forms Service with Google Apps Script.

Usage

1. Prepare questions and answers.

coder0107git

const USERS_SHEET_NAME = "users",
    TASKS_SHEET_NAME = "tasks",
    SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/abc123456/edit", /* TODO(Developer): Replace the spreadsheet ID */
    /* Use `SpreadsheetApp.getActiveSpreadsheet()` if the Apps Script was created from a Google Sheet. */
    spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);

const getEmailByNickname = (() => {
    const usersSheet = spreadsheet.getSheetByName(USERS_SHEET_NAME);
          
    let userEmailTable = {};