能否通过Google Apps Script读取本地电脑文件？实现方法咨询

API 探路者

2026-5-14

Can Google Apps Script Read Local Files?

First off, let's cut to the chase: Google Apps Script (GAS) cannot directly access files stored on your local computer. This is because GAS runs entirely on Google's cloud servers, and it doesn't have permissions to interact with your local machine's file system—there's no built-in equivalent of a "local file reader" class like you use for Google Drive files.

That said, there are several reliable workarounds to get your local file data into GAS for processing. Here are the most practical options:

1. Build a Simple Web App with File Upload

You can create a lightweight web interface that lets you manually upload local files to GAS, which then processes the content. Here's a quick example:

Step 1: Create the HTML Interface (save as `Index.html`)

<!DOCTYPE html>
<html>
  <body>
    <h3>Upload Local File to Process</h3>
    <input type="file" id="localFile" accept=".txt,.csv,.json">
    <button onclick="sendFileToGAS()">Upload & Process</button>
    <p id="status"></p>

    <script>
      function sendFileToGAS() {
        const fileInput = document.getElementById('localFile');
        const file = fileInput.files[0];
        if (!file) {
          document.getElementById('status').textContent = "Please select a file first!";
          return;
        }

        const formData = new FormData();
        formData.append('uploadedFile', file);

        google.script.run
          .withSuccessHandler(result => {
            document.getElementById('status').textContent = `Success! ${result}`;
          })
          .withFailureHandler(error => {
            document.getElementById('status').textContent = `Error: ${error.message}`;
          })
          .handleUploadedFile(formData);
      }
    </script>
  </body>
</html>

Step 2: Add the GAS Logic (in `Code.gs`)

function doGet() {
  // Serve the HTML interface when the web app is accessed
  return HtmlService.createHtmlOutputFromFile('Index')
    .setTitle('Local File Upload for GAS');
}

function handleUploadedFile(formData) {
  const uploadedFile = formData.get('uploadedFile');
  
  // Example: Read text content from the file
  const fileContent = uploadedFile.getDataAsString();
  
  // Add your custom processing logic here (e.g., parse CSV, save to Drive, etc.)
  
  return `Processed file: ${uploadedFile.getName()} (${fileContent.length} characters)`;
}

Step 3: Deploy as a Web App

Go to Deploy > New deployment, choose "Web app", set access permissions (e.g., "Anyone, even anonymous" if you want easy access), and deploy. You'll get a URL to open the upload interface.

2. Use Google Drive as a Middleman

Since you already know how to read Drive files with the File class, this is a straightforward option:

Sync your local files to a specific Google Drive folder using the Google Drive Desktop Client (files will auto-upload to Drive).
Write a GAS script that monitors this folder (using a trigger like onChange or time-driven triggers) and processes any new files added.

This is great if you want automated processing without manual uploads.

3. Leverage Google Forms

Create a Google Form with a "File upload" question (this requires the form to be linked to a Google Drive folder). When you submit a local file via the form:

The file is automatically saved to the linked Drive folder.
You can set up a GAS trigger (e.g., onFormSubmit) to process the new file immediately after submission.

All these methods let you get local file data into GAS for processing—pick the one that fits your workflow best!

内容的提问来源于stack exchange，提问作者Alexandre Berthet

能否通过Google Apps Script读取本地电脑文件？实现方法咨询

1. Build a Simple Web App with File Upload #

Step 1: Create the HTML Interface (save as Index.html) #

Step 2: Add the GAS Logic (in Code.gs) #

Step 3: Deploy as a Web App #

2. Use Google Drive as a Middleman #