How to Connect Google Sheets to Your Store

Connect your YouCan store to Google Sheets to automatically track incoming orders in real-time. Orders appear in your spreadsheet immediately after purchase, enabling seamless order management and analysis.

Why Connect Google Sheets?

Integrating Google Sheets with your store allows you to:

• Track orders in real-time - See new orders appear instantly in your spreadsheet
• Analyze sales data - Use Google Sheets formulas and charts for custom analysis
• Automate workflows - Create automated processes based on order data
• Share data easily - Collaborate with team members on order information
• Create custom reports - Build tailored reports using spreadsheet tools

Installation Steps

Step 1: Access the Apps Marketplace

1. Log in to your seller area
2. Navigate to Apps from the main menu
3. Click on the Marketplace tab

Step 2: Find the Google Sheets App

1. Search for "Google Sheets" or "googlesheet" in the marketplace search bar
2. The official Google Sheets app will appear in the results

Step 3: Install the App

1. Click on the Google Sheets app
2. Click the Install button
3. Review the app permissions

Step 4: Authorize Your Google Account

1. YouCan will prompt you to authorize your Google account
2. Click Allow to grant YouCan access to your Google account
3. Sign in with your Google credentials if prompted
4. Grant the necessary permissions for creating and editing spreadsheets

Step 5: Select or Create a Spreadsheet

1. Choose an existing spreadsheet from your Google Drive, or
2. Create a new spreadsheet through the authorization prompt
3. Select the specific sheet where orders will be recorded
4. Confirm your selection

Step 6: Complete Setup

1. The app will confirm the connection
2. Your Google Sheets integration is now active
3. Go to Installed Apps to manage the integration

How It Works

Once connected, the Google Sheets integration will:

• Automatically log new orders - Each order appears as a new row
• Include order details - Customer name, email, order items, amount, and date
• Update in real-time - Orders appear within seconds of purchase
• Preserve order history - All past orders are recorded

Managing Your Integration

Viewing Connected Spreadsheets

1. Go to Apps > Installed Apps
2. Find the Google Sheets app
3. Click Open to view or modify settings
4. See which spreadsheet is currently connected

Modifying Your Connection

1. Open the Google Sheets app from Installed Apps
2. You can change the connected spreadsheet
3. Update sheet preferences as needed
4. Save your changes

Disconnecting Google Sheets

If you no longer want to sync orders:

1. Go to Apps > Installed Apps
2. Find the Google Sheets app
3. Click Open and select Uninstall
4. Confirm the disconnection
5. Your spreadsheet will no longer receive new orders

Alternative: Orra Google Sheets App

YouCan also offers the "Orra Google Sheets" app as an alternative with similar functionality. It provides:

• Real-time order tracking in Google Sheets
• Custom field mapping options
• Advanced integration features

Both apps work similarly. Choose the one that best fits your workflow.

Tips for Google Sheets Integration

• Organize your data - Use Google Sheets formulas to calculate totals, averages, and insights
• Create dashboards - Build custom dashboards using charts and pivot tables
• Share with your team - Collaborate by sharing the spreadsheet with team members
• Back up your data - Google Sheets automatically backs up your order history
• Set up notifications - Use Google Sheets features to notify team members of new orders

Troubleshooting

Orders Not Appearing in Google Sheets

• Verify the connection is active in your Installed Apps
• Check that you authorized the correct Google account
• Ensure the spreadsheet is not full (Google Sheets has size limits)
• Wait a few moments as there may be a slight delay

Authorization Failed

• Ensure you're using the correct Google account
• Check that your Google account has access to Google Sheets
• Clear your browser cache and try again
• Verify your internet connection is stable

Need to Change Your Spreadsheet

1. Open the Google Sheets app from Installed Apps
2. Click the settings or configuration option
3. Select a different spreadsheet
4. Save changes

Related Articles

• How to Install and Manage Apps
• How to Use the Insights Dashboard
• How to Use AI Image Generation