What it is:

Automated backup procedure for LCN Lab Shared Drive.

What it does:

  • Handles limitations set by Google with Shared Drives.
  • Sanitizes file and directory names to ensure compatibility.
  • Converts Google Workspace file formats (e.g., Docs, Sheets, Slides) to Microsoft Office equivalents.
  • Generates detailed reports for each backup operation.
Read Full Project Details...

Google Drive Backup Script in Action

While working at the Language and Cognitive Lab at Teachers College, I discovered a significant gap in Google Workspace: there’s no native way to backup Shared Drives. No export option, no Takeout support. Manual downloads fail with large files, special characters in names, and Windows path length limits.

I developed a Python script to address these limitations. The tool:

  • Sanitizes file names and paths
  • Performs incremental backups
  • Converts Google Workspace formats to Office
  • Generates detailed backup reports

The lab now uses this solution to reliably backup years of research data. If your organization struggles with similar Shared Drive backup challenges, you can find the complete solution on GitHub. For more information about our lab’s research, visit the Language and Cognitive Lab website.