Export Abandoned Carts to Google Sheets

This trigger runs your workflow on a recurring schedule to check for new abandoned checkouts. You'll configure how frequently you want the workflow to run - whether hourly, daily, or at custom intervals. The schedule determines how quickly you'll capture abandoned cart data after customers leave their checkouts incomplete. Once set, this runs automatically without any further input from you.

This step automatically connects to your Shopify store and pulls a list of abandoned checkouts from the past hour. The system queries Shopify's API to find checkouts where customers added items to their cart but didn't complete the purchase. It retrieves up to 250 abandoned checkouts per run, including customer details, product information, and cart values. This data gets passed to the next step for processing.

This filter step checks if any abandoned checkouts were found in the previous step. If the list is empty (no abandoned carts exist), the workflow stops here to avoid creating blank rows or processing empty data. If abandoned carts are found, the workflow continues to the next step. This acts as a safety gate to ensure you only process actual abandoned cart data.

The Loop step takes the list of abandoned checkouts and processes each one separately. For every abandoned cart in the list, it extracts the specific details like customer information, product details, cart value, and recovery URL. This allows the workflow to create individual spreadsheet rows for each abandoned cart rather than trying to process them all at once. Each iteration of the loop passes individual cart data to the next steps.

This filter examines each abandoned cart to confirm it hasn't been recovered or completed since it was initially abandoned. It checks if the checkout's "closed_at" field is still null, meaning the customer hasn't returned to complete the purchase. Only truly abandoned carts pass through this filter to reach your Google Sheets. This prevents cluttering your spreadsheet with carts that customers have already converted.

This step creates a new row in your Google Sheets spreadsheet for each abandoned cart that passes through the previous filters. You'll configure your spreadsheet name and select which columns to include from options like Customer Name, Phone Number, Total Cart Price, Products, and Recovery URL. The step automatically creates the spreadsheet if it doesn't exist and adds headers based on your column selections. Each abandoned cart becomes a separate row with all the data points you've chosen to track.