DEV Community

Cover image for I Built a Chrome Extension That Automates Outlook Email Campaigns Using Google Sheets πŸ“§
Tiny Task Pro
Tiny Task Pro

Posted on

I Built a Chrome Extension That Automates Outlook Email Campaigns Using Google Sheets πŸ“§

Email outreach is still one of the most effective ways to connect with potential clients, partners, and customers.

But if you've ever sent hundreds of emails through Outlook manually, you know how repetitive it becomes.

Open Outlook.

Create a new message.

Copy an email address.

Personalize the greeting.

Paste your message.

Click Send.

Repeat...

After spending countless hours on repetitive email campaigns, I decided to build a solution that works directly with Outlook while keeping the workflow as simple as possible.

That's how TinyTask Mailer for Outlook was created.

Why Build an Outlook Automation Tool?

Most email automation platforms are designed around Gmail or require users to migrate to expensive CRM systems.

However, many businesses still rely on Microsoft Outlook as their primary email platform.

Sales teams.

Corporate offices.

Recruitment agencies.

Government organizations.

Consultants.

Small businesses.

For these users, switching platforms isn't practical.

Instead of replacing Outlook, I wanted to enhance it.

The Goal

The objective was simple:

Continue using Microsoft Outlook.
Store leads in Google Sheets.
Automate repetitive tasks.
Keep campaigns organised.
Reduce manual work.
Make outreach faster without adding unnecessary complexity.
The Biggest Challenge

Sending one email is easy.

Sending 300 personalized emails without losing track is another story.

Some common problems include:

Forgetting which contacts have already been emailed.
Accidentally sending duplicate emails.
Losing progress after closing the browser.
Spending hours copying and pasting information.
Managing multiple campaigns at the same time.

These challenges inspired the development of TinyTask Mailer for Outlook.

How It Works

The extension reads recipient information directly from a Google Sheet.

For example:

Name Email Company
John Smith john@example.com ABC Ltd
Sarah Jones sarah@example.com XYZ Group

Instead of manually entering every recipient, the extension automatically processes each row and prepares personalised Outlook emails.

The message body remains exactly as you've written it.

Only the dynamic information changes.

Features
πŸ“„ Google Sheets Integration

Import recipient data directly from Google Sheets.

There's no need to export CSV files or import databases every time you launch a campaign.

Simply update your spreadsheet, and you're ready to go.

πŸ‘‹ Personalised Greetings

Nobody enjoys receiving emails that begin with:

Dear Customer

TinyTask Mailer automatically inserts recipient names from your spreadsheet, making each email feel more personal.

For example:

Hi John,

Thank you for taking the time to read my email...
πŸ“Š Campaign Dashboard

Large email campaigns require visibility.

The extension keeps track of:

Current row
Total recipients
Emails sent
Pending emails
Failed emails
Campaign status

You always know where your campaign stands.

⏸ Stop and Resume

Sometimes you need to pause your work.

Instead of restarting the campaign from the beginning, TinyTask Mailer remembers your progress and allows you to continue from the exact point where you stopped.

⏱ Random Sending Delays

Sending hundreds of emails within a few seconds isn't always ideal.

The extension introduces configurable delays between emails, creating a more controlled sending workflow that better reflects normal usage patterns.

πŸ“ˆ Usage Statistics

Campaign reporting includes useful information such as:

Emails sent today
Total emails processed
Remaining daily allowance
Campaign progress

This provides a clear overview without requiring external reporting software.

Why Google Sheets?

Google Sheets remains one of the simplest tools for organising outreach campaigns.

It already supports:

Client lists
Sales prospects
Recruitment contacts
Business directories
Follow-up tracking

Instead of introducing another database, TinyTask Mailer works with a tool that millions of professionals already use every day.

Typical Use Cases

TinyTask Mailer for Outlook has been designed for workflows such as:

Sales outreach
B2B prospecting
Recruitment campaigns
Customer follow-ups
Business partnerships
Event invitations
Vendor communication
Corporate announcements
Internal company updates
Marketing campaigns

If your contacts already live inside a spreadsheet, automation becomes much easier.

Why Outlook?

Microsoft Outlook remains one of the world's most widely used business email platforms.

Many organisations have invested heavily in Microsoft 365 and Outlook ecosystems.

Rather than asking users to change platforms, TinyTask Mailer extends the workflow they already know.

No complicated migration.

No additional CRM.

No unnecessary learning curve.

Just Outlook with smarter automation.

Lessons Learned During Development

Building browser automation isn't simply about clicking buttons.

A reliable automation tool needs to consider:

User experience
Campaign reliability
Progress recovery
Error handling
Secure license management
Performance optimisation
Browser compatibility

Every new feature introduced additional edge cases that needed careful testing before release.

The result is a workflow focused on stability and simplicity.

What's Next?

Development continues with new features planned, including:

Advanced campaign analytics
Additional personalization fields
Better reporting
Enhanced campaign management
Workflow improvements based on user feedback

The aim is to continue improving productivity without making the extension unnecessarily complex.

Final Thoughts

Building TinyTask Mailer for Outlook has been an enjoyable engineering challenge.

The project started as a way to eliminate repetitive email tasks, but it has grown into a practical tool for professionals who rely on Outlook every day.

If you're interested in browser automation, productivity tools, or Outlook-based workflows, I'd love to hear your thoughts.

Constructive feedback, feature ideas, and real-world use cases are always welcome.

Happy codingβ€”and happy automating! πŸš€

Top comments (0)