Unlock Automated Google Drive Folder Monitoring with Apps Script

Monitoring specific Google Drive folders for changes, especially for critical file types like CSVs and Google Sheets, can be essential for streamlined workflows and data management. This guide provides a comprehensive Google Apps Script solution that automates this process, sending you email notifications whenever relevant files are added or updated. The script is designed to be standalone, reside on a Shared Drive, and run hourly or on demand.

Highlights: Key Benefits of This Script

• Automated Vigilance: Set up an hourly check for your specified Google Drive folder, ensuring you're always up-to-date without manual effort.
• Targeted Monitoring: Focus exclusively on CSV and Google Sheets files, filtering out noise from other file types.
• Instant Notifications: Receive detailed email alerts summarizing new additions and modifications, complete with direct links to the files.
• Standalone & Shared Drive Ready: Deploy this script directly within your Google Workspace, including Shared Drives, without external dependencies.

Understanding the Automation: How the Script Works

This Google Apps Script leverages the power of Google's own services to provide a seamless monitoring solution. Here’s a breakdown of its core functionality:

Automating Google Drive tasks enhances productivity and data integrity.

Core Components

• Folder Identification: You specify the exact Google Drive folder to monitor using its unique ID.
• File Type Filtering: The script specifically looks for files with MIME types corresponding to CSV (MimeType.CSV) and Google Sheets (MimeType.GOOGLE_SHEETS).
• State Tracking with Properties Service: To detect changes, the script stores metadata (file ID, name, URL, and last modified timestamp) of the relevant files from its previous run. This information is stored securely using Google Apps Script's PropertiesService, which is scoped to the script itself, making it truly standalone.
• Change Detection Logic:
  • New Files: Any CSV or Google Sheets file found in the folder that wasn't present in the stored metadata is identified as new.
  • Modified Files: For existing files, the script compares the current lastUpdated timestamp with the stored timestamp. A more recent timestamp indicates a modification.
• Email Notifications: If new files are added or existing ones are modified, an HTML-formatted email is sent to your specified address. This email includes lists of the new and/or changed files, with direct links for quick access.
• Automated Execution (Triggers): A time-driven trigger is set up to run the script automatically every hour.
• Manual Execution: You can also run the script manually at any time directly from the Apps Script editor.

Workflow Mindmap

The following mindmap illustrates the operational flow of the Google Drive monitoring script, from initialization to state update and notification.

The Google Apps Script Code

Below is the complete standalone script. Copy and paste this code into a new Google Apps Script project.

// --- CONFIGURATION ---
// Replace with the ID of the Google Drive folder you want to monitor.
// Example: If folder URL is https://drive.google.com/drive/folders/ABC123XYZ, then ID is "ABC123XYZ"
const MONITORED_FOLDER_ID = "YOUR_FOLDER_ID_HERE"; 

// Replace with the email address where notifications should be sent.
const NOTIFICATION_EMAIL = "YOUR_EMAIL_ADDRESS_HERE"; 

// Key used to store file metadata in script properties. You generally don't need to change this.
const SCRIPT_PROPERTY_KEY_METADATA = "driveFolderMonitorMetadata_v1"; 
// --- END CONFIGURATION ---

/**
 * Main function to check the monitored Google Drive folder for new or updated 
 * CSV and Google Sheets files, and send email notifications if changes are detected.
 * This function is intended to be run by a trigger or manually.
 */
