How to Export File Metadata from Google Drive

Google Apps Script to Google Sheet

function listDriveFiles() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.appendRow([
    "File Name", "File ID", "URL", "Size (bytes)", "Type",
    "Created", "Last Updated", "Owner", "Description", "Sharing"
  ]);

  var files = DriveApp.getFiles();
  // To scan a specific folder instead:
  // var files = DriveApp.getFolderById("YOUR_FOLDER_ID").getFiles();

  while (files.hasNext()) {
    var file = files.next();
    sheet.appendRow([
      file.getName(),
      file.getId(),
      file.getUrl(),
      file.getSize(),
      file.getMimeType(),
      file.getDateCreated(),
      file.getLastUpdated(),
      file.getOwner() ? file.getOwner().getEmail() : "",
      file.getDescription() || "",
      file.getSharingAccess() + " / " + file.getSharingPermission()
    ]);
  }
}

Python + Google Drive API v3

from googleapiclient.discovery import build
from google.oauth2 import service_account
import csv

# Authenticate (adjust path to your credentials file)
creds = service_account.Credentials.from_service_account_file(
    "credentials.json",
    scopes=["https://www.googleapis.com/auth/drive.readonly"]
)
service = build("drive", "v3", credentials=creds)

# Paginate through all files
all_files = []
page_token = None
while True:
    results = service.files().list(
        pageSize=1000,
        fields="nextPageToken, files(id, name, mimeType, createdTime, "
               "modifiedTime, owners, size, description, shared, "
               "parents, webViewLink)",
        pageToken=page_token,
        supportsAllDrives=True,
        includeItemsFromAllDrives=True
    ).execute()
    all_files.extend(results.get("files", []))
    page_token = results.get("nextPageToken")
    if not page_token:
        break

# Write to CSV
with open("google_drive_metadata.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "Name", "MIME Type", "Created", "Modified",
        "Owner", "Size", "Description", "Shared", "Link"
    ])
    for file in all_files:
        writer.writerow([
            file.get("id"),
            file.get("name"),
            file.get("mimeType"),
            file.get("createdTime"),
            file.get("modifiedTime"),
            file["owners"][0]["emailAddress"] if file.get("owners") else "",
            file.get("size", "N/A"),
            file.get("description", ""),
            file.get("shared"),
            file.get("webViewLink", "")
        ])

print(f"Exported {len(all_files)} files to google_drive_metadata.csv")

Rclone CLI

# List all files as JSON
rclone lsjson gdrive: --recursive > drive_files.json

# Convert JSON to CSV (requires Python or jq)
python3 -c "
import json, csv, sys
with open('drive_files.json') as f:
    data = json.load(f)
w = csv.DictWriter(sys.stdout,
    fieldnames=['Path','Name','Size','MimeType','ModTime','IsDir'])
w.writeheader()
for item in data:
    w.writerow(item)
" > google_drive_metadata.csv