mAIn Street #187: ​​​Anthropic gives Claude shared context across Microsoft Excel and PowerPoint; ​Perplexity launches Mac-based AI agent​; Americans' Views on AI


MARCH 13, 2026

  • PromptCraft: USING CHATGPT TO BUILD A DATA PIPELINE
  • THE HEADLINES: ​​​Anthropic gives Claude shared context across Microsoft Excel and PowerPoint, enabling reusable workflows in multiple applications​; Meta unveils plans for batch of in-house AI chips​; ​Perplexity launches Mac-based AI agent​; Americans' Views on AI
  • Tool Spotlight: MorphMind AI Agents Do Research, Content, Product Development

USING CHATGPT TO BUILD A DATA PIPELINE

Instead of a prompt roundup, I just wanted to share with you all the design that I plan to launch next week, along with some details on how I used ChatGPT to create it. First, here's what we're going to, starting on Monday:

I think it's a better-looking format, and I got there with no programming skills whatsoever, although I have managed to pick up a few along the way. In the end, this is what it's capable of:

  • Searching the web for newly published stories that feature relevant key terms
  • Using logic to delineate PromptCraft from Tool Spotlight from Headlines
  • Subcategorizing all Headlines so the stories featured are scannable thematically
  • Building all scraped content into the HTML wrapper
  • Correctly hyperlinking to the original source for every featured item, so no 403s or 404s appear
  • Storing some scraped data for later use, removing those items once they are used, and remembering them so they aren't shown again in future publications
  • Leaving easily editable space for my editor's note at the top of each issue

Here's how I made it happen:

  1. Opened a ChatGPT Project and told it to walk me through building a data pipeline one step at a time.

2. I followed its direction on tools to use, packages to install, scripts to run, etc.

3. I leveled with it when something wasn't working, or I was confused, and it helped me troubleshoot.

4. When the conversation got too long, I Ctrl+A'd that bad boy and pasted it into a Notepad file, which was then uploaded to my mAIn Street News Project as a Source.

5. I started a new chat, asking it to pick up where my Source file left off.

6. I had it build an HTML wrapper with my color scheme so that there was HTML language I could paste into Kit once I was finished with a day's run of news.

7. I relentlessly tested before deciding to make it public.

A few eggs may break along the way as this rolls out live next week, but the important thing to remember is that I went from non-techie novice to data pipeline builder in one week. That was as an English major with no programming skills whatsoever.

Choose something you find difficult. Start by asking ChatGPT to walk you through it one step at a time. When the task becomes big enough (i.e., the chat session starts forgetting things or acting odd), consider starting a Project and uploading your conversations as a Source. Then, keep talking and doing. Eventually, you'll get where you want to go, and you'll learn a whole lot along the way.

With ChatGPT, you can do hard things :)

HIGHLIGHTS: ​​​Anthropic gives Claude shared context across Microsoft Excel and PowerPoint, enabling reusable workflows in multiple applications​; Meta unveils plans for batch of in-house AI chips​; ​Perplexity launches Mac-based AI agent​; Americans' Views on AI

  1. From scripts to sermons: is AI going to be writing everything soon?
  2. Meta unveils plans for batch of in-house AI chips
  3. China warns state-owned firms and government agencies against OpenClaw AI, sources say
  4. New NVIDIA Nemotron 3 Super Delivers 5x Higher Throughput for Agentic AI
  5. AI autocomplete doesn’t just change how you write. It changes how you think
  6. AI Security for Apps is now generally available
  7. Exploring the feasibility of conversational diagnostic AI in a real-world clinical study
  8. Canal+ taps Google and OpenAI for AI-driven video production, content recommendation
  9. Designing AI agents to resist prompt injection
  10. Perplexity launches Mac-based AI agent
  11. Researchers Trick Perplexity’s Comet AI Browser Into Phishing Scam in Under Four Minutes
  12. AI can ‘same-ify’ human expression — can some brains resist its pull?
  13. Atlassian to cut roughly 10% jobs in pivot to AI
  14. How we’re reimagining Maps with Gemini
  15. One of Grammarly’s ‘experts’ is suing the company over its identity-stealing AI feature
  16. ‘Exploit every vulnerability’: rogue AI agents published passwords and overrode anti-virus software
  17. Protecting cities with AI-driven flash flood forecasting
  18. Warner and Rounds roll out bipartisan AI workforce bill
  19. ‘Invasive’ AI-led mass surveillance in Africa violating freedoms, warn experts
  20. Software companies fight back against fears that AI will kill them
  21. Key findings about how Americans view artificial intelligence
  22. US insurers and hospitals turn to new AI for age-old battle over charges vs payments
  23. Introducing Replit Agent 4: Built for Creativity
  24. How Autoresearch will change Small Language Models adoption
  25. Introducing The Anthropic Institute
  26. Anthropic gives Claude shared context across Microsoft Excel and PowerPoint, enabling reusable workflows in multiple applications

MorphMind AI Agents Do Research, Content, Product Development

MorphMind is a platform for building and orchestrating specialized AI agents that collaborate like a team. Users can assign roles, tasks, and workflows to different AI specialists, enabling coordinated execution of complex projects such as research, content creation, and product development.

Learn More: https://morphmind.ai


Read All mAIn Street Back Issues Here


Your input fuels the content. Let me know how I did today!

mAIn Street

Check out the resources I offer below and sign up for my new newsletter!

Read more from mAIn Street

MARCH 12, 2026 PromptCraft: Prompts to Stop AI Clickbait at the End of Responses and End Overwhelm; PLUS, Getting Better AI Outputs by Being 'Extremely Lazy' THE HEADLINES: Generative AI changes how employees spend their time; ChatGPT, other AI chatbots approved for official use in US Senate, NYT reports; Amazon Admits Extensive AI Use Is Wreaking Havoc on Its Core Business; Where you can use Google's Pomelli AI Tool Tool Spotlight: Chronicle Slides: Edit With AI, Share in Any Format TODAY:...

MARCH 11, 2026 PromptCraft: Prompts That Help Students Study for Exams, Decode Workplace Feedback, and Cut AI Voice for More Usable Copy THE HEADLINES: The Top 100 Gen AI Consumer Apps — 6th Edition; AI assistants now equal 56% of global search engine volume: Study; North Korean agents are using AI to trick western firms into hiring them, Microsoft states; OpenAI Acquires Promptfoo Tool Spotlight: Kodo: Create Fully Editable Designs by Chatting with AI TODAY: Prompts That Help Students Study...

MARCH 10, 2026 PromptCraft: Prompts to Sound Less Like AI and Create a Business Plan; PLUS, a Tool That Scores and Improves Your Existing Prompts THE HEADLINES: Netflix buys Ben Affleck’s AI filmmaking company InterPositive; Anthropic reveals which jobs AI cannot replace, introduces Claude Marketplace for Enterprise Users; Watch: Physical AI humanoids get to work at BMW factory; 10 ways teachers can use AI Tool Spotlight: AI That Lets You Sell What You Ship, Instantly TODAY: Prompts to Sound...