Help CenterContact support
All Columna: Order Export & Sheets articles

How do I save scheduled exports to Google Drive?

Updated

On this page
  1. Set it up
  2. Verify it worked
  3. If an export keeps failing
  4. Troubleshooting

A scheduled export can save its file to a folder in Google Drive instead of emailing it, so your team or accountant finds every file in one place. The file lands there every few hours, every day, week or month, or a few minutes after each new order. This is part of the Pro plan.

Set it up

  1. In the app, open Settings and pick Scheduled email exports, then click Add scheduled export (or open an existing one).
  2. In File, enter a name and choose the template and file format.
  3. In Delivery, choose Google Drive under Deliver to.
  4. Choose the Google account whose Drive gets the files. These are the same accounts Google Sheets syncs use; click Connect Google account to add one.
  5. Subfolder is optional, for example Daily orders. It is created inside the “Columna exports” folder.
  6. Click Test connection to check the settings before saving.
  7. Choose the schedule and the orders to include, then click Save in the bar at the top of the page.

When you test or save, the app finds or creates the “Columna exports” folder in that account’s Drive, and the subfolder in it. Several exports of the same account share the “Columna exports” folder.

Columna only sees the files and folders it creates. It cannot open, list or change anything else in your Drive.

Verify it worked

  • After Test connection you see “Connection works. Columna can write files there.”
  • After saving you see “Settings saved”. Click Send now in Status: the file appears in the folder within a few minutes.
  • The list of scheduled exports shows “Google Drive” for this export.

Files are named after the export and the period, such as daily-orders-2026-10-23.csv, and never repeat. When there were no orders, nothing is saved. You can move the files out of the folder or share the folder with others. If you delete the folder, the next file creates it again.

If an export keeps failing

While a scheduled export is failing, a red banner on the app’s Home and in Settings names it; click Open export to see the error. Your store’s contact email also gets one email about it, with what to check and a button that opens the export, a reminder every 24 hours while it lasts, and one more email when it works again. When Google cannot be reached, the file is tried again a few minutes later.

Troubleshooting

“Google access for this account was removed.” The account was disconnected in the app or Columna’s access was removed in your Google account. Connect the Google account again, choose it in the export and save.

“The Google Drive folder could not be found or created.” Save the export again. If it keeps failing, check that the Google account can still create files in Drive.

“The Google Drive of this account is full.” Free some space in that Drive or pick another account, then use Send now.

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