Sort pipeline steps into ETL

Sort each automation action into the ETL stage where it belongs. Extract Transform Load Download the newest CSV attachment from the vendor mailbox Request all pages from the CRM API and save the raw JSON response Normalize country names against the approved reference table Deduplicate customers by email plus company domain Calculate gross margin percentage from revenue and cost fields Insert valid rows into the reporting database with a run ID Upload the final CSV to the shared Finance folder Post the final success and exception counts to Slack

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in