LeetCode2Anki Plus

A key feature of LeetCode2Anki Plus is the comprehensive Google Sheets integration that automatically tracks your solved problems:

• Automated Tracking: Every solved problem automatically logged with timestamps and details
• Progress Visualization: See patterns in your problem-solving journey
• Topic Coverage: Easily identify which problem categories need more practice

Complete these steps to set up the Google Sheets integration:

1. Go to Google Apps Script (sign in with your Google account)
2. Click "New project" to create a new Apps Script project
3. Replace the default code with the code provided below
4. Select the doRequest function from the dropdown menu as the function to run
5. Click the disk icon to save (or press Ctrl+S/Cmd+S)
6. Name your project (e.g., "LeetCode2AnkiTracker")
7. Create a Google Sheet by going to Google Sheets
8. Name the first 7 columns: Timestamp, ID, Title, Difficulty, Tags, URL, Status
9. Copy the spreadsheet ID from the URL (the long string between /d/ and /edit)
10. Replace YOUR_SPREADSHEET_ID in the Apps Script code with your actual spreadsheet ID
11. Deploy the web app by clicking "Deploy" > "New deployment"
12. Select "Web app" as the deployment type
13. Set "Execute as" to "Me"
14. Set "Who has access" to "Anyone" and click "Deploy"
15. Copy the web app URL - you'll need it for the script configuration

/**
 * Main entry point for web requests
 * This function delegates to the appropriate handler based on the HTTP method
 */
function doRequest(request) {
  const method = request.method || 'GET';
  
  if (method === 'POST') {
    return doPost(request);
  } else if (method === 'OPTIONS') {
    return doOptions(request);
  } else {
    return doGet(request);
  }
}

/**
 * Handles OPTIONS requests for CORS preflight
 */
function doOptions(e) {
  var lock = LockService.getScriptLock();
  lock.tryLock(10000);
  
  var headers = {
    'Access-Control-Allow-Origin': '*',
    'Access-Control-Allow-Methods': 'POST, GET, OPTIONS',
    'Access-Control-Allow-Headers': 'Origin, X-Requested-With, Content-Type, Accept',
    'Access-Control-Max-Age': '3600'
  };
  
  return ContentService
    .createTextOutput(JSON.stringify({"status": "success"}))
    .setMimeType(ContentService.MimeType.JSON)
    .setHeaders(headers);
}

/**
 * Handles GET requests - returns a simple status for testing
 */
function doGet(e) {
  var headers = {
    'Access-Control-Allow-Origin': '*'
  };
  
  return ContentService
    .createTextOutput(JSON.stringify({
      "status": "online", 
      "message": "Google Sheets API is running"
    }))
    .setMimeType(ContentService.MimeType.JSON)
    .setHeaders(headers);
}

/**
 * Handles POST requests from the userscript
 * Adds the problem data to a Google Sheet
 */
function doPost(e) {
  // Set CORS headers
  var headers = {
    'Access-Control-Allow-Origin': '*',
    'Access-Control-Allow-Methods': 'POST, GET, OPTIONS',
    'Access-Control-Allow-Headers': 'Origin, X-Requested-With, Content-Type, Accept'
  };
  
  try {
    // Replace with your sheet ID
    const sheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").getActiveSheet();
    const data = JSON.parse(e.postData.contents);
    
    // Validate required fields
    if (!data.id || !data.title) {
      return ContentService
        .createTextOutput(JSON.stringify({
          "error": "Missing required fields",
          "result": "error"
        }))
        .setMimeType(ContentService.MimeType.JSON)
        .setHeaders(headers);
    }
    
    // Process the tags array
    let tagsString = "";
    if (data.tags && Array.isArray(data.tags)) {
      tagsString = data.tags.join(", ");
    }
    
    // Add additional fields for performance metrics
    const solveTime = data.solveTime || "";
    const firstAttempt = data.firstAttempt || "";
    const confidence = data.confidence || "";
    
    sheet.appendRow([
      new Date(),
      data.id || "",
      data.title || "",
      data.difficulty || "",
      tagsString,
      data.url || "",
      data.status || "Pending",
      solveTime,
      firstAttempt,
      confidence
    ]);
    
    return ContentService
      .createTextOutput(JSON.stringify({
        "result": "success",
        "message": "Data saved successfully"
      }))
      .setMimeType(ContentService.MimeType.JSON)
      .setHeaders(headers);
      
  } catch (error) {
    return ContentService
      .createTextOutput(JSON.stringify({
        "error": error.toString(),
        "result": "error"
      }))
      .setMimeType(ContentService.MimeType.JSON)
      .setHeaders(headers);
  }
}

To install the LeetCode2Anki Plus script, you need a userscript manager extension for your browser:

1. Install a userscript manager:
   • Tampermonkey (recommended, works on Chrome, Firefox, Edge, Safari)
   • Violentmonkey (alternative for Firefox/Chrome)
   • Greasemonkey (Firefox only)
2. After installing the extension, click the "Install Script" button below to automatically install LeetCode2Anki Plus
3. When the userscript page opens in your userscript manager, click the "Install" or "OK" button
4. Navigate to any LeetCode problem page to start using it

After installing the script, you need to customize it with your own settings:

1. Open your userscript manager (e.g., click on the Tampermonkey icon in your browser)
2. Select "Dashboard" and then find and edit "LeetCode2Anki Plus"
3. Look for the configuration section at the top of the script:
4. // Configuration - Customize these values
   const deckName = 'LeetCode'; // Your Anki deck name
   const modelName = 'Basic - LeetCode2Anki'; // Your Anki model name
   const language = 'Python'; // Your preferred programming language
   const langShortName = 'py'; // Language code for syntax highlighting
   const googleScriptUrl = 'YOUR_SCRIPT_URL'; // Paste your Google Apps Script URL here
5. Update the variables with your own values:
   • deckName: The name of your Anki deck (create this in Anki if it doesn't exist)
   • modelName: The name for the card template (can leave as default)
   • language: Your preferred programming language (e.g., Python, JavaScript, Java)
   • langShortName: Short code for your language (py for Python, js for JavaScript)
   • googleScriptUrl: The web app URL from your Google Apps Script deployment
6. Save the script (Ctrl+S or Cmd+S)