フラッシュカード

function myFunction() {
  
  const fontSize = Browser.inputBox('フォントサイズを入力してください:', Browser.Buttons.OK_CANCEL);

  if (fontSize === 'cancel' || fontSize === '') {
    return;
  }

  const spreadsheetId = '';
  const slideDeckId = '';

  const sheet = SpreadsheetApp.openById(spreadsheetId).getSheets()[0];
  const data = sheet.getDataRange().getValues();

  const slideDeck = SlidesApp.openById(slideDeckId);

  const templateSlide = slideDeck.getSlides()[0];

  const pairs = [];
  for (let i = 1; i < data.length; i++) {
    const question = data[i][0];
    const answer = data[i][1];
    pairs.push([question, answer]);
  }

  pairs.sort(() => Math.random() - 0.5);

  pairs.forEach(pair => {
    const question = pair[0];
    const answer = pair[1];

    const questionSlide = slideDeck.appendSlide(templateSlide.getLayout());
    const questionTextBox = questionSlide.getShapes()[0].getText();
    questionTextBox.setText(question);
    questionTextBox.getTextStyle().setFontSize(Number(fontSize));

    const answerSlide = slideDeck.appendSlide(templateSlide.getLayout());
    const answerTextBox = answerSlide.getShapes()[0].getText();
    answerTextBox.setText(answer);
    answerTextBox.getTextStyle().setFontSize(Number(fontSize));
  });

  templateSlide.remove();
}