Help CenterContact support
All Columna: Order Export & Sheets articles

How do I add more Google Sheets syncs?

Updated

On this page
  1. Before you start
  2. Steps
  3. Verify it worked
  4. Delete a sync
  5. If Pro ends
  6. Troubleshooting

With Pro you can send orders to more than one spreadsheet, each sync with its own Google account, template and filters.

Before you start

  • Your first sync is set up and saved (see “How do I sync new orders to Google Sheets?”). It works on every plan.
  • More syncs are part of the Pro plan (see “What does the Pro plan add?”).
  • A shop can keep up to 5 Google Sheets syncs in total, your first sync included.

Steps

  1. In the app, open Settings and pick Google Sheets sync.
  2. Scroll to More syncs, below your first sync. Without Pro you see “Sync to more spreadsheets” instead, with the button to start Pro.
  3. Click Add sync. The page “New Google Sheets sync” opens.
  4. In Google account, choose the account that should own the spreadsheet, or click Connect another account.
  5. In Spreadsheet, click Create spreadsheet, or click Choose a spreadsheet to pick one from Google Drive. Pick the Tab that receives the rows.
  6. In Sync, enter a Name, for example “Kitchen orders”. Only you see this name; it helps you tell your syncs apart.
  7. Choose a Template, keep Keep my spreadsheet in sync ticked, and choose Add past orders.
  8. In Orders to include, optionally set Payment status, Fulfillment status, Tagged with, Not tagged with and Tag orders after they are synced.
  9. Click Save in the bar at the top of the page.

Verify it worked

  • After step 9 you see “Google Sheets sync saved”, and the page shows the sync’s name as its heading.
  • The Status card on the right shows “Not synced yet”, then “Synced” with a row count after the first run. Click Sync now to run it right away.
  • Back in Settings > Google Sheets sync, More syncs lists the sync by name with its spreadsheet and an On or Off badge. Click the name to edit it.

Delete a sync

  1. Open the sync from More syncs.
  2. Click Delete, then confirm “Delete this sync?”.

You see “Sync deleted”. The sync stops adding orders. The spreadsheet and the rows already in it stay in your Google Drive.

If Pro ends

Your first sync keeps running. The other syncs are kept but do not run; More syncs shows them as “Paused, needs Pro”. You can still open them and switch them off. They run again when you subscribe to Pro again.

Troubleshooting

You see “You have reached the limit of 5 syncs.” Your shop already has 5 syncs. Delete a sync you no longer need to add another one.

You see “More than one Google Sheets sync is part of the Pro plan. Upgrade to add another one.” The shop is not on Pro. Start Pro from Plans in the app menu.

You see “The app could not check your plan with Shopify. Try again in a few minutes.” Wait a few minutes and save again.

You see “Enter a name of up to 80 characters.” Enter a shorter Name.

You see “Choose the Google account that should own the spreadsheet.” Pick an account in Google account before you save.

You see “Could not load your other syncs”. Click Try again.

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