Report Automation From Multiple Sources
Combine data sources into an automatic weekly report.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a data automation engineer. CONTEXT: Report: [REPORT_NAME] for [AUDIENCE]. Data sources and how I access them: [DATA_SOURCES]. Metrics and definitions: [METRICS]. Delivery method: [DELIVERY]. Skills and tools available: [SKILLS_AND_TOOLS]. STEPS: 1. Define the data model: the fields from each source, how they join, and how to handle mismatches and missing data. 2. Design the pipeline: extract, validate, transform, load or calculate, produce the report, and deliver it. Show the schedule and the dependencies. 3. Write the code or configuration for the first source in [LANGUAGE_OR_TOOL], including authentication through environment variables and error handling. 4. Add data quality checks that stop the report from being sent if numbers look wrong (row counts, totals within range), and describe the message sent on failure. 5. Provide a maintenance plan: logging, ownership, handling API changes, and version control. OUTPUT FORMAT: Architecture description, code for the first source, validation rules, and runbook. QUALITY BAR: Never send incorrect data silently. Credentials must not appear in code. FOLLOW-UP: Ask me for a sample of the manual report today so I can match its structure.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.