function checkDriveFolderAndNotify() {
  try {
    const folder = DriveApp.getFolderById(MONITORED_FOLDER_ID);
    if (!folder) {
      Logger.log("Error: Monitored folder with ID '" + MONITORED_FOLDER_ID + "' not found or access denied.");
      // Consider sending an admin error email here if persistent issues occur.
      return;
    }
    const folderName = folder.getName();
    Logger.log("Starting check for folder: '" + folderName + "' (ID: " + MONITORED_FOLDER_ID + ")");

    const scriptProperties = PropertiesService.getScriptProperties();
    const previousMetadataJson = scriptProperties.getProperty(SCRIPT_PROPERTY_KEY_METADATA);
    let previousMetadata = {};
    if (previousMetadataJson) {
      try {
        previousMetadata = JSON.parse(previousMetadataJson);
      } catch (e) {
        Logger.log("Error parsing previous metadata JSON: " + e.toString() + ". Starting with empty metadata.");
        previousMetadata = {};
      }
    }

    const currentMetadata = {};
    const newFiles = [];
    const modifiedFiles = [];

    const filesIterator = folder.getFiles();
    while (filesIterator.hasNext()) {
      const file = filesIterator.next();
      const mimeType = file.getMimeType();

      // Process only CSV or Google Sheets files
      if (mimeType === MimeType.CSV || mimeType === MimeType.GOOGLE_SHEETS) {
        const fileId = file.getId();
        const fileName = file.getName();
        const fileUrl = file.getUrl();
        const lastUpdated = file.getLastUpdated().getTime(); // Timestamp in milliseconds

        currentMetadata[fileId] = { 
          name: fileName, 
          url: fileUrl, 
          lastUpdated: lastUpdated,
          type: mimeType === MimeType.CSV ? "CSV" : "Google Sheet"
        };

        if (!previousMetadata[fileId]) {
          newFiles.push(currentMetadata[fileId]);
          Logger.log("New file detected: " + fileName);
        } else if (lastUpdated > previousMetadata[fileId].lastUpdated) {
          // Check for a significant time difference to avoid notifications for micro-changes (e.g., > 10 seconds)
          // This is optional and depends on how Drive updates timestamps for minor view-only changes.
          // For simplicity, any timestamp change is considered a modification here.
          modifiedFiles.push(currentMetadata[fileId]);
          Logger.log("Modified file detected: " + fileName);
        }
      }
    }

    if (newFiles.length > 0 || modifiedFiles.length > 0) {
      sendNotificationEmail(newFiles, modifiedFiles, folderName);
    } else {
      Logger.log("No new or modified CSV/Google Sheets files detected in '" + folderName + "'.");
    }

    // Save current metadata for the next run
    scriptProperties.setProperty(SCRIPT_PROPERTY_KEY_METADATA, JSON.stringify(currentMetadata));
    Logger.log("Successfully updated metadata for folder: '" + folderName + "'.");

  } catch (e) {
    Logger.log("FATAL ERROR in checkDriveFolderAndNotify: " + e.toString() + "\nStack: " + e.stack);
    // Optionally send an error notification email to the admin/NOTIFICATION_EMAIL
    MailApp.sendEmail(
      NOTIFICATION_EMAIL, 
      "Script Error: Google Drive Folder Monitor", 
      "An error occurred while monitoring folder ID " + MONITORED_FOLDER_ID + ":\n\n" + e.toString() + "\n\nStack Trace:\n" + e.stack
    );
  }
}

/**
 * Sends an email notification summarizing new and modified files.
 * @param {Array} newFiles - Array of objects representing new files.
 * @param {Array} modifiedFiles - Array of objects representing modified files.
 * @param {string} folderName - The name of the monitored folder.
 */
function sendNotificationEmail(newFiles, modifiedFiles, folderName) {
  let emailSubject = "Google Drive Alert: Changes in Folder '" + folderName + "'";
  let emailBody = "<p>Hello,</p>";
  emailBody += "<p>The Google Drive monitoring script detected the following changes in the folder <strong>'" + folderName + "'</strong> (ID: " + MONITORED_FOLDER_ID + "):</p>";

  if (newFiles.length > 0) {
    emailBody += "<h3>New Files Added:</h3><ul>";
    newFiles.forEach(file => {
      emailBody += <code><li><a href="${file.url}" target="_blank">${file.name}</a> (${file.type}) - Added around: ${new Date(file.lastUpdated).toLocaleString()}</li>;
    });
    emailBody += "</ul>";
  }

  if (modifiedFiles.length > 0) {
    emailBody += "<h3>Files Modified:</h3><ul>";
    modifiedFiles.forEach(file => {
      emailBody += <li><a href="${file.url}" target="_blank">${file.name}</a> (${file.type}) - Modified at: ${new Date(file.lastUpdated).toLocaleString()}</li>;
    });
    emailBody += "</ul>";
  }

  emailBody += "<p>--<br/>This is an automated notification from your Google Apps Script.</p>";

  MailApp.sendEmail({
    to: NOTIFICATION_EMAIL,
    subject: emailSubject,
    htmlBody: emailBody
  });
  Logger.log("Notification email sent to " + NOTIFICATION_EMAIL + " for changes in folder '" + folderName + "'.");
}

