From Gut Feel to Data-Driven: Free Script for GenAI-based Content Creation Evals

				
					function exportCommentsForDocLinks() {
// EDIT: The document links shown here are example google docs. Replace them with your own Google Docs URLs (including the /edit suffix). Put as many links as you like.


const DOC_LINKS =["https://docs.google.com/document/d/1-DV55h1Ud5uFiEuIcesIJVsaeJKf3gTgVeI_scga9W4/edit",
"https://docs.google.com/document/d/18Kdpnb52Z8PZ6Mj_o8tr-jTDgMObVc3UwyY4qMYnAqI/edit"];


 if (!DOC_LINKS.length) {
   throw new Error("No document links found. Please add them in DOC_LINKS.");
 }


 // Code creating the output Google Sheet
 const ss = SpreadsheetApp.create("Google Docs Comments Export (Selected Docs)");
 const sh = ss.getActiveSheet();
 sh.appendRow([
   "documentName",      
   "documentGroup",     
   "documentID",
   "documentURL",
   "commentID",
   "createdTime",
   "modifiedTime",
   "resolved",
   "authorName",
   "authorEmail",
   "commentText",
   "commentCharLength",  
   "commentWordCount",   
   "quotedContext",
   "replyCount"
 ]);


 const headers = { Authorization: "Bearer " + ScriptApp.getOAuthToken() };
 let processed = 0;


 // Iterate over each document link or ID


 for (const input of DOC_LINKS) {
   const fileId = extractDocId(input);
   if (!fileId) {
     Logger.log("Skipping (could not parse as Doc ID): " + input);
     continue;
   }


   // Get document metadata (title + URL)
   let fileMeta;
   try {
     fileMeta = Drive.Files.get(fileId);
   } catch (e) {
     Logger.log(`Could not read metadata for ${fileId}: ${e}`);
     continue;
   }


   const docTitle = fileMeta.title || "";
   const docName  = docTitle; 
   const docUrl   = fileMeta.alternateLink || `https://docs.google.com/document/d/${fileId}/edit`;


   const baseUrl =
     `https://www.googleapis.com/drive/v3/files/${encodeURIComponent(fileId)}/comments` +
     `?fields=comments(` +
     `id,createdTime,modifiedTime,resolved,` +
     `author(displayName,emailAddress),` +
     `content,quotedFileContent/value,replies(id)` +
     `)&pageSize=100&includeDeleted=false`;


   let pageToken = null;
   do {
     const url = baseUrl + (pageToken ? `&pageToken=${encodeURIComponent(pageToken)}` : "");
     const res = UrlFetchApp.fetch(url, { headers });
     const json = JSON.parse(res.getContentText());


     const comments = json.comments || [];
     for (const c of comments) {
       const text = (c.content || "").toString();
       const charLen = text.length;
       const wordCount = text.trim() ? text.trim().split(/\s+/).length : 0;


       sh.appendRow([
         docName,
         docTitle,
         fileId,
         docUrl,
         c.id || "",
         c.createdTime || "",
         c.modifiedTime || "",
         c.resolved === true,
         (c.author && c.author.displayName) || "",
         (c.author && c.author.emailAddress) || "",
         text,
         charLen,
         wordCount,
         (c.quotedFileContent && c.quotedFileContent.value) || "",
         (c.replies || []).length
       ]);
     }


     pageToken = json.nextPageToken || null;
   } while (pageToken);


   processed++;
 }


 SpreadsheetApp.flush();
 Logger.log(`Done. Processed ${processed} document(s).`);
 Logger.log(`Sheet URL: ${ss.getUrl()}`);
}


/** Extract a Google Doc ID from:
*   - /document/d/{ID}
*   - ?id={ID}
*   - bare IDs */


function extractDocId(input) {
 if (!input) return null;


 // Normalize: coerce to string, strip quotes/brackets, zero-width, etc.
 let s = String(input)
   .replace(/[\u2018\u2019\u201A\u201B\u2032]/g, "'")
   .replace(/[\u201C\u201D\u201E\u2033]/g, '"')
   .replace(/[\u00A0\u2000-\u200A\u202F\u205F\u3000]/g, ' ')
   .replace(/[\u200B-\u200D\uFEFF]/g, '')
   .trim()
   .replace(/^[<\[\(\{"'\s]+|[>\]\)\}"'\s]+$/g, "");


 const idLike = /^[A-Za-z0-9_-]{20,200}$/;


 // /document/d/{ID}
 const mPath = s.match(/\/document\/d\/([A-Za-z0-9_-]{20,200})/);
 if (mPath && mPath[1]) return mPath[1];


 // ?id={ID}
 const mQuery = s.match(/[?&]id=([A-Za-z0-9_-]{20,200})/);
 if (mQuery && mQuery[1]) return mQuery[1];


 // Bare ID
 if (idLike.test(s)) return s;


 // Fallback: longest ID-like token in string
 const candidates = s.match(/[A-Za-z0-9_-]{20,200}/g) || [];
 if (candidates.length) {
   candidates.sort((a, b) => b.length - a.length);
   const best = candidates.find(tok => !/^(utm_|gclid|fbclid)/i.test(tok)) || candidates[0];
   if (idLike.test(best)) return best;
 }


 return null;
}


// Debug helper: Logs character codes of a string (for diagnosing hidden 


function _debug_chars(str) {
 const codes = Array.from(String(str)).map(ch => ch + " U+" + ch.charCodeAt(0).toString(16).toUpperCase());
 Logger.log(codes.join(" | "));
}