Prompt Almanac

Create advanced Works with: Any AI

Report Automation From Multiple Sources

Table output

Combine data sources into an automatic weekly report.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Combine data sources into an automatic weekly report. Report audience and decisions: [AUDIENCE_AND_DECISIONS]. Data sources (name, access method, refresh frequency, key fields): [DATA_SOURCES]. Metrics and definitions: [METRICS]. Tools and language: [TOOLS]. Delivery (email, shared doc, dashboard): [DELIVERY].

Tables:
1. Source map: Source | Access | Credentials handling | Fields used | Refresh | Failure behavior.
2. Metric definitions: Metric | Formula | Sources | Grain and period | Known caveats.
3. Pipeline steps: Step | Action | Validation check | On failure.
4. Report layout: Section | Content | Chart or table | Commentary rule.
5. Quality checks: totals reconcile with source systems within a tolerance; no missing days; comparison with last week; alerts if a number moves more than a set threshold.
6. Operations: schedule, owner, monitoring for non-delivery, access review.

Then write the script or workflow outline in my tool, a sample output with fake data, a template for a three-sentence commentary, and a runbook for failures. Secrets must stay out of code. Keep personal data out of the report unless needed.

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.

Related prompts