GOpen

A simple Mac app that lets you double-click supported local files and open them directly in the right Google app. No more manual importing.

Currently Supported

• CSV and XLSX → Google Sheets
• DOCX and TXT → Google Docs
• PPTX → Google Slides

Features

• Double-click supported files to open them in Google Workspace apps
• Automatic upload to Google Drive with conversion when supported
• Simple Google login through your browser
• Converted files are saved to your Google Drive
• Local file re-open caching for previously uploaded unchanged files

Setup (For Developers)

Step 1: Create Google Cloud Project

1. Go to Google Cloud Console
2. Create a new project, for example: GOpen

Step 2: Enable Google Drive API

1. Go to APIs & Services → Library
2. Search for Google Drive API and enable it

Step 3: Create OAuth Credentials

1. Go to APIs & Services → Credentials
2. Click + CREATE CREDENTIALS → OAuth client ID
3. Configure OAuth consent screen if prompted:
   • User Type: External
   • App name: GOpen
   • Add your email as a test user
4. Create OAuth client:
   • Application type: Web application
   • Name: GOpen
   • Authorized redirect URIs: http://localhost:3000/oauth2callback
   • Click Create

Step 4: Add Credentials to App

1. Download the JSON file
2. Rename it to credentials.json
3. Place it in the app root directory next to package.json

Step 5: Run the App

# Install dependencies
npm install

# Run in development
npm run electron:dev

# Build for production
npm run electron:build

Usage (For End Users)

1. Open the app
2. Click Sign in with Google
3. Approve access in your browser
4. Double-click a supported file on your Mac:
   • CSV or XLSX → Google Sheets
   • DOCX or TXT → Google Docs
   • PPTX → Google Slides

How It Works

1. User double-clicks a supported local file
2. App uploads it to Google Drive via API
3. Google converts it into the target Google app format when supported
4. App opens the resulting file in the browser
5. File is saved in the user’s Google Drive for future access

File Locations

• Credentials: Bundled in app as credentials.json
• Auth Token: ~/Library/Application Support/GOpen/token.json
• Upload Cache: ~/Library/Application Support/GOpen/uploaded-files.json

Privacy

• OAuth credentials are bundled with the app
• Auth tokens are stored locally on the user’s Mac
• The app only accesses files it creates or uploads with its granted scope
• No data is sent to third-party servers outside Google APIs used for conversion and storage

Planned Next File Flows

These are the file/app directions currently noted for future expansion:

• Mixed file storage → Google Drive
• Photos and videos → Google Photos

Already implemented from the original roadmap:

• CSV, XLSX → Google Sheets
• DOCX, TXT → Google Docs
• PPTX → Google Slides

Product direction: open local files directly into the corresponding Google web app instead of requiring users to manually upload or import them first.

Troubleshooting

"Not authenticated"

Click Sign in with Google and complete the OAuth flow.

Supported file does not open on double-click

Associate the file type with this app:

1. Right-click the file → Get Info
2. Under Open with, select GOpen
3. Click Change All...

Login fails

Make sure credentials.json is in the app directory and includes the correct redirect URI: http://localhost:3000/oauth2callback

License

MIT