/**
 * Creates a time-driven trigger to run the 'checkDriveFolderAndNotify' function every hour.
 * Run this function once manually from the Apps Script editor to set up the trigger.
 * It will remove any existing triggers for the same function to prevent duplicates.
 */
function createHourlyTriggerForMonitoring() {
  // Delete existing triggers for this function to prevent duplicates
  const allTriggers = ScriptApp.getProjectTriggers();
  for (let i = 0; i < allTriggers.length; i++) {
    if (allTriggers[i].getHandlerFunction() === "checkDriveFolderAndNotify") {
      ScriptApp.deleteTrigger(allTriggers[i]);
      Logger.log("Deleted existing trigger: " + allTriggers[i].getUniqueId());
    }
  }

  // Create a new hourly trigger
  ScriptApp.newTrigger("checkDriveFolderAndNotify")
    .timeBased()
    .everyHours(1)
    .create();
  Logger.log("Hourly trigger created successfully for 'checkDriveFolderAndNotify'.");
  SpreadsheetApp.getUi().alert("Hourly trigger created successfully for 'checkDriveFolderAndNotify'."); // Or use Logger.log if running headlessly.
}

/**
 * Allows manual execution of the monitoring script.
 * Select this function in the Apps Script editor and click "Run".
 */
function manualRunMonitoring() {
  Logger.log("Manual run of folder monitoring initiated by user.");
  checkDriveFolderAndNotify();
  Logger.log("Manual run completed.");
   SpreadsheetApp.getUi().alert("Manual run of folder monitoring completed. Check logs for details."); // Or use Logger.log.
}

/**
 * OPTIONAL: Deletes all triggers associated with this script project.
 * Useful for cleanup if you no longer need the automated monitoring.
 */
function deleteAllProjectTriggers() {
  const triggers = ScriptApp.getProjectTriggers();
  let count = 0;
  for (let i = 0; i < triggers.length; i++) {
    // You could be more specific here if you only want to delete triggers for 'checkDriveFolderAndNotify'
    ScriptApp.deleteTrigger(triggers[i]);
    count++;
  }
  Logger.log(count + " trigger(s) deleted from the project.");
  if (count > 0) {
    SpreadsheetApp.getUi().alert(count + " trigger(s) deleted.");
  } else {
    SpreadsheetApp.getUi().alert("No triggers found to delete.");
  }
}

/**
 * OPTIONAL: Resets the stored file metadata.
 * Useful for testing the script as if it's running for the first time.
 */
function resetMonitoredData() {
  PropertiesService.getScriptProperties().deleteProperty(SCRIPT_PROPERTY_KEY_METADATA);
  Logger.log("Stored folder metadata (property key: '" + SCRIPT_PROPERTY_KEY_METADATA + "') has been reset.");
  SpreadsheetApp.getUi().alert("Stored folder metadata has been reset.");
}

  

Setup and Usage Instructions

Leverage Google Workspace tools for powerful automation.

1. Create a New Apps Script Project:
   • Go to script.google.com.
   • Click on "New project".
   • Give your project a name (e.g., "Drive Folder Monitor").
2. Paste the Script Code:
   • Delete any default code in the `Code.gs` file.
   • Copy the entire script provided above and paste it into the `Code.gs` file.
3. Configure the Script:
   • In the script, find the `CONFIGURATION` section at the top.
   • Replace "YOUR_FOLDER_ID_HERE" with the actual ID of the Google Drive folder you wish to monitor. You can find the folder ID in its URL (e.g., if the URL is https://drive.google.com/drive/folders/ABC123XYZ123, the ID is ABC123XYZ123).
   • Replace "YOUR_EMAIL_ADDRESS_HERE" with the email address where you want to receive notifications.
4. Save the Script: Click the floppy disk icon (Save project) in the Apps Script editor.
5. Authorize the Script:
   • Before the script can run (either manually or via a trigger), it needs your authorization to access your Google Drive and send emails on your behalf.
   • Select the function manualRunMonitoring from the function dropdown list (next to the "Debug" button).
   • Click the "Run" button.
   • A "Authorization required" dialog will appear. Click "Review permissions."
   • Choose the Google account you want to authorize the script with.
   • You might see a "Google hasn’t verified this app" screen. If so, click "Advanced" and then "Go to [Your Script Name] (unsafe)". This is standard for custom scripts you've written.
   • Review the permissions the script needs (e.g., manage files in Google Drive, send email as you) and click "Allow."
6. Set Up the Hourly Trigger:
   • In the Apps Script editor, select the function createHourlyTriggerForMonitoring from the function dropdown list.
   • Click the "Run" button. This will set up the script to run automatically every hour. You only need to do this once.
   • You can verify the trigger by going to the "Triggers" page (clock icon on the left sidebar). You should see a trigger for `checkDriveFolderAndNotify` set to run hourly.
7. Standalone Script on Shared Drive:
   • This script is standalone. The `.gs` file itself is stored in your Google Drive.
   • You can move this script file into a Shared Drive if desired. The script will continue to function as long as the account that authorized it (and under which the triggers run) has access to the `MONITORED_FOLDER_ID`.
8. Manual Execution (Optional):
   • To run the check immediately, select `manualRunMonitoring` from the dropdown and click "Run."

Monitoring Script Aspects: A Comparative View

This radar chart provides a conceptual comparison of this Google Apps Script solution against native Drive notifications and manual checking, based on several key aspects. "This Script" refers to the solution provided on this page.

Note: "Notification Timeliness" for the script is hourly, while native notifications can be near real-time. "Resource Efficiency" refers to how it uses Google Apps Script quotas, which are generally generous for this type of task.

Key Configuration Parameters

The script's behavior is primarily controlled by constants defined at the beginning of the code. Here's a summary:

Visualizing File Monitoring with Apps Script

This YouTube video provides insights into monitoring file updates on Google Drive using Google Apps Script, which aligns with the principles of the script discussed here.

Important Considerations

• Permissions: The script requires your authorization to access Google Drive and send emails. This is a one-time setup step. The triggers will run under the authority of the user who created them.
• Shared Drive Access: If the monitored folder is in a Shared Drive, ensure the account authorizing the script has at least "Viewer" access to that folder and its contents. For the script to "live" on a Shared Drive, simply move the Apps Script file (`.gs`) to the Shared Drive.
• File Deletions: This script focuses on new and modified files. It does not currently notify about file deletions from the monitored folder. Extending this functionality is possible but adds complexity.
• Subfolders: The provided script monitors files directly within the specified folder only. It does not recursively monitor subfolders. Modification would be needed for subfolder monitoring.
• Google Apps Script Quotas: Google sets daily quotas for services like MailApp (email sending) and script runtime. For hourly monitoring of a reasonably sized folder, this script should stay well within typical quotas. Very frequent triggers (e.g., every minute) or extremely large folders might require optimization or quota considerations.
• Error Handling: The script includes basic error logging to the Apps Script console (View > Logs). For critical applications, you might consider enhancing error notifications (e.g., sending an email to an admin if the script encounters a fatal error). The current script does send an email for fatal errors.
• Timezone: Timestamps in notifications (`.toLocaleString()`) will be based on the timezone settings of the Google account under which the script is running.

Frequently Asked Questions (FAQ)

Conclusion

This Google Apps Script provides a powerful, customizable, and automated solution for monitoring specific folders in your Google Drive for new or changed CSV and Google Sheets files. By leveraging `PropertiesService` for state management and time-driven triggers for automation, you can stay informed about critical file updates without manual intervention, directly within your Google Workspace environment. Remember to configure the script with your specific folder ID and notification email, and authorize it to ensure smooth operation.

Recommended Next Steps & Further Exploration

• Explore how to modify this Google Apps Script to recursively monitor subfolders within the main Google Drive folder.
• Investigate methods for extending the script to detect and notify about files deleted from the monitored Google Drive folder.
• Learn about advanced error handling techniques in Google Apps Script for creating more robust Drive monitoring solutions, including custom error reports.
• Discover how to integrate Google Apps Script with Google Chat webhooks to send Drive folder notifications to a Chat space instead of email.

Referenced Search Results

This response was synthesized using information and concepts found in the following resources:

stackoverflow.com

I need a script to monitor a specific Google Drive folder whenever there is a change and notify me by email - Stack Overflow

developers.google.com

Class Folder | Apps Script - Google for Developers

developers.google.com

Class DriveApp | Apps Script | Google for Developers

labnol.org

Google Drive Monitor - Get Email Alerts When Files are Deleted in your Drive - Digital Inspiration

technologydots.com

How to Get Google Drive Notification when a File is Added to the Folder - Technology Org

onescript.work

Monitor File Updates on Google Drive with Google Apps Script: GAS103 - OneScript

developers.google.com

Enum MimeType | Apps Script - Google for Developers

developers.google.com

Installable Triggers | Apps Script - Google for Developers

quora.com

How to get a notification every time someone adds a file to a shared ...

spreadsheet.dev

Automatically detect when the user selects a new Range in Google ...

workspace.google.com

Drive Watcher - Google Workspace Marketplace

support.google.com

Notify collaborators when new files added to Drive - Google Drive ...

labnol.org

Monitor Files in Google Drive with Apps Script

reddit.com

r/GMail on Reddit: Google drive notification

googlecloudcommunity.com

Solved: Re: Google Cloud CSV to Google Sheets

reddit.com

How to get current folder? : r/GoogleAppsScript - Reddit

techrepublic.com

How to enable notifications for when any collaborator makes a ...

developers.google.com

Notifications for resource changes | Google Drive

groups.google.com

Need help setting up a Google Drive folder watcher using appscript and Drive API

answers.microsoft.com

Alert on a OneDrive folder change - Microsoft Community

reddit.com

r/GoogleAppsScript on Reddit: Import CSV file to google sheets ...

bardeen.ai

Easy CSV to Google Sheets Conversion Guide - 3 Steps

groups.google.com

Specific Folder - search for subfolder and contents using GAS

chromewebstore.google.com

Folder notifications for Google Drive™ - Chrome Web Store

stackoverflow.com

read data from csv-like file in Google Apps Script - Stack Overflow

filerev.com

Managing Google Drive Notifications: Stay Updated Without the Clutter

googlecloudcommunity.com

Solved: Notification for NEW files in a (shared) drive

pulse.appsscript.info

List all files and folders in a selected folder's directory tree in Google ...

community.latenode.com

Automating CSV imports in Google Sheets - Latenode community

github.com

GitHub - marcellojb/Google-Drive-Folder-Monitor-for-Google-Apps-Script: Google Drive Folder Monitor for Google Apps Script

support.google.com

Get Google Drive notifications - Android - Google Drive Help

pbainbridge.co.uk

Import CSV data into Google Sheet files - The Gift of Script

support.google.com

How to export CSV from google sheets using app script? - Google ...

developers.google.com

Class Sheet | Apps Script - Google for Developers

medium.com

Analyzing Folder Structures with Google Apps Script | by Kanshi ...

stackoverflow.com

Get specific rows from CSV file to googlesheet using Google Apps ...

reddit.com

Problems with script for parsing data from .csv files into Google Sheet

chrome.google.com

Folder notifications for Google Drive™ - Chrome Web Store

stackoverflow.com

Display files and folders in Google Apps Script web app

pulse.appsscript.info

Import CSV data into Google Sheet using Google Apps Script – ...

tecnobits.com

How do I set up notifications in the Google Drive app? ️

chromewebstore.google.com

Folder notifications for Google Drive™ - Chrome Web Store

arstechnica.com

Watching a share drive folder for file change notifications? | ...

developers.google.com

Import CSV data to a spreadsheet | Apps Script | Google for Developers

developers.google.com

Class FolderIterator | Apps Script - Google for Developers

eitcclips.blogspot.com

The EitC Blog: Monitor Google Drive folders with Google Apps Script | Jellybend

reddit.com

r/googlesheets on Reddit: CSV to Google Sheets Apps Script

developers.google.com

Monitor and control Apps Script use in your Google Workspace ...

developers.google.com

Drive Service | Apps Script | Google for Developers

spreadsheet.dev

How to import CSV files into Google Sheets using Apps Script

reddit.com

r/gsuite on Reddit: How can I get email notifications for when ...

support.google.com

Get Google Drive notifications - Computer - Google Drive Help

tanaikech.github.io

Benchmark: Importing CSV Data to Spreadsheet using Google Apps ...

support.google.com

Get Google Drive notifications - Computer - Google Drive Help

github.com

Google-Drive-Folder-Monitor-for-Google-Apps-Script/monitorRunner.gs ...

stackoverflow.com

Google Apps Script how to export specific sheet as csv format - ...

community.make.com

How can I monitor multiple folders [for new files] on my Google Drive ...