Schedule Daily Shopify Order Exports to Google Sheets

This step automatically triggers the workflow daily at midnight but can be customized as needed. The Schedule trigger is pre-configured to run once per day and doesn't require any setup from you. When it fires, it passes the current timestamp to the next step, which gets used to determine which orders to export (typically the previous day's orders).

This step runs a SQL query against your order database to fetch records created since yesterday. You'll need to replace "Add table name here" with your actual orders table name (commonly "orders" or "shopify_orders"). The query automatically calculates yesterday's date and filters for orders created after midnight of the previous day. The retrieved order data gets passed to the Google Sheets creation step as a dataset ready for export.

This step creates a fresh Google Sheets spreadsheet with a title that includes the current date and time, like "Order Export for 2024-01-15T00:00:00+00:00". You'll need to connect your Google account and authorize MESA to create spreadsheets on your behalf. The newly created spreadsheet ID gets passed to the final step so the order data can be inserted into the correct file.

This step receives the order data from the SQL query and the spreadsheet ID from the previous step, then inserts all the order records as rows in the "Sheet1" tab. The bulk operation handles multiple orders at once, so whether you have 5 orders or 500 orders from yesterday, they all get added to your spreadsheet in a single action. Each order becomes one row with all the fields from your database query as columns.