Raghav Mittal
Menu
Approach →
Services
Shopify CRO Find and fix the friction between a visit and a completed checkout: product pages, collections, cart, checkout, speed, trust and tracking. Subscriptions Launch, fix or migrate Shopify subscriptions: offer design, app choice, customer portal, cancellation flows, failed-payment recovery and retention reporting. Shopify & Web Build or clean up websites that are fast, trackable, SEO-ready, and designed around how buyers actually decide. Shopify Automation Connect Shopify orders, customers, inventory, fulfilment, support, subscriptions, and reporting so your team spends less time moving the same information. SEO & UX Find the crawl, speed, mobile, UX, and conversion issues that stop good pages from ranking or turning traffic into leads. AI Workflows Use AI practically inside business workflows: Excel analysis, PPT reporting, SOPs, dashboards, content, and team documentation. Automation Replace manual follow-ups, spreadsheet relays, and status chasing with trigger-based systems that move work automatically. CRM Systems Turn your CRM from a contact database into an operating system for pipeline, ownership, follow-up, and reporting. Lead Systems Capture, qualify, assign, and follow up with leads across forms, CRM, WhatsApp, email, and sales teams. GST + Tally Connect the work between sales, invoices, GST review, Tally, reconciliation, and management reporting so finance operations have fewer blind spots. TallyPrime Integration Connect approved orders, invoices, inventory and customer records to TallyPrime with maintained mappings, confirmed results and reconciliation. Tally TDL Development Adapt the work inside TallyPrime with scoped TDL fields, validations, reports and document layouts, tested against your installed release. Shopify + Tally Connect Shopify orders, payments and refunds to Tally with clear stock ownership, approved accounting mappings and daily reconciliation. Distribution Software Connect buyer catalogues, tier pricing, purchase orders, warehouse tasks and stock movements in one distribution application. How we workScope, review and first-milestone payment View all servicesBrowse the complete delivery bench →
Blueprints → Work → Blog → Free Audit → Book a strategy call
Claude, Excel, PPT, and AI ops

AI Workflow Automation

AI workflow automation for reporting and operations

I connect AI-assisted analysis and drafting to recurring business work such as reporting, slide preparation, and operating documentation. The scope includes input templates, source checks, a reviewed output, and a repeatable handover. A pilot measures accuracy, corrections, and processing time before the team relies on the workflow for regular delivery.

Reporting workspace for reviewing source data and a presentation
One accountable lead.Strategy, build, team coordination, and a system your people can operate.
Clear ownershipUseful documentationHuman review where it matters

Review a first milestone before payment.

Agree a small deliverable, fee and acceptance checks in writing. Review the work, pay after acceptance and decide whether to continue. Remote delivery in English, led by Raghav with The Night Marketer.

Synthetic reporting example

Trace a reporting slide back to four source rows

Use the same small input, prompt and answer key to evaluate a reporting workflow. The figures below are calculated reference answers, not captured Claude output or a client performance result.

Scroll the example table sideways to read every column.

StageExampleReview decision
InputTwo periods, two channels; net sales in INR with refunds already deducted.Check the date window and metric definition before asking for a narrative.
Checked calculationPrior: 100,000 + 50,000 = 150,000. Current: 120,000 + 45,000 = 165,000.Change = 15,000 ÷ 150,000 = 10%. Do not subtract refunds again.
Draft slide claimNet sales rose 10%; the direct channel grew while wholesale declined.Supported by the sample. “Advertising caused the increase” is unsupported and must be removed.
ApprovalFigures checked; causal explanation unresolved; presentation still a draft.The named reviewer checks sources, chart labels and wording before sharing.

The sample passes arithmetic checks, but the final deck still needs visual review. Compare your generated file against the answer key; a valid total does not prove that its narrative, chart or layout is correct.

To reproduce the offline checks, extract the complete pack and run python3 verify_examples.py in that folder. Python 3 is required; the checker uses no network connection.

How does an AI reporting workflow keep numbers traceable?

Excel, PowerPoint, documents, approved business exports, and AI tools can be combined around the reporting task. File support, account permissions, model access, data handling, and available integrations are checked during discovery.

  1. Prepare inputs

    Identify the reporting period, source exports, required fields, and the person who approves the data.

  2. Calculate and validate

    Use explicit calculations for totals and comparisons. Flag missing or inconsistent inputs before drafting.

  3. Draft with sources

    Provide the checked figures to the model and keep references alongside each narrative claim.

  4. Review and deliver

    A reviewer checks claims and presentation quality. Record corrections and approve the final deck or document.

What happens when the normal path breaks?

Illustrative design: a monthly reporting workflow receives sales and advertising exports for different date ranges. It stops the comparison and requests aligned inputs rather than drafting a growth claim. Once the data is checked, AI prepares the narrative and a reviewer approves the deck. This example describes intended behaviour, not a client outcome.

Which implementation approach fits your team?

Choose by workflow requirements and maintenance needs
ApproachGood fitCheck before committing
Reusable prompt and templateA person prepares consistent inputs and reviews each output.Keep source references, a review checklist, and versioned instructions.
Workflow integrationA recurring report needs collection, validation, drafting, and routing.Define missing-data behaviour, retries, permissions, and the approval step.
Custom implementationSeveral data sources or business-specific calculations and controls.Agree evaluation samples, operating costs, maintenance, and failure handling.

Swipe sideways to see all columns.

What should you prepare before a pilot?

  • Choose one recurring report and an accountable reviewer.
  • Collect redacted inputs and an approved example output.
  • Define calculations separately from narrative drafting.
  • Check periods, totals, missing values, and source references.
  • Evaluate corrections and completion time on representative samples.
  • Document approval, recovery, and ongoing ownership.
Download the pilot checklist

Learn about The Night Marketer team and read its Shopify Partner Directory profile.

The pattern behind the request

Where can an apparently polished report be wrong?

01
A polished slide contains figures nobody can trace to a source
02
Generated commentary invents causes or hides missing data
03
Every reporting cycle needs the same manual checks and corrections

What this service makes easier

Use AI practically inside business workflows: Excel analysis, PPT reporting, SOPs, dashboards, content, and team documentation.

  • Claude with Excel workflows for analysis, cleanup, and reporting
  • Claude with PowerPoint workflows for review decks and client reporting
  • AI-assisted SOPs, briefs, summaries, and operating documentation
  • Human-in-the-loop automation so quality stays controlled

A clear path, not a black box

From source files to a reviewed reporting workflow

Start with one recurring report and a known answer set. Separate calculations, generated commentary and the approval that makes the output ready to share.

01 Define

Agree the source of each number.

Specify the report audience, source files, reporting period and metric definitions. Prepare approved example answers and missing-data cases.

02 Evaluate

Check numbers and unsupported claims.

Compare calculations with reference answers. Require source references and send missing evidence or ambiguous instructions to review.

03 Handover

Make review repeatable.

Give the operator a prompt, input contract, approval checklist and recovery instructions. Measure run cost and reviewer effort during the pilot.

What gets built

Input contracts, answer keys and an approval step

The pilot should make it clear which work is deterministic, which text is generated, and which decisions remain with the reviewer.

source files and metric definitions calculation checks and generated commentary reviewer approval and reporting handover
  1. 01
    Workflow use-case map

    Select one recurring task with a named audience, owner and acceptance definition.

  2. 02
    Prompt and data input templates

    Supply a sanitised input format, precise metric definitions and reusable instructions.

  3. 03
    Excel/PPT/doc automation setup

    Evaluate a working report against normal, missing-data and contradictory-input cases.

  4. 04
    Team training and governance notes

    Document reviewer responsibilities, escalation, running costs and maintenance.

Raghav Mittal, consultant and solutions architect
Raghav Mittal · The Night Marketer delivery bench

Direct access, execution depth

You get one person to own the outcome, backed by a team that can make it real.

I diagnose the problem and stay responsible for the path to delivery. When the work needs design, engineering, SEO, automation, or specialist support, The Night Marketer team adds depth without making you coordinate the room.

  • A concrete scope before a long project starts
  • Decisions and exceptions documented as the work takes shape
  • Testing and handover built into delivery, not left for the end
Bring the bottleneck

Common questions

Useful answers before we talk.

What should we automate first with AI?

Start with a recurring task whose inputs, output, reviewer, and quality criteria are clear. Reporting drafts and operating documentation are easier to evaluate when an approved example and source data already exist.

How do you measure whether an AI pilot works?

Compare representative runs with the current process. Record completion time, factual errors, reviewer corrections, failed runs, and operating cost. Agree acceptance criteria before deciding to expand the workflow.

Can our team keep reviewing the final output?

Yes. Review is an explicit workflow step. The system should make source evidence and uncertain claims visible so the reviewer can approve, correct, or return the work.

Keep exploring

AI Workflows guides and field notes

These are practical reads for understanding the job, asking better questions, and spotting the risks that are easy to miss in a first call.