Connect Google Sheets to Magistry
Connect Google Sheets to Magistry and import COGS and expenses from spreadsheets you already keep — preview every matched row before anything is written.
// what magistry does with it
What Magistry does with Google Sheets
COGS import: map a SKU-to-cost sheet to raise cost confidence, so agents can act on real margins instead of guesses.
Expense import for recurring and one-off operating costs that feed profit analytics and MER.
Import previews show exactly which rows and SKUs match before any write happens.
Imported costs flow into catalog decisions, POAS profit-bidding, and the profit breakdown on your daily Pulse.
// setup
How to connect Google Sheets
- 1Open Settings → Integrations and choose Connect Google Sheets.
- 2Sign in with Google and approve the OAuth scopes.
- 3Pick the spreadsheet and map its columns (SKU, cost, or expense fields).
- 4Review the import preview, then confirm — only matched rows are imported.
// faq
Common questions
Does Magistry edit my spreadsheets?
No. Sheets are read for import only — Magistry never writes back to your spreadsheet. The data lands in Magistry's cost and expense modules after you confirm the preview.
What happens to SKUs that don't match?
The import preview lists unmatched rows explicitly so you can fix SKU naming before confirming. Nothing is imported blind.
Can I re-import when costs change?
Yes — imports are repeatable. Re-run the import after updating the sheet and the preview shows what changed before you confirm.
// ready when you are
Put Google Sheets on the audit trail.
Connect it in the dashboard, watch what the agents propose, and approve the moves you like. Nothing executes without a gate you set.
Free plan, no card · Propose-only by default · Kill switch always yours