Google Sheets
A Google connection lets Mycorr read spreadsheets from any Google account you control. Imported sheets become Tables inside a Model, and you can re-sync them later to pick up changes.
One Google connection per account per user — you can have several side by side if you work across multiple accounts (e.g. work + personal).
What you need
- A Google account.
- Pop-ups allowed for
mycorr.app(the OAuth flow opens a small Google sign-in window).
That's it. There is no admin step — Google's consent screen is the entire setup.
Connecting your Google account
- Go to Settings → Connections → New Connection (or use the Import panel inside a Model and click "Connect a Google account").
- Pick Google account.
- A Google sign-in pop-up opens.
- Pick the Google account you want to use and approve the consent screen.
- The pop-up closes and the new connection appears in your list, labeled with the email you signed in with.
What Mycorr asks for
The OAuth consent screen requests three scopes:
drive.file— "See, edit, create, and delete only the specific Google Drive files you use with this app." Mycorr can only see spreadsheets you explicitly hand it through the Drive file picker; it cannot enumerate the rest of your Drive.userinfo.email+userinfo.profile— your email address and name, used to label the saved connection in your list.
Mycorr never writes to your spreadsheets in practice — the drive.file
scope is what Google's API requires to read picker-selected files, but
the import code only ever reads.
Importing sheets into a Model
Once the connection is saved:
- Inside a Model, open the Import panel.
- Pick the Google connection.
- The Drive file picker opens — select one or multiple spreadsheets.
- Each selected sheet is imported as its own Table inside the Model.
Drag any imported Table onto the Canvas to start working with it.
Keeping data in sync
After import, each Sheets-backed Table gets a Check for updates button. Click it to pull the latest cell values from the original spreadsheet. Sync covers:
- Row additions and deletions
- Column additions and deletions
- Value updates in cells
There are limits on what sync can detect cleanly across renames / reorders — see Syncing Data from Google Sheets for the rules.
Revoking
Two ways to disconnect:
- In Mycorr: Settings → Connections → click the row → Delete. The connection is removed; any tables you imported stay in your Models but stop syncing.
- In Google: visit myaccount.google.com/permissions, find Mycorr in the list, and click Remove access. The connection in Mycorr will start failing on the next refresh — delete it from Mycorr afterward to clean up.
Either action is enough. Doing both is fine.
Troubleshooting
| Symptom | Fix |
|---|---|
| Pop-up never opens | Allow pop-ups for mycorr.app and click again |
| "Google account didn't match" when re-signing in | You're switching accounts on an existing connection — sign in with the original email, or delete and re-create the connection with the new account |
| Import picker shows "No spreadsheets found" | Either your account has no Sheets, or you skipped the file-picker — re-click Sign in with Google and select the files in the Drive picker |
| Sync fails with "permission denied" after working before | You revoked Mycorr in Google's account permissions — re-create the Mycorr connection |
See also
- Syncing Data from Google Sheets — what sync can and can't detect.
The Sign in with Google button inside the Cloud Storage
Bucket setup runs a separate OAuth flow with
different scopes (openid email profile, for Workload Identity
Federation). Mycorr keeps one Google connection per account per user — if
you already have a Sheets connection for an account and want to use the
same account for Cloud Storage Buckets, delete the existing connection
first and re-create it from the Bucket form.