← Back to Documentation

Troubleshooting

This guide helps you solve common issues with ShopSheets.

Google Connection Issues

"Authorization Denied" Error

What you see: Error message in dashboard: "Google authorization was denied"

Cause: You clicked "Cancel" on the Google OAuth popup

Solution:

  1. Click Connect Google Account again
  2. Complete the authorization process
  3. Click "Allow" when prompted for permissions

"Session Expired" Error

What you see: Error messages like:

Cause: The OAuth session timed out (10-minute limit) or state cookie is missing

Solution:

  1. Close any open Google OAuth popups
  2. Click Reconnect Google Account in the dashboard
  3. Complete the authorization within 10 minutes
  4. Ensure your browser accepts cookies

"Expired" Badge in Dashboard

What you see: Badge shows Expired instead of Connected

Cause: Google refresh token expired or was revoked

Common reasons:

Solution:

  1. Click Reconnect Google Account
  2. Complete the authorization process again
  3. Your existing sheets will continue working after reconnection

"Failed to Exchange OAuth Tokens" Error

What you see: "Failed to exchange OAuth tokens" error message

Cause: Network issue or Google API temporary error

Solution:

  1. Wait 1 minute and try again
  2. Check your internet connection
  3. If the problem persists, clear browser cache and try again

Sheet Creation Problems

"Failed to Create Sheet"

What you see: Error when clicking "Create Orders Sheet"

Possible causes and solutions:

  1. Insufficient Google Drive storage

    • Check your Google Drive storage quota
    • Delete old files or upgrade storage

  2. Google permissions revoked

    • Go to dashboard and verify badge shows Connected
    • If Expired, reconnect your Google account

  3. Network timeout

    • Wait 1 minute and try again
    • Check your internet connection

  4. Google API rate limit

    • Rare, but can happen if you create many sheets quickly
    • Wait 5 minutes and try again

Sheet Created But No Data

What you see: Sheet opens but rows 6+ are empty

Possible causes:

  1. No orders in selected date range

    • Click the Date Range dropdown in row 2
    • Select "All time" to see all orders
    • Verify you have orders in Shopify Admin

  2. Sync in progress

    • Large datasets may take 30-60 seconds to populate
    • Refresh the sheet after waiting

  3. Shopify API error

    • Check the ShopSheets dashboard for "Recent Activity"
    • Look for error messages

Sync Issues

New Orders Not Appearing in Sheet

What you see: Created a new order in Shopify, but it doesn't show in the sheet

Expected behavior: Webhooks deliver updates within 1-2 minutes

Solutions:

  1. Wait 2 minutes - Webhook delivery can take up to 2 minutes
  2. Check Recent Activity - In the dashboard, look for sync errors
  3. Manual refresh - In your sheet: ShopSheets menu → Refresh Data
  4. Verify filters - Check that your Date Range filter includes today
  5. Check status filter - Ensure "All" or the order's status is selected

Failed Syncs in Dashboard

What you see: "Recent Activity" shows failed sync attempts

What ShopSheets does automatically:

Common causes:

  1. Google API rate limits

    • ShopSheets will retry automatically
    • No action needed

  2. Network timeout

    • Usually resolves on retry
    • Check dashboard after 5 minutes

  3. Sheet deleted or permissions changed

    • If you deleted the sheet, failed syncs are expected
    • Create a new sheet from the dashboard

When to worry:

Apps Script Issues

No "ShopSheets" Menu in Toolbar

What you see: Can't find the ShopSheets menu in your sheet

Solutions:

  1. Reload the sheet - Press Ctrl/Cmd + R
  2. Check Apps Script is installed
    • Go to Extensions → Apps Script
    • You should see a project named "ShopSheets Sync"
    • If missing, the script didn't deploy correctly
  3. Wait 30 seconds - Menu can take time to load on first open
  4. Try incognito mode - Rules out browser extension conflicts

"Script Not Configured" Error

What you see: Error message: "Script not configured. API configuration is missing."

Cause: Apps Script project is missing the API key (rare)

Solution:

  1. Note your spreadsheet ID (in the URL)
  2. Contact support at mail@minim-l.com with the spreadsheet ID
  3. We'll redeploy the script with the correct configuration

Temporary workaround:

Auto-Sync Not Working After Filter Change

What you see: Change a filter dropdown, but data doesn't refresh

Cause: Auto-sync trigger not installed or permissions denied

Solution:

  1. Run: ShopSheets menu → Setup Auto-Sync
  2. Grant permissions if prompted:
    • "See, edit, create, and delete all your Google Sheets spreadsheets"
    • "Connect to an external service"
  3. Change a filter to test - should sync within 2 seconds

If still not working:

Performance Issues

Slow Loading with Large Datasets

What you see: Sheet takes 30-60 seconds to load data

Cause: Syncing 1000+ orders or products

This is normal for large datasets, but you can optimize:

  1. Use narrower date ranges

    • Change filter from "All time" to "Past 30 days"
    • Reduces data volume significantly

  2. Wait for cache to warm

    • First sync is always slower
    • Subsequent syncs use cache and are faster

  3. Close unused sheets

    • Multiple large sheets can slow sync

  4. Avoid "All time" filter for stores with 10,000+ orders

    • Consider "Past 90 days" instead

"Syncing Orders..." Appears But Nothing Happens

What you see: Toast message "Syncing orders..." but sheet doesn't update

Possible causes:

  1. Sync already in progress

    • Wait for current sync to complete
    • Can take up to 60 seconds for large datasets

  2. Cache is serving data

    • If you see "Synced X orders (from cache)", data is already current
    • No update needed

  3. Apps Script timeout

    • Rare for normal datasets
    • Try manual refresh from dashboard instead

When to Contact Support

Contact mail@minim-l.com if:

Include in your support request:

We typically respond within 24 hours.