SSheetHelper Back to workspace

Settings

Connect SheetHelper to Google Sheets, Vision, and your personal Drive.

Google destination

Choose where job records and uploaded files are saved.

Service account

Used for Google Sheets and receipt text recognition.

Personal Google Drive

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

Not connected OAuth creates a SheetHelper Uploads folder in My Drive.

Workspace access

Add up to three people. Their codes unlock the workspace only; the Railway master code also unlocks Settings.

Person 1
Person 2
Person 3
Leave both fields blank to remove a person.
How to set up SheetHelper 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. Copy client_email into the service account email field above.
  5. Copy the complete private_key into the private key field above.

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 the Spreadsheet ID field.
  3. Save settings. SheetHelper will create the required sheet tabs automatically.
  4. Add job names to the Jobs tab in column A, starting at cell A2.

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. Copy the client ID and client secret into the fields above, then save settings.
  5. Select Connect Google Drive, sign in, and approve access. SheetHelper creates its own uploads folder in My Drive.

5. Configure Railway

  1. Add a persistent Railway volume mounted at /data.
  2. Set SETTINGS_FILE_PATH=/data/app-settings.json.
  3. Set SITE_MASTER_PIN to your four-digit master code.
  4. Set SITE_UNLOCK_SECRET to a long random value.
  5. Deploy, generate a public domain, open this page, and save the Google 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.
Cancel