Help CenterContact support
All Columna: Order Export & Sheets articles

How do I sync new orders to Google Sheets?

Updated

On this page
  1. Set it up
  2. Verify it worked
  3. Changed orders update their rows
  4. Choose the sheet tab
  5. Mark synced orders with a tag
  6. Start a new spreadsheet
  7. Troubleshooting

Use Google Sheets sync to keep a spreadsheet up to date without exporting by hand. After you connect a Google account, the app creates a spreadsheet in your Google Drive and adds new orders to it a few minutes after they are placed. Orders are read from Shopify and written to your spreadsheet. The app does not store them.

Set it up

  1. In the app, open Settings and pick Google Sheets sync. You can also open Orders and click Google Sheets, which opens the same place.
  2. In the Google account section, click Connect Google account and sign in in the window that opens. If your browser blocks it, allow pop-ups for this page and try again. The account then shows in the Google account list. To use a different account, click Connect another account and pick it in the list; Disconnect removes the account shown.
  3. In the Spreadsheet section, click Create spreadsheet, or click Choose a spreadsheet to pick one you already have in Google Drive. The app can only open the spreadsheets you pick or that it creates itself.
  4. In the Sync section, choose a template. The template decides which columns are written to the sheet.
  5. Keep Keep my spreadsheet in sync ticked. Untick it to pause syncing without losing your settings.
  6. In Add past orders, choose how many days of earlier orders the sheet starts with: None, only new orders, or the orders from the last 7, 30 (the default) or 60 days. You choose this once, when you create the sync.
  7. In Orders to include, optionally narrow the orders by Payment status, Fulfillment status, Tagged with and Not tagged with.
  8. Click Save in the bar at the top of the page.

Verify it worked

  • After step 2 you see your Google account in the Google account section.
  • After step 3 you see “New orders are added to the … tab of this spreadsheet” with a link. Click Open spreadsheet to check it. If you haven’t saved yet, you see “Save to send new orders to this spreadsheet.”
  • After step 8 you see “Settings saved”. The Status section shows “Adds orders placed since …” with the first day of orders the sync adds, and changes from “Not synced yet” to “Synced” with a row count, or “No new orders” when there is nothing new. With past orders chosen, they arrive in the sheet within a few minutes.

To sync right away, click Sync now in the Status section. You see “Sync requested. New orders will appear in your spreadsheet in a few minutes.”

Changed orders update their rows

When an order changes in Shopify, for example when it is paid, fulfilled or edited, the app updates that order’s rows in the sheet instead of adding them again. If the order now has fewer line items, the extra rows are removed.

To find the rows, the app writes the order’s ID in the last column, Order ID (sync key). Keep this column and do not sort it away from its row. A tab that was synced before this column existed gets it added on the next run; its older rows have no ID and stay as they are.

Templates that add up several orders in one row, such as sales or tax reports, only get new rows.

Choose the sheet tab

Use the Tab field to pick which tab receives the rows, or choose New tab… and enter a name of up to 100 characters. The app adds the new tab when you save. If the first row of the tab does not match the template columns, the app adds the rows to a new tab instead.

Mark synced orders with a tag

  1. In Orders to include, tick Tag orders after they are synced and enter one tag.
  2. If asked, click Allow tagging. Tagging needs permission to edit orders. The app only adds this tag and never changes anything else on an order.
  3. To never sync an order twice, also set Not tagged with to the same tag.
  4. Click Save.

Verify: after an order is added to the sheet, Shopify shows the tag on that order.

Start a new spreadsheet

Click Use a new spreadsheet. The current spreadsheet stays in your Google Drive and new orders go to the new one. Save your changes first, or you see “Save your changes before starting a new spreadsheet.”

Troubleshooting

You see “Google Sheets is not available”. The message under it reads “Google Sheets is not available right now. Contact support if this keeps happening.” Try again later or use Open support chat in the app.

You see “Your browser blocked the Google sign-in window. Allow pop-ups for this page and try again.” Allow pop-ups for the app page, then click Connect Google account again. For the Google Drive window, you see the same kind of message: “Your browser blocked the Google Drive window.”

You see “Google did not let the app create the spreadsheet. Connect your Google account again, then save.” The Google permission is missing or expired. Click Connect Google account (or Connect another account) and save again.

You see “The app cannot open this spreadsheet. It may have been deleted or belong to another Google account. Choose it again, or use a new spreadsheet.” Choose the spreadsheet again with Choose another spreadsheet, or click Use a new spreadsheet.

You see “You requested a sync a moment ago. Wait a few minutes and try again.” Sync now was clicked too soon after the last request. Wait a few minutes.

You see “Enter one tag of up to … characters, without commas.” Use a single tag with no commas.

You see “Google Sheets sync is temporarily unavailable. Try again in a few minutes.” Wait a few minutes and save again.

You see “This Google account is no longer connected. Refresh the page.” Refresh the page and connect the account again.

An order appears twice. Its row lost the value in Order ID (sync key), for example after the column was edited or cleared. Delete the older row; the next change updates the remaining one.

Status shows “Failed”. The reason is shown under it. Check the messages above, then click Sync now once the cause is fixed.

To compare the orders in Shopify with the rows in your sheet, see “How do I check my Google Sheets sync for missed orders?”. To send orders to more than one spreadsheet, see “How do I add more Google Sheets syncs?”.

Built and supported by StoreFleet, Shopify app developers since 2021.