Google Sheets

Quick Answer: The Google Sheets integration connects specific spreadsheets and tabs to Moselle. Authorize with Google, then pick exactly which files to share using Google's own file picker — Moselle can only read spreadsheets you explicitly select. Setup is self-serve, takes about 5 minutes, and Moselle re-reads your selected tabs automatically on the schedule you set.

What This Connection Does

The Google Sheets integration is a read-only connection between the spreadsheets you choose and your data in Moselle. It's a good fit when part of your catalog, supply, or planning data lives in a spreadsheet instead of a system of record with a native Moselle integration — bringing it in automatically instead of re-exporting a CSV every time it changes.

The connection uses Google's non-sensitive drive.file scope: Moselle can only read spreadsheets you explicitly pick, not your entire Drive.

What You'll Need

• A Google account with access to the spreadsheet(s) you want to connect

Connect Google Sheets

1

Open the Integrations tab in Moselle

Click your avatar in the top right corner → Settings → the Integrations tab.

2

Select Google Sheets and click Connect

Find the Google Sheets integration in the grid and click Connect. Moselle redirects you to Google's consent screen.

3

Authorize access on Google

Sign in and approve the request to return to Moselle.

4

Pick your spreadsheets

Click Pick spreadsheets to open the Google file picker. Selecting a file here is what grants Moselle's connection access to it — Moselle can't see spreadsheets you haven't picked.

5

Choose tabs and a sync schedule

From the spreadsheet / tab list, select the specific tabs to sync. Set a schedule — Off, Hourly, Every 6 hours, Daily, or Weekly — or click Sync now to pull immediately.

Connected. Your selected tabs begin syncing on the schedule you set.

Set Your Sync Frequency

Once connected, you control how often Moselle re-reads your selected tabs from Settings → Integrations → Google Sheets — no need to reconnect to change it.

Frequency	Best for
Off	Pausing automatic syncs (you can still use Sync now)
Hourly	Sheets that change frequently throughout the day
Every 6 hours	Active spreadsheets updated multiple times a day
Daily	Most spreadsheets — the recommended default
Weekly	Reference data that rarely changes

Tip: Pick the least frequent schedule that still keeps your data current enough for planning. You can change the frequency at any time, and the new schedule takes effect on the next sync.

Sync on demand

Click Sync now at any time to pull the latest version of the sheet immediately, without waiting for the next scheduled run. The Integrations page shows the last synced time so you always know how current your data is.

Multiple Spreadsheets

You can connect more than one spreadsheet to a single Moselle account — for example, one sheet for sales data and another for inventory counts. Use Pick spreadsheets to add each file, then select tabs and a sync schedule for each.

Data Sync Details

What syncs — Google Sheets can supply sales history, inventory levels, or catalog data, depending on which columns your selected tabs contain.

SKU Matching — Rows automatically link to Moselle items when the SKU column matches exactly. Non-matching SKUs require manual linking in the Catalog.

Renames are safe — Your selections are tracked by their underlying IDs, so renaming a spreadsheet or tab doesn't break the sync. Restructuring the data itself (moving the header row or removing mapped columns) can cause a sync to fail.

Reconnecting Google Sheets

If your authorization expires or you need to pick additional files, go to Settings > Integrations, find Google Sheets, and click Reconnect or Pick spreadsheets again.

Troubleshooting

Issue	Cause	Solution
Sync failed	Header row moved or a mapped column was removed	Reopen the integration in Settings and re-confirm your tab selection
Rows not linking to items	SKUs don't match between the sheet and Moselle	Manually link rows in the Catalog or update SKUs to match
Data looks outdated	Sync frequency is set lower than your update pace	Increase the sync frequency, or use Sync now for an immediate refresh
"Access revoked" error	Google access was removed	Click Reconnect in Settings to re-grant access
Sheet not appearing in picker	Spreadsheet lives in a different Google account	Authorize with the Google account that owns the sheet

Frequently Asked Questions

Does Moselle see all my Google Sheets files?

No. Moselle only has access to the specific files you select through the picker — connecting the integration doesn't grant access to your whole Drive.

Does Moselle write data back to my spreadsheet?

No. The integration is read-only — Moselle never edits your source spreadsheet.

Can I change which sheet is connected later?

Yes. Open Settings → Integrations → Google Sheets and use Pick spreadsheets to select a different file or tab. Moselle reads from the new selection on the next sync.

What happens if I rename a spreadsheet or tab?

Your selections are tracked by their underlying IDs, so renaming a spreadsheet or tab doesn't break the sync — you don't need to reselect it.

How do I disconnect Google Sheets?

Revoke Moselle's access at any time from your Google Account permissions settings. Reach out to [e-mail] if you'd like help.

---

Related Guides

Setup IntegrationsAirtableManual Data Uploads