# How to Sync Amazon Orders to Your Google Sheets (https://sellersheetai.com/guides/sync-amazon-orders-to-your-google-sheets)
> Sync your Amazon Seller Central orders into Google Sheets with the SellerSheet sidebar, keep them updated automatically, and refresh any single order on demand.
Keeping track of your Amazon orders and analyzing sales data is crucial for business growth. This guide shows you how to sync your Amazon orders to Google Sheets automatically, for better organization and analysis.
## Prerequisites [#prerequisites]
* **Store connected:** your Amazon store is connected to your SellerSheet account (sign in at [sellersheetai.com](https://sellersheetai.com/home)).
* **Sidebar installed:** the SellerSheet add-on is installed in Google Sheets. If not, follow [Install & first sync](/help/sheets/install).
## Step 1: Open the sidebar and sync orders [#step-1-open-the-sidebar-and-sync-orders]
To begin, trigger the first fetch from the SellerSheet sidebar:
1. Open your Google Sheet and launch the **SellerSheet sidebar**.
2. Go to the **Sales** panel.
3. Click **Sync Orders**.
### Syncing logic explained [#syncing-logic-explained]
* **First time:** the first Sync Orders fetches the last **30 days** of orders. This may take a few moments.
* **Automatic sync:** after that, SellerSheet keeps the sheet current by itself — about **every 2 hours**, together with the fees sync, fetching everything since the last sync.
* **Updates:** existing orders are updated when something changed (a status update, for example) since the last sync.
* **Manual sync:** click the button again at any time for an immediate refresh.
## Step 2: Access and manage your orders [#step-2-access-and-manage-your-orders]
Once synced, your order data lives in a dedicated spreadsheet:
* Open the **SellerSheet Sales** spreadsheet — from your Google Drive, or from the panel's Resources links in the sidebar.
* Go to the **Orders** sheet, where synced orders populate automatically.
\[\[TODO: screenshot Synced Orders in Google Sheets (retake — the old one showed real store data)]]
### Manual order updates [#manual-order-updates]
To update one order immediately, without waiting for the automatic sync:
1. Find the order in the **AmazonOrderId** column.
2. Click the cell containing its **AmazonOrderId**.
3. In the sidebar, click **Update Order**. SellerSheet fetches the latest information for that order from Amazon.
**Update Order** works on the **active cell**: the active row must hold a valid **Store** and **AmazonOrderId**.
You can pull orders that are not in your sheet yet. Write the **Store** and **AmazonOrderId** in an empty row, click the **AmazonOrderId** cell, and click **Update Order** to pull that order's data into the sheet.
## Bulk invoice creation [#bulk-invoice-creation]
Beyond syncing orders, you can use your order data to generate invoices for your customers.
\[\[TODO: screenshot Store Info Sheet for Invoices (retake — the old one showed real store data)]]
\[\[TODO: screenshot Invoices Sheet (retake — the old one showed real store data)]]
Fill the **Store Info** sheet once, and SellerSheet puts your branding and business details into every invoice generated from the **Invoices** sheet. For the step-by-step, see [How to Bulk Create Invoices for Amazon Customers](/guides/bulk-create-invoices-for-amazon-customers-in-google-sheets).
## Conclusion [#conclusion]
With the sync running on its own, you save the time of manual data entry and keep an up-to-date view of your Amazon business. Every button of the panel is listed on [Sales](/help/sheets/sellers/sales).