Result: 20251025163602605-16pm8v

Claude does advanced financial modeling

Media · Back

Attach reference images

What problem this solves

Key steps

  1. Open n8n and make a free account
  2. Copy/paste provided automation
  3. Connect your social accounts
  4. Let the agent post daily automatically

Catalog

{
  "id": "20251025163602605-16pm8v",
  "capturedAt": "2025-10-25T16:36:02.605Z",
  "analyzedAt": "2025-10-26T18:00:59.299Z",
  "source": {
    "origin": "instagram",
    "url": "https://www.instagram.com/reel/DOyN7SEkVs4/?igsh=MW45anhiMndpdG5pdA==",
    "authorHandle": null,
    "titleOrCaption": "Claude does advanced financial modeling "
  },
  "media": {
    "durationSeconds": null,
    "keepVideo": false,
    "thumbnailJpegPath": null
  },
  "spokenTranscript": "a company called Anthropic, their large language model known as Claude, just came out with this feature that can create Excel documents. Now, you could always do this in OpenAI, but the level of financial modeling that Claude can do is absurd. Uh, let me give you an example of this. I went to Claude, I have the uh Claude Max version, and I said, 'Hey, uh create a prompt that can create the most comprehensive law firm financial model that could cover metrics, billable hours, etc. Get best practices from every single law firm and create the prompt that would eventually create this Excel document.' So again, I always ask it to create the prompt. It created the prompt, and then, um, it went off and created the most incredible financial model for any firm. I have spent half my life in this platform known as Excel, okay? Do you know how many hours of my life have been taken from Microsoft Excel? And the fact that this can create a accurate financial model, this is value. This is value. This is not just nice images. This is actually real value.",
  "visualText": [
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Claude does advanced financial modeling 🤓"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "@SHAWNKANUNGO"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "their large"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "language model"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Claude"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "out with"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "this feature"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "create Excel"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "documents"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "now you"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "do this"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "AI"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "but the"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "level of"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "financial modeling"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "that Claude"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "can do"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "is absurd"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "uh"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "an example"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "to Claude"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Claude Max"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Good afternoon, shawn"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Create a prompt that can cre"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "I said"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "create the"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "most"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "comprehensive"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "law firm"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "financial model"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "metrics"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "billables hour"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "best practices"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "and create"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "this Excel"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Comprehensive Law Firm Financial Model Creation Prompt"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Model Structure & Tabs Required:"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "create"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "and then"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "it created"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "off and"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "created the"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "most incredible"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "financial model"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "for any"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "I have"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "spent half"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "my life"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "in this"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "known as"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "Excel okay"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "do you"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "many hours"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "life have"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "been taken"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "from Microsoft"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "fact that"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "create a"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "accurate financial"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "model this"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "is value"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "value this"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "just nice"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "images"
    },
    {
      "timeStart": "",
      "timeEnd": "",
      "text": "actually real"
    }
  ],
  "tags": [
    "financial-modeling",
    "instagram"
  ],
  "aiNotes": {
    "highLevelTopic": "A speaker reveals that Anthropic's AI, Claude, can now perform advanced financial modeling and create complex Excel documents, calling its capabilities \"absurd\" and showcasing its practical value beyond simple tasks.",
    "whatProblemThisSolves": [
      "Automated posting / outreach without manual work",
      "Monetization or lead gen without being on camera"
    ],
    "keyHowToSteps": [
      "Open n8n and make a free account",
      "Copy/paste provided automation",
      "Connect your social accounts",
      "Let the agent post daily automatically"
    ],
    "ingredientsRequired": [
      "n8n (self-hosted or free tier)",
      "Automation workflow provided by creator",
      "Access to model/agent (e.g. Kling 2.1, Claude, etc.)",
      "Your social / lead channels connected"
    ],
    "phrasesToSearchLater": [
      "A speaker reveals that Anthropic's AI, Claude, can now perform advanced financial modeling and create complex Excel documents, calling its capabilities \"absurd\" and showcasing its practical value beyond simple tasks.",
      "What's the most complex task you'd automate with AI? Let me know below!",
      "Follow for more game-changing AI updates.",
      "Tag a colleague who spends too much time in Excel.",
      "Have you tried Claude's new features? Share your thoughts!"
    ],
    "possibleUseCasesForMe": [
      "Daily CondoDataHost / DBPR compliance awareness content without Pip on camera",
      "Scalable outreach / warmup flow for seller leads (Sold.com etc.) if we adapt the same automation idea"
    ]
  },
  "storage": {
    "r2ObjectKey": "media/20251025163602605-16pm8v.mp4",
    "catalogObjectKey": "catalog/20251025163602605-16pm8v.json",
    "lastAccessedAt": "2025-10-28T00:12:24.401Z"
  }
}

Analysis

Raw Analysis JSON
{
  "candidates": [
    {
      "content": {
        "parts": [
          {
            "text": "```json\n{\n  \"transcript\": \"a company called Anthropic, their large language model known as Claude, just came out with this feature that can create Excel documents. Now, you could always do this in OpenAI, but the level of financial modeling that Claude can do is absurd. Uh, let me give you an example of this. I went to Claude, I have the uh Claude Max version, and I said, 'Hey, uh create a prompt that can create the most comprehensive law firm financial model that could cover metrics, billable hours, etc. Get best practices from every single law firm and create the prompt that would eventually create this Excel document.' So again, I always ask it to create the prompt. It created the prompt, and then, um, it went off and created the most incredible financial model for any firm. I have spent half my life in this platform known as Excel, okay? Do you know how many hours of my life have been taken from Microsoft Excel? And the fact that this can create a accurate financial model, this is value. This is value. This is not just nice images. This is actually real value.\",\n  \"ocrText\": [\n    \"Claude does advanced financial modeling 🤓\",\n    \"@SHAWNKANUNGO\",\n    \"their large\",\n    \"language model\",\n    \"Claude\",\n    \"out with\",\n    \"this feature\",\n    \"create Excel\",\n    \"documents\",\n    \"now you\",\n    \"do this\",\n    \"AI\",\n    \"but the\",\n    \"level of\",\n    \"financial modeling\",\n    \"that Claude\",\n    \"can do\",\n    \"is absurd\",\n    \"uh\",\n    \"an example\",\n    \"to Claude\",\n    \"Claude Max\",\n    \"Good afternoon, shawn\",\n    \"Create a prompt that can cre\",\n    \"I said\",\n    \"create the\",\n    \"most\",\n    \"comprehensive\",\n    \"law firm\",\n    \"financial model\",\n    \"metrics\",\n    \"billables hour\",\n    \"best practices\",\n    \"and create\",\n    \"this Excel\",\n    \"Comprehensive Law Firm Financial Model Creation Prompt\",\n    \"Model Structure & Tabs Required:\",\n    \"create\",\n    \"and then\",\n    \"it created\",\n    \"off and\",\n    \"created the\",\n    \"most incredible\",\n    \"financial model\",\n    \"for any\",\n    \"I have\",\n    \"spent half\",\n    \"my life\",\n    \"in this\",\n    \"known as\",\n    \"Excel okay\",\n    \"do you\",\n    \"many hours\",\n    \"life have\",\n    \"been taken\",\n    \"from Microsoft\",\n    \"fact that\",\n    \"create a\",\n    \"accurate financial\",\n    \"model this\",\n    \"is value\",\n    \"value this\",\n    \"just nice\",\n    \"images\",\n    \"actually real\"\n  ],\n  \"hookSummary\": \"A speaker reveals that Anthropic's AI, Claude, can now perform advanced financial modeling and create complex Excel documents, calling its capabilities \\\"absurd\\\" and showcasing its practical value beyond simple tasks.\",\n  \"ctas\": [\n    \"What's the most complex task you'd automate with AI? Let me know below!\",\n    \"Follow for more game-changing AI updates.\",\n    \"Tag a colleague who spends too much time in Excel.\",\n    \"Have you tried Claude's new features? Share your thoughts!\"\n  ]\n}\n```"
          }
        ],
        "role": "model"
      },
      "finishReason": "STOP",
      "index": 0
    }
  ],
  "usageMetadata": {
    "promptTokenCount": 22776,
    "candidatesTokenCount": 777,
    "totalTokenCount": 24575,
    "promptTokensDetails": [
      {
        "modality": "TEXT",
        "tokenCount": 61
      },
      {
        "modality": "VIDEO",
        "tokenCount": 20251
      },
      {
        "modality": "AUDIO",
        "tokenCount": 2464
      }
    ],
    "thoughtsTokenCount": 1022
  },
  "modelVersion": "gemini-2.5-pro",
  "responseId": "2mH-aOvhLpz4qtsPjPa1EA"
}