MMHC Tools Back to workspace

Settings

Google configuration is managed with Railway service variables.

Railway configuration

Values are kept private in Railway and are not displayed here.

Google spreadsheetChecking…
Service account and VisionChecking…
Google OAuth clientChecking…
Google Drive folderChecking…

Personal Google Drive

Connect your Google account so photos use your personal Drive storage.

Not connected OAuth creates an MHC Tools Uploads folder in My Drive.
How to set up MHC Tools Google Cloud, Sheets, Drive, and Railway instructions

1. Prepare Google Cloud

  1. Open the Google Cloud Console and select or create a project.
  2. Attach a billing account to the project. Cloud Vision requires billing, although the first 1,000 receipt images each month are free.
  3. Open APIs & Services → Library and enable:
    • Cloud Vision API
    • Google Sheets API
    • Google Drive API

2. Create the service account

  1. Open IAM & Admin → Service Accounts and create a service account.
  2. Open it, then choose Keys → Add key → Create new key → JSON.
  3. Keep the downloaded JSON file private. Never upload it to GitHub.
  4. Set GOOGLE_SERVICE_ACCOUNT_EMAIL in Railway to the JSON file's client_email.
  5. Set GOOGLE_PRIVATE_KEY in Railway to the complete JSON private_key, including the BEGIN and END lines.

3. Connect Google Sheets

  1. Create a Google Sheet and share it with the service account as an Editor.
  2. Copy the ID from the Google Sheet URL into Railway as GOOGLE_SPREADSHEET_ID.
  3. Deploy the Railway service. MHC Tools will create the required sheet tabs automatically.
  4. Add job names to the Jobs tab in column A, starting at cell A2.
  5. Add worker names in column E and their four-digit codes in column F, starting at row 2.
  6. Add work to the Task ToDo tab using: Job, Date Assigned, Assigned To, Status, Task.

4. Connect personal Google Drive

  1. Open APIs & Services → OAuth consent screen, configure the app, and add your Google account as a test user if the app is in testing.
  2. Open APIs & Services → Credentials and create an OAuth client ID with application type Web application.
  3. Copy the authorized redirect URI shown above into the OAuth client's Authorized redirect URIs.
  4. Set the client ID and client secret in Railway as GOOGLE_OAUTH_CLIENT_ID and GOOGLE_OAUTH_CLIENT_SECRET.
  5. Select Connect Google Drive, sign in, and approve access. MHC Tools creates its own uploads folder in My Drive.

5. Configure Railway

  1. Add these variables to the Railway service. The Settings page only reports whether they are present; it never displays their values:
  • GOOGLE_SPREADSHEET_ID
  • GOOGLE_SERVICE_ACCOUNT_EMAIL
  • GOOGLE_PRIVATE_KEY
  • GOOGLE_OAUTH_CLIENT_ID
  • GOOGLE_OAUTH_CLIENT_SECRET
  • GOOGLE_DRIVE_REFRESH_TOKEN
  • GOOGLE_DRIVE_FOLDER_ID
  • PUBLIC_URL (for example, https://work.mhc211757.com)
  • GOOGLE_OAUTH_REDIRECT_URI (optional exact callback override)
  • SITE_MASTER_PIN
  • SITE_UNLOCK_SECRET
  • APP_TIMEZONE (for example, America/Los_Angeles)
  1. Add worker names and four-digit codes to the Jobs tab in columns E and F, starting on row 2.
  2. Deploy and test the connection.

6. Test the connection

  1. Return to the workspace and refresh the job list.
  2. Upload a clear receipt photo with the total visible.
  3. Confirm that the image appears in Drive and a new row appears on the Receipt tab.
Back to workspace