@extends('layouts.app') @section('content')

Google Sheets Sync

Automatically sync your orders to Google Sheets in real-time

@if(session('success'))
{{ session('success') }}
@endif @if(session('error'))
{{ session('error') }}
@endif @if(session('info'))
{{ session('info') }}
@endif

How It Works

Every order you create will automatically sync to your personal Google Sheet
The Google Sheet is created in YOUR Google Drive - you own it completely
Access your sales data from anywhere via Google Sheets mobile app
Create custom reports, charts, and formulas in your sheet
@if(auth()->user()->google_sheets_sync_enabled)

Connected

{{ auth()->user()->google_email }}

@if(auth()->user()->google_sheets_last_sync)

Last synced: {{ auth()->user()->google_sheets_last_sync->diffForHumans() }}

@endif
@if(auth()->user()->google_sheet_id) Google Sheet @endif
@csrf
@csrf @method('DELETE')

💡 For historical data, please enter past orders manually to avoid rate limiting.

@if(auth()->user()->isAdmin() || session()->has('impersonate'))
@endif
@if(auth()->user()->isAdmin() || session()->has('impersonate'))

Disaster Recovery

Use "Import Missing Orders" to recover orders from Google Sheets after database restore.

  • Step 1: Put site in Maintenance Mode
  • Step 2: Restore database backup
  • Step 3: Impersonate each seller and click "Import Missing Orders"
  • Step 4: Review conflicts, then confirm import for each seller
  • Step 5: Bring site back up from Settings
@endif @else

Not Connected

Connect your Google account to start syncing orders

Connect Google Account

By connecting, you authorize this app to create and manage a Google Sheet in your Google Drive.

@endif

Frequently Asked Questions

What data is synced to Google Sheets?

Order number, date, customer details (name, phone, email, address), products, quantities, SKUs, order total, payment method, status, and tracking number.

When does the sync happen?

Immediately after you create or update an order from the sales page or checkout form. The sync usually completes within 5 seconds.

Can I edit the Google Sheet?

Yes! The sheet is created in your Google Drive and you have full control. You can add formulas, charts, or custom columns. However, don't delete the header row.

What happens if I disconnect?

New orders will stop syncing to Google Sheets. Your existing Google Sheet will remain in your Drive unchanged. You can reconnect anytime.

Can admin see my Google Sheet?

No. The sheet is created in YOUR Google Drive using YOUR Google account. Only you have access to it.

@endsection