スプレッドシートで GitHub の Issue を作成

				
					  ```javascript
   // リクエストボディ
   const create_request = (userName, repository, accesstoken) => {
     return (payload) => ({
       url: `https://api.github.com/repos/${userName}/${repository}/issues`,
       method: "post",
       headers: {
         Authorization: `token ${accesstoken}`,
       },
       payload: payload,
     });
   };

   // スプレッドシートの情報取得
   const get_issues = () => {
     const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
     const sheet = spreadsheet.getActiveSheet();
     const issueCount = sheet.getLastRow() - 1;
     const range = sheet.getRange(2, 1, issueCount, 4);
     const sheetRows = range.getValues();
     return sheetRows.map((row) => ({
       title: row[0],
       body: row[1],
       assignee: row[2],
       labels: row[3] ? row[3].split(",") : [],
     }));
   };

   // issue作成
   const create_issues = () => {
     const issues = get_issues();

     const userName = "user_name";
     const repository = "repository_name";
     const accessToken = "access_token";
     const request = create_request(userName, repository, accessToken);
     const requests = issues.map((issue) => request(JSON.stringify(issue)));
     UrlFetchApp.fetchAll(requests);
   };

   // スプレッドシートを開いた際に自動で実行される
   const onOpen = () => {
     // カスタムメニューの追加
     const ui = SpreadsheetApp.getUi();
     ui.createMenu("カスタムメニュー")
       .addItem("Issue作成", "create_issues")
       .addToUi();
   };
   ```