← Back to Documentation

Frequently Asked Questions

General

What is ShopSheets?

ShopSheets provides real-time sync between your Shopify store and Google Sheets. View and manage your orders, products, and fulfillments in spreadsheets with automatic updates via webhooks.

How much does it cost?

$9.99/month with a 7-day free trial. No credit card required during the trial period.

Is my data secure?

Yes. ShopSheets uses industry-standard security practices:

• OAuth tokens are encrypted at rest
• All communication uses HTTPS
• ShopSheets acts as an intermediary only - we don't store your order data
• Google permissions follow the principle of least privilege
• You can revoke access anytime in Google Account settings

What happens to my data if I uninstall?

• Your Google Sheet remains in your Drive (you own it)
• The sheet stops receiving updates
• Historical data in the sheet is preserved
• You can export or continue using the sheet as a static document

---

Features

Can I edit data in Sheets and sync back to Shopify?

Not yet. Currently, ShopSheets is view-only (Shopify → Sheets).

Two-way sync (Sheets → Shopify) is planned for version 1.1. This will allow you to:

• Update order statuses
• Modify product prices and inventory
• Add fulfillment tracking

For now, use Sheets for viewing, reporting, and analysis.

What data types are supported?

Currently supported:

• Orders (13 columns: Order Number, Date, Customer, Email, Total, Status, etc.)
• Products (SKU, Title, Price, Inventory, etc.)
• Fulfillments (Tracking Number, Carrier, Status, etc.)

Coming soon:

• Customers
• Inventory locations
• Custom fields

How many sheets can I create?

Currently, one spreadsheet per Shopify store. The spreadsheet can have multiple tabs (Orders, Products, Fulfillments).

Each tab syncs independently based on its filters.

How far back can I sync orders?

You can sync orders from "All time" (your entire order history).

Recommendation: Use "Past 90 days" for better performance if you have 1000+ orders. You can always expand the date range later - ShopSheets uses smart caching to avoid re-fetching data.

Can I use Google Sheets formulas?

Yes! You can add formulas, charts, pivot tables, and conditional formatting.

Important: Avoid editing the data columns (typically A-M, rows 6+). ShopSheets overwrites this data during sync. Create your formulas in separate columns (N, O, P, etc.).

Can I share the sheet with my team?

Yes! Use standard Google Sheets sharing:

1. Click Share in the top-right corner
2. Add team members by email
3. Set their permissions (Viewer, Commenter, or Editor)

Note: Team members don't need ShopSheets accounts to view the shared sheet.

---

Sync & Performance

How often does data sync?

Real-time via webhooks (1-2 minute delay):

• New orders appear within 1-2 minutes
• Order updates sync immediately
• Product and fulfillment changes sync in real-time

Manual sync:

• ShopSheets menu → Refresh Data (instant)
• Dashboard → Sync Now button

What if I have 10,000+ orders?

ShopSheets handles large datasets efficiently:

1. Use date range filters - "Past 90 days" loads faster than "All time"
2. Initial sync may take 2-3 minutes - Subsequent syncs are faster due to caching
3. Smart caching - Expanding date range only fetches new data, not duplicates
4. Pagination - Data loads in chunks to avoid timeouts

Performance benchmarks:

• 1,000 orders: ~15 seconds
• 5,000 orders: ~45 seconds
• 10,000 orders: ~2 minutes

Can I sync multiple Shopify stores?

Yes, but each store requires a separate ShopSheets installation:

1. Install ShopSheets in Store A
2. Connect Google Account A
3. Install ShopSheets in Store B
4. Connect Google Account B (can be the same account)

Each store gets its own spreadsheet.

What happens if sync fails?

ShopSheets automatically retries failed syncs with exponential backoff:

• First retry: 1 minute
• Second retry: 5 minutes
• Third retry: 15 minutes

Check the dashboard's "Recent Activity" to see sync status. If syncs fail 3 times, contact support.

---

Billing

How does the trial work?

• 7 days free, full access to all features
• No credit card required to start trial
• After 7 days, you'll be prompted to add payment
• If you don't add payment, the app stops syncing (sheet remains in Drive)

Can I cancel anytime?

Yes. Uninstall ShopSheets in Shopify Admin:

1. Go to Settings → Apps and sales channels
2. Find ShopSheets
3. Click Uninstall

No cancellation fees or penalties.

What happens to my sheet if I uninstall?

• The sheet stays in your Google Drive
• Syncing stops immediately
• Historical data is preserved
• You can export or keep the sheet as a static document

Do you offer refunds?

Yes. If you're not satisfied within the first 30 days, contact mail@minim-l.com for a full refund.

What payment methods do you accept?

All payments are processed through Shopify:

• Credit card
• Debit card
• PayPal (where available)

Billing is handled by Shopify - you'll see the charge on your Shopify invoice.

---

Advanced

Can I use Google Sheets API with my ShopSheets sheet?

Yes! The sheet is a normal Google Sheet. You can:

• Access it via Google Sheets API
• Use Apps Script to build custom automations
• Connect it to other tools (Zapier, Make, etc.)

Caution: Don't delete rows 1-5 or change the Apps Script project - this will break syncing.

Can I customize the columns?

Not yet. Column structure is fixed to ensure reliable syncing.

Workaround: Add custom columns (N, O, P, etc.) for your own calculations and formulas.

Custom column configuration is planned for a future release.

What Google permissions does ShopSheets request?

• Create and manage Google Sheets (spreadsheets) - To create and update your sheet
• Access Google Drive files (drive.file) - To store the sheet in your Drive
• Deploy Apps Script projects (script.projects) - To install the auto-sync menu

ShopSheets only accesses files it creates. We cannot see other files in your Drive.

Can I use ShopSheets with Shopify Plus?

Yes! ShopSheets works with all Shopify plans:

• Shopify Starter
• Basic Shopify
• Shopify
• Advanced Shopify
• Shopify Plus

What about GDPR and data privacy?

ShopSheets is GDPR compliant:

• Customer data is encrypted in transit and at rest
• You control access via Google Sheets sharing
• Uninstalling deletes all OAuth tokens
• We don't sell or share your data
• Full data processing agreement available on request

---

Troubleshooting

My question isn't here

Check the Troubleshooting Guide for common technical issues.

Still need help? Contact mail@minim-l.com with:

• Your question
• Spreadsheet ID (if applicable)
• Screenshots (if relevant)

We typically respond within 24 hours.