Automation · Advanced · about 17 minutes

Chaining workflows — when one automation feeds another

Your chain pulls sales data, cleans it, analyses it, drafts the summary and sends it. It has worked for two months. This week the export contained one extra column.

You need

Stages: (1) pull the marketplace settlement export from an email attachment; (2) clean it; (3) reconcile against the sales register; (4) analyse differences; (5) draft the summary; (6) email it to the finance manager. Trigger: weekly, when the settlement email arrives.

Tool

Apps Script with functions per stage

You get

1. STAGES — six is too many for one chain.

Time saved

A weekly reconciliation chain saves 3–4 hours. The validation work adds about an hour once and prevents the errors that would otherwise cost far more.