function listWebFiles() {

  var folderName = 'Web Files'; // Change to your folder name

  var folders = DriveApp.getFoldersByName(folderName);

  var hasFolders = false;

  var data = [

    ['Name', 'Link', 'Date Created', 'Time Created', 'File Size (KB)', 'Word Count (Docs)', 'Character Count (Docs)']

  ];

  while (folders.hasNext()) {

    hasFolders = true;

    var folder = folders.next();

    Logger.log('Processing folder: ' + folder.getName());

    var files = folder.getFiles();

    while (files.hasNext()) {

      var file = files.next();

      var created = file.getDateCreated();

      var fileSizeKB = (file.getSize() / 1024).toFixed(2);

      var wordCount = 'N/A';

      var charCount = 'N/A';

      // Get counts for Google Docs only

      if (file.getMimeType() === MimeType.GOOGLE_DOCS) {

        try {

          var doc = DocumentApp.openById(file.getId());

          var bodyText = doc.getBody().getText();

          wordCount = bodyText.trim().split(/\s+/).length;

          charCount = bodyText.length;

        } catch (e) {

          Logger.log('Error processing Doc ' + file.getName() + ': ' + e.message);

          wordCount = 'Error';

          charCount = 'Error';

        }

      }

      data.push([

        file.getName(),

        file.getUrl(),

        Utilities.formatDate(created, Session.getScriptTimeZone(), 'yyyy-MM-dd'),

        Utilities.formatDate(created, Session.getScriptTimeZone(), 'HH:mm:ss'),

        fileSizeKB,

        wordCount,

        charCount

      ]);

    }

  }

  if (!hasFolders) {

    Logger.log('Folder not found.');

    return;

  }

  // Output to spreadsheet

  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

  if (!spreadsheet) {

    Logger.log('No active spreadsheet. Creating a new one.');

    spreadsheet = SpreadsheetApp.create('Web Files List');

  }

  var sheet = spreadsheet.getActiveSheet() || spreadsheet.insertSheet();

  sheet.clear();

  sheet.getRange(1, 1, data.length, data[0].length).setValues(data);

  Logger.log('Data written to sheet. Rows: ' + data.length);

  Logger.log('Spreadsheet URL: ' + spreadsheet.getUrl());  // Added this line

}

• Heading — Clear, catchy and/or concise title.
  
  

• Metadata — Date of publication, article length, word & character count (if available), source name, URL (web page or social post).
  
  

• Summary — Concise 50 words or 100–300 word overview.
  
  

• Citation — Inline or immediately after the summary for source attribution.
  
  

• Top 10 Highlights — Bullet-point key takeaways of the article, including 1–2 points summarizing common or notable comments from the original post or discussion.
  
  

• Disclaimer — Neutral statement clarifying non-endorsement and sensitivity.
  
  

• Hashtags — Relevant tags to boost visibility.
  
  

• Author(s), Photographer(s), Location — Credit where due.
  
  

• Call to Action — Invite readers to comment or share at this post address/link.
  
  

• Date & Time Shared — Timestamp showing when this post was shared (e.g., “Shared August 10, 2025, 10:30 AM local time”).

* Have a suggestion to make this prompt better? send a comment via the contact form and/or connect via social media.

• February 2023
November 2024
Homepage November 17 2024
Homepage October 2023 

Page: Homepage Tuesday, August 12, 2025