Collaborate on Shopify data with a shared spreadsheet

Share a live Shopify spreadsheet with your team, agency, or suppliers. Give each person the right access per worksheet, see who changed every cell, and control who can sync changes to Shopify. Everyone works on drafts until an authorized person pushes them live.

Everything you need to work on Shopify data as a team

Mixtable spreadsheets are built for more than one pair of hands. Share them, scope what each person can see and change, and keep a record of every edit, with Shopify updates behind one deliberate sync.

Share spreadsheets by email

Invite collaborators to a spreadsheet by email. Each person needs their own Mixtable web app account, so access is always tied to a real login.

Per-worksheet permissions

Give each collaborator read and write, read-only, or no access, sheet by sheet. Keep costs private, open tags for editing, and share an analytics sheet read-only.

A separate sync permission

Editing and publishing are different jobs. A dedicated permission controls who can run Sync to Shopify, independent of who can edit.

Cell and row history

See what changed, when, and by whom for any cell or row, with changes grouped by date, editor, column, and value.

Draft-first teamwork

Everyone's edits stay highlighted drafts in the spreadsheet. Nothing reaches your store until an authorized person reviews and syncs.

Full control over access

Change a collaborator's permissions or remove them whenever you need, per spreadsheet, without touching your Shopify staff accounts.

One shared Shopify spreadsheet, not five stale copies

The usual workaround is exporting a file and emailing it around, then guessing which copy is current. A shared Mixtable spreadsheet is one live version, connected to your store, that everyone with access works in together.

  • Invite collaborators to a spreadsheet by email
  • Collaborators sign in with their own Mixtable web app account
  • Everyone sees the same live data, not last Tuesday's export
  • Change permissions or remove a collaborator at any time
Invite your team

The right access for each worksheet and person

Not everyone should see everything, and fewer still should edit it. Permissions apply per worksheet, so an agency can rewrite SEO fields without ever opening your costs, and finance can read margins without risking a stray edit.

  • Read and write, read-only, or no access, set per worksheet
  • Share sales and customer analytics read-only while keeping costs and B2B terms out of view
  • Give suppliers read-only access to just their product lines
  • Adjust access as roles change, without re-sharing anything
Scope the access

Everyone edits, one person syncs

The team fills in drafts all week: new copy from the agency, price updates from ops, tags from the intern. None of it touches Shopify until someone with sync permission reviews the pending changes and runs Sync to Shopify.

  • Sync permission is separate from edit permission
  • All edits stay highlighted drafts in the shared spreadsheet
  • The reviewer sees every pending change in one preview
  • One deliberate sync pushes the approved work to Shopify
Set up your review flow

Know who changed what, and when

Shared editing only works with accountability. Cell history shows every value a cell has held, and row history groups a record's changes by date, editor, column, and value, so a surprise price is a lookup, not an investigation.

  • Cell history for any cell, including past values
  • Row history grouped by date, editor, column, and value
  • See whether a change came from a person or a formula
  • Review an editor's work after a big cleanup session
Keep the paper trail

The whole team's drafts, one deliberate sync

When the work is ready, a collaborator with sync permission opens the preview, reads through every pending change the team prepared, and runs Sync to Shopify. Editing is shared, publishing is deliberate.

Preview changes
#
Record
Field
Pending value
Edited by
1
Classic Oxford Shirt
SEO title
Oxford Shirt | Acme
2
Linen Trouser
Price
$124.00
3
Merino Crew Sweater
Tags
fall, bestseller
4
Corduroy Cap
Status
Active
5
Cotton Tee
Inventory quantity
140

What you can control in a shared spreadsheet

Sharing works on any Mixtable spreadsheet, whatever Shopify data it holds, from products and prices to orders and B2B companies.

Collaborators by email Read and write access Read-only access No access per worksheet Sync to Shopify permission Permission changes Collaborator removal Cell history Row history Any spreadsheet or worksheet

Mixtable vs other ways to work on Shopify data together

Teams usually improvise with shared logins or emailed files. Here is how the options compare when several people touch the same store data.

Collaboration taskMixtableShared admin accessEmailed spreadsheetsGoogle Sheets copies
Work on live Shopify data together Yes, one connected spreadsheet Yes, in the admin Stale copies Stale copies
Limit access per worksheet Yes Coarse staff permissions No Per file or tab, manual
Separate editing from publishing Yes, sync permission No, edits are live Whoever re-imports Not connected to Shopify
See who changed each cell Cell and row history Admin events, coarse No Version history, no sync
Safe for agencies and suppliers Scoped, revocable access Risky, broad access Data leaves your control Data leaves your control
Changes reach Shopify One reviewed sync Instantly, unreviewed Manual re-import Copy-paste back

Comparison reflects typical team workflows. Collaborators need their own Mixtable web app account, and access is per spreadsheet.

From solo spreadsheet to team workflow in minutes

Share the spreadsheet once, set the permissions, and let the drafts flow in.

1

Connect your store

Install the Mixtable Spreadsheet Editor from the Shopify App Store and open the spreadsheet you want to share.

2

Invite collaborators

Share the spreadsheet by email. Each collaborator needs a Mixtable web app account.

3

Set permissions

Choose read and write, read-only, or no access per worksheet, and who can sync.

4

Work in drafts

The team edits together, and every change stays a highlighted draft with history.

5

Review and sync

An authorized collaborator checks the preview and runs Sync to Shopify.

Shopify collaboration questions

How do I share a Shopify spreadsheet with my team?

Open your Mixtable spreadsheet and share it by email with each teammate. They sign in with their own Mixtable web app account and see the same live, Shopify-connected spreadsheet you do, with the permissions you gave them.

Do collaborators need their own Mixtable account?

Yes. Sharing is by email to people with a Mixtable web app account, so every edit is tied to a real login. There is no anonymous or public link sharing.

Can I control which worksheets each person can see or edit?

Yes. Permissions are set per worksheet for each collaborator: read and write, read-only, or no access. A supplier can see only their product line while your costs tab stays completely hidden.

Can I control who pushes changes to Shopify?

Yes. A separate permission controls who can run Sync to Shopify. The whole team can prepare drafts, and only the people you authorize can publish them to the store.

Can I see who changed a value in the spreadsheet?

Yes. Cell history shows what any cell held before, and row history groups a record's changes by date, editor, column, and value, so you always know who changed what and when.

Can I work with an agency or a supplier this way?

Yes, that is one of the best fits. Give an agency write access to just the worksheets they manage, like SEO fields, or a supplier read-only access to their products, and remove the access the day the engagement ends.

Do a collaborator's edits change my store immediately?

No. Every edit from every collaborator stays a highlighted draft in the spreadsheet. Your store only changes when someone with sync permission reviews the pending changes and runs Sync to Shopify.

Can I change or revoke someone's access later?

Yes. You can change a collaborator's per-worksheet permissions or remove them from the spreadsheet at any time, without touching your Shopify staff accounts.

Bring your team into your Shopify data

Open Mixtable, share the spreadsheet, and keep publishing exactly as controlled as you want it.