MorenaTech blog

Automation, data, and AI without the technology fog

Guides for small businesses, implementation examples, and technical articles for people who want to look inside AI, automation, and integration work.

The blog collects longer guides and technical articles. If you are looking for shorter updates, comments, and notes from the process, go to the MorenaTech newsroom.

Guide

Guides for owners and teams

Articles about automation, Google Workspace, Apps Script, data, and AI written from the perspective of business decisions, everyday work, and first implementations.

AutomationBasicabout 9 min
Published:

How to connect transfers, invoices, and shipping without manual payment checks

How to organize the process from order to dispatch: checking transfers, invoice status, courier label, client email, and manual exception review.

Audience: Small businesses handling orders, payments, and shipping

Google WorkspacePracticalabout 11 min
Published:

How to send small email campaigns from Google Sheets and Gmail without creating chaos

A practical step-by-step guide: Google Sheet, Apps Script, DRY_RUN mode, test without sending, and a controlled batch of Gmail messages.

Audience: Small businesses testing small outbound batches from Google Sheets

Google WorkspaceBasicabout 8 min
Published:

Automatic reports from Google Sheets: examples for a small business

Examples of automatic reports from Google Sheets: sales, deadlines, forms, PDFs, and exception reports for small businesses.

Audience: Small businesses reporting from Google Sheets

Google WorkspaceBasicabout 9 min
Published:

How to prepare a Google Sheet for automation

A practical checklist before automating Google Sheets: columns, statuses, data formats, identifiers, logs, permissions, and test data.

Audience: Teams working in Google Sheets

Google WorkspaceBasicabout 8 min
Published:

Apps Script or Make: what should a small business choose for automation?

A practical comparison of Apps Script and Make for a small business: when to choose Google Workspace scripts, when to choose an integration platform, and how to make the decision.

Audience: Small businesses choosing an automation tool

Google WorkspaceBasicabout 7 min
Published:

Google Workspace automation: 5 Apps Script use cases for a small business

Five practical uses of Apps Script that reduce manual work, organize recurring processes, and help a small business get time back.

Audience: Small businesses and operations teams

AI for businessBasicabout 8 min
Published:

Prepare your business for automation and AI: data, processes, and sheets step by step

How to organize data, documents, and processes before automation and AI so the tools help instead of adding more disorder.

Audience: Teams preparing data and processes before an AI rollout

AI for businessBasicabout 8 min
Published:

When not to implement AI in a small business: automation first, AI second

Not every small business should start with AI. See when it is better to organize processes and implement straightforward automation first.

Audience: Small businesses planning the first AI implementation

AI for businessBasicabout 8 min
Published:

How to implement AI in a small business without chaos

A practical path for introducing AI in a small business: choose one problem, check the data, run a small pilot, keep a human in the loop, and measure the effect.

Audience: Small businesses planning the first AI implementation

AutomationBasicabout 8 min
Published:

How to choose the first process for automation

A simple method for choosing the first process to automate: repeatability, input data, number of exceptions, effect, and business risk.

Audience: Small businesses choosing the first process

AutomationBasicabout 8 min
Published:

Automatic reminders for clients and the team

How to plan automatic reminders about payments, tasks, missing data, and deadlines without turning the company into a notification factory.

Audience: Small businesses managing deadlines and tasks

AutomationBasicabout 8 min
Published:

Invoice and payment automation in a small business

How to organize reminders, payment statuses, receivables reports, and information flow around invoices without implementing a large system.

Audience: Small businesses managing payment deadlines

AutomationBasicabout 9 min
Published:

Where to start automation in a small business: 7 good first processes

Not sure what to automate first? See 7 processes a small business should usually start with before thinking about more complex AI projects.

Audience: Small business owners

Under the hood

Technical notes, architecture, and experiments

Texts for people who want to look under the hood of AI solutions: MCP, assistant memory, agents, RAG, architecture, and technical experiments.

AI and automationTechnicalPracticalabout 10 min
Published:

How to transcribe video to text with FFmpeg and faster-whisper

A practical guide: extract audio from video with FFmpeg, run it through a local Whisper model, and save the result to a text file with timestamps.

Audience: Technical users and small businesses working with recordings

AI and projectsTechnicalPracticalabout 7 min
Published:

Git when working with AI: how not to lose control of the project

AI speeds up code changes, but Git lets you inspect the diff, work on a branch, save decisions in commits, and avoid turning the project into a chain of random experiments.

Audience: A small team working with AI on code, scripts, or automation

AutomationTechnicalTechnicalabout 10 min
Published:

Automating company search and outreach: architecture, risks, and lessons from a prototype

What a prototype looks like when it searches for companies, organizes contact data, and prepares outreach without scraping Google Maps and without an uncontrolled sending bot.

Audience: Technical users and small business owners

MCP and agentsTechnicalTechnicalabout 12 min
Published:

How to turn ChatGPT into a semi-agent: your own MCP with a folder, Python, PowerShell, and ngrok

How to connect your own MCP server to ChatGPT and turn it into a technical semi-agent for one workspace. Folder, Python, PowerShell, FastMCP, ngrok installation, smoke test, and common pitfalls.

Audience: Technical users and power users

AI for businessTechnicalTechnicalabout 8 min
Published:

Why AI needs memory. RAG is not enough when continuity of work matters

A context search engine alone is not enough when AI has to work for longer than a few minutes. See why assistants need memory, how it differs from RAG, and why many implementations end in operational amnesia without it.

Audience: Technical users and teams building useful AI assistants

MCP and agentsTechnicalTechnicalabout 10 min
Published:

MAPI-local-medium: a local MCP server that gives a model memory, tools, and boundaries

A technical explanation of what MAPI-local-medium is: a local MCP server that lets a language model use project memory, tools, context bootstrap, and a controlled working environment.

Audience: Technical users, power users, and automation builders