Help CenterContact support
All Columna: Order Export & Sheets articles

How do I start a Shopify Flow workflow when an export stops working?

Updated

On this page
  1. Before you start
  2. Set it up
  3. When the trigger runs
  4. Verify it worked
  5. Troubleshooting

Columna adds the trigger Columna export failed to Shopify Flow. It starts your workflows when a Google Sheets sync, its weekly check or a scheduled export stops working, so you can post to your team, create a task or tag a store note without waiting for the email. The trigger works on every plan.

Before you start

  • Install Shopify Flow from the Shopify App Store if your store does not have it yet.
  • Have at least one Google Sheets sync or scheduled export in Columna.

Set it up

  1. In Shopify Flow, create a workflow.
  2. Click Select a trigger, search for Columna export failed and select it.
  3. Add the actions you want, for example Send internal email or Send Slack message. Use the trigger’s fields in the text:
    • Automation name: the name of the sync or export.
    • Automation type: Google Sheets sync, Google Sheets weekly check or Scheduled export.
    • Destination: Google Sheets, Email, SFTP, FTP, Amazon S3, Google Drive, Webhook or Dropbox.
    • Error message: why it failed, the same text Columna shows on the sync or export.
    • Failed runs: how many runs failed in a row.
    • Automation URL: a link that opens the sync or export in Columna.
  4. Turn on the workflow.

When the trigger runs

  • At the same moment as Columna’s failure email: on the second failed run in a row, or on the first failed run when the problem cannot fix itself, such as a deleted spreadsheet or a removed Google account.
  • Once per problem. While the same problem lasts, the trigger does not run again, even when the reminder email goes out. After a run works again, the next problem runs it again.
  • Also when Columna’s failure emails do not reach you, for example after you unsubscribed from them.
  • The trigger carries no order or customer data.

Verify it worked

In Shopify Flow, open the workflow’s Recent runs. Each run shows the sync or export that failed and the error message.

Troubleshooting

The trigger does not appear in Shopify Flow. Search for “Columna”. If it is still missing, update Columna in your Shopify admin and reload Shopify Flow.

The workflow did not run after one failed run. A problem that may fix itself, such as a server that could not be reached, runs the trigger on the second failed run in a row. Use Sync now or Send now to check whether the problem is still there.

To send one order through a scheduled export from a workflow, see “How do I export an order from a Shopify Flow workflow?”.

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