Professional Portfolio

Nwachukwu Modesta

Virtual Assistant

A tech-savvy virtual and executive assistant with over 2 years of experience supporting professionals and teams. I specialise in streamlining operations, managing schedules, inboxes, and projects, and building no-code automations using tools like Airtable, Zapier, Make.com, Monday.com, and HubSpot CRM. I'm also highly proficient in Google Workspace and Microsoft 365, bringing strong organisation, communication, and digital workflow skills to every task.

Skills & Services I Offer

CRMs & Workflow Automation
Administrative Assistant
Executive Assistant
Project Management
Calendar Management
Customer Service
Email Management
Data Entry
Graphic Design
Landing Page
Google Workspace
Microsoft Office Suite

Automated Invoice Extraction & Email Notification Workflow using n8n

I built an end-to-end n8n automation to streamline invoice processing and internal notifications:

Google Drive Trigger – Detects new invoice PDFs on upload.
Download & Extract – Retrieves the file and parses client info, invoice number, total, and due date.
Information Processing – Uses a custom extractor with Google Gemini to structure and validate data.
Database Update – Logs the details in a Google Sheet for tracking and reporting.
Automated Email – Creates a professional email and sends it to the billing team via Gmail.

This workflow removes manual data entry.

Accounts Receivable Tracking Sheet for Small Business

This project involves creating a dynamic Google Sheet to track and manage accounts receivable for a small business. The sheet automatically calculates payment status based on amounts paid, highlights overdue invoices, and visualizes key metrics through charts. Features include:

Automated Status Tracking: Uses formulas to mark invoices as Paid, Partially Paid, or Unpaid.
Days Outstanding Calculation: Dynamically calculates how long invoices have been pending.
Visual Reporting: Pie charts and bar charts display payment distribution and receivables by client.

Graphic Design

I create eye-catching, meaningful designs that align with each project's goals, strengthening brand identity and making a lasting impact on the audience.

Calendar Management

I efficiently manage calendars using tools like Google Calendar to organize appointments, avoid scheduling conflicts, and ensure timely follow-ups. My approach supports smooth workflows and improves overall productivity.

Workflow Automation using Make.com

I use Make.com to build efficient automation workflows that connect various tools and eliminate repetitive tasks. This streamlines processes such as data collection, email responses, and task updates, helping to improve productivity and ensure smooth day-to-day operations.

Automated Lead Capture & HubSpot Sync with Slack/Email Notifications

I built an automated workflow in Make (formerly Integromat) connecting Google Forms, Sheets, Slack, Email, and HubSpot CRM. When a form is submitted, responses go to Sheets, where a router checks if the contact exists. New contacts are added, existing ones updated, and data is formatted consistently. Notifications are sent via email and Slack. This system reduces manual entry, removes duplicates, and keeps HubSpot updated with data in real time.

Scenario with different Modules

Contacted added to Hubspot CRM

Populated Google sheet

Slack Notification

Email Notification

Data Integration and Workflow Automation using Airtable

Designed and implemented an Airtable-based workflow system to streamline project, task, client, invoice, and employee tracking. Built relational tables for seamless data flow and configured automations to send real-time Gmail and Slack notifications on key status changes (e.g., project stage updates, invoice changes). This reduced delays, eliminated manual follow-ups, and improved collaboration, accountability, and overall team efficiency through centralized, automated communication.

Slack Notification

Email Notification

Email Management

I manage email communication effectively by organizing inboxes, setting up filters and labels, and ensuring timely responses. This helps maintain clear communication, prioritize important messages, and keep daily operations running smoothly.

Data Entry

Order Tracking & Reporting System

Built a Google Sheets order tracking system with automated status and priority dropdowns, conditional formatting for overdue orders, and structured reporting. This streamlined order management, reduced manual errors, and improved visibility for clients and internal teams.

Trainings & Certifications

Google Cloud Certified Professional Cloud Security Engineer - Google Cloud (2025)
Technical Support Fundamentals - Coursera (2024)
On Demand Digital IT Skills - Digital Witch Training (2024)
Virtual Assistant - ALX Africa (2024)

Contact details

Phone: +2347048690893

Email: uchechimodesta97@gmail.com

Page updated

Google Sites

Report abuse