testq

// Google Apps Script for Google Sheets to Blogger Mock Test Posting function sendMockTestToBlogger() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const data = sheet.getDataRange().getValues(); const email = "utsavbanajiclass.mocktest@blogger.com"; // Your Blogger email const title = data[1][9]; // Column J (Title) const timeLimit = data[1][8]; // Column I (Time in minutes) let questionsHtml = ""; let navButtons = ""; let solutionsHtml = ""; for (let i = 1; i < data.length; i++) { if (!data[i][1]) continue; const qNum = data[i][0]; const question = data[i][1]; const options = data[i].slice(2, 6); const correct = data[i][6]; const solution = data[i][7]; // Question block questionsHtml += `

${qNum}. ${question}

${options.map((opt, idx) => ` ${opt}`).join("
")}

`; // Navigation navButtons += ``; // Solutions solutionsHtml += `

Q${qNum}. Correct Answer: ${correct}. Solution: ${solution}

`; } const htmlBody = `

Welcome to ${title}

${questionsHtml}

${timeLimit}:00

${navButtons}

Test Completed

${solutionsHtml}

Share on WhatsApp

`; GmailApp.sendEmail(email, title, "", { htmlBody: htmlBody }); }