Freelancers using Google Sheets in Nairobi

Freelancers using Google Sheets in NairobiFreelancers using Google Sheets in Nairobi

Projects People

Power BI Expert/Executive Assistant/Researcher

Power BI Expert/Executive Assistant/Researcher

Cover image for Research Super-Pen

Research Super-Pen

0

40

Cover image for Effective Admin Strategies

Effective Admin Strategies

0

43

Cover image for Professional PowerPoint Presentation

Professional PowerPoint Presentation

0

11

Cover image for Inbox Done

0

24

Google Sheets(2)

Ann Syombua Peter

Administrative Virtual Assistant | AI Automation of workflow

9: Followers

Administrative Virtual Assistant | AI Automation of workflow

Cover image for Manual Financial Data Transfer: PDF

Manual Financial Data Transfer: PDF to Google Sheets (375 Pages) The Challenge: A client needed a full year of 2025 financial records spanning 375 pages of PDF documents, accurately transferred into a structured Google Sheet for easier analysis, reporting, and record-keeping. Given the sensitivity and precision required for financial data, the client specifically requested a fully manual, copy-and-paste transfer rather than an automated PDF-to-sheet conversion, to avoid formatting errors, misaligned figures, or data corruption common with auto-extraction tools. My Approach: I worked directly through each of the 375 pages, manually reviewing and entering every figure into a clean, organized Google Sheet structure. To maintain accuracy and consistency throughout the project, I: -Cross-checked each entry against the source PDF before finalizing it. - Organized the sheet with clear categories and consistent formatting for easy navigation and future reporting. - Maintained a steady, disciplined workflow to meet a tight three-day turnaround without sacrificing accuracy. - Flagged any unclear or inconsistent entries in the source material for client review. Tools Used: - Google Sheets (data entry, formatting, organization). - Adobe Acrobat / PDF viewer (source document review). - Manual data verification techniques (double-entry cross-checking). The Impact: The client received a fully accurate, well-organized digital record of their entire 2025 financial data, free from the errors that automated extraction often introduces. This gave them a reliable foundation for financial reporting, auditing, and decision-making, with data they could trust down to the last figure. Completing the transfer within three days also meant the client could proceed with their financial review without delay.

5

608

Cover image for Lead generation. Supported a client's

Lead generation. Supported a client's business development operations over 5 months, taking full ownership of lead generation, email communications, and cross-continental meeting coordination. On LinkedIn, I researched, identified, and compiled 500+ qualified leads tailored to the client's target audience, building a pipeline that fed directly into the sales and outreach process. Throughout the engagement, I worked independently, communicated proactively, and delivered to the deadline every week, giving the client the bandwidth to focus on strategy while I handled the operational details.

1

278

Cover image for AI-Powered Lead Follow-Up & Management

AI-Powered Lead Follow-Up & Management for Miale I automated lead follow-up and management for Miale to reduce the manual work involved in reviewing enquiries, categorizing leads, responding to prospects, and keeping the team informed. The problem: When leads come in, manually reviewing each response, deciding how to handle it, sending emails, and notifying the team can take time, and makes it easier for follow-ups to slip through the cracks. The solution: I built an AI-powered workflow in Make that automatically processes new lead submissions. Here’s how it works: Google Form → Google Sheets → AI Classification → Router → Email + Slack → Lead Tracking When a prospect submits the form, AI analyzes their collaboration interest and categorizes the lead as Collaboration Lead, Needs Follow-up, or Not Interested. The workflow then automatically: - Routes the lead based on their response. - Sends a relevant email to the prospect. - Notifies the team in Slack when a new lead needs attention. - Updates the lead record for easier tracking. Tools used: Make · Make AI Toolkit · Google Forms · Google Sheets · Gmail · Slack The workflow can also be adapted for client enquiries, sales leads, service requests, bookings, applications, and other repetitive lead-management processes. The goal isn't simply to automate tasks. It's to build a system that helps businesses respond faster, stay organized, and reduce manual follow-up work.

2

168

Cover image for AI-Powered Gmail Inbox Assistant: Turning

AI-Powered Gmail Inbox Assistant: Turning Email Overload into an Organized Workflow A busy inbox can become a productivity problem. For a VA or business owner handling a high volume of emails, manually reading every message, deciding its priority, summarizing it, determining what action is needed, and organizing it takes time. And when everything sits in one inbox, important messages can easily get lost among routine notifications and newsletters. I built an automation to solve that problem. The Solution I created an AI-powered Gmail inbox assistant that captures, analyzes, organizes, and records incoming emails automatically. The workflow starts when a new email arrives in Gmail. New Gmail → AI analyzes the email → Information is recorded in Google Sheets → Zapier Paths route the email → Gmail label is applied The AI extracts useful information from each email, including: Priority – how urgently the email needs attention Email summary – a concise explanation of what the message is about Recommended action – what should be done next Service/category – used to determine how the email should be handled The information is then captured in a Google Sheet, creating a structured record that can be reviewed, tracked, and used for further workflows. From there, Zapier Paths use the classification to route the email to the appropriate action. For example: Urgent email → AI identifies the priority and summarizes the message → information is recorded in Google Sheets → Urgent Path runs → Gmail applies the Urgent label. WorkApp/Sites notification → AI identifies the category → details are recorded in Google Sheets → WorkApp/Sites Path runs → the corresponding Gmail label is applied. Newsletter → AI classifies and summarizes it → information is recorded in Google Sheets → Newsletter Path runs → the Newsletters label is applied. What Problem Does This Solve? This automation addresses several repetitive administrative tasks at once. Instead of manually opening emails, interpreting them, recording important details, and organizing them, the workflow handles the first layer of processing automatically. It helps create: Less manual sorting Emails are categorized automatically. Better visibility The Google Sheet provides a structured overview of incoming messages, their priority, summaries, and recommended actions. Faster prioritization Users can identify emails requiring attention without reading through the entire inbox first. A searchable record Important email information is captured in one place instead of remaining buried inside an inbox. How Businesses Can Use It The workflow can be adapted to different businesses and inboxes. For example, a company could create categories such as: Client enquiries | Leads | Support requests | Finance | Internal communication | Urgent | Newsletters The Google Sheet can then become a simple operational dashboard or the starting point for additional automations. For example, a business could later extend the workflow to: Urgent email → notify the responsible team member Client enquiry → create a lead in a CRM Follow-up required → create a task Support request → route to the appropriate team This makes the workflow more than an inbox organizer. It can become part of a wider business process automation system. Tools Used Gmail – captures incoming emails and applies labels AI by Zapier – analyzes and classifies email content Google Sheets – stores the email priority, summary, recommended action, and category Zapier Paths – applies conditional logic and routes emails based on their classification What This Project Demonstrates My approach to automation is simple: Find the repetitive problem first. Then build the system around it. This project started with a common administrative problem—too much email and too much manual sorting—and turned it into a workflow that can analyze information, structure it, make routing decisions, and trigger actions automatically. I'm building my skills in AI automation with a VA mindset: understanding the business problem first, then creating practical systems that reduce manual work and improve how information flows.

2

202

Google Sheets(2)

Johnson Wairimu

Delivering Strategic Growth Through Data, Finance & Tech.

10: Followers

Delivering Strategic Growth Through Data, Finance & Tech.

Cover image for 📊 Toyota Global Performance Dashboard

📊 Toyota Global Performance Dashboard — Quick Analysis by Intersect Analytics We recently came across Toyota’s global automotive data and carried out a quick Power BI-driven business intelligence analysis to uncover the trends driving performance, revenue, and market dominance. Key Findings: 🚗 RAV4 emerged as a major revenue driver, reinforcing the growing dominance of SUVs in the global automotive market. 🌍 Asia-Pacific remains Toyota’s strongest-performing region, contributing the largest share of global vehicle sales and market influence. ⚡ Hybrid & electrified vehicles continue gaining momentum, signaling a strong transition toward sustainable and future-focused mobility. 📈 Toyota maintained impressive global sales performance, with a small number of flagship models driving a significant share of total revenue. 💡 What does this tell us? The businesses leading today are not necessarily those with the most data — but those that understand how to use it strategically. At Intersect Analytics, we specialize in transforming raw business data into strategic insights, executive dashboards, automation systems, and business intelligence solutions that improve decision-making and unlock growth opportunities. Our services include: ✅ Power BI Dashboard Development ✅ Business Intelligence & Data Analytics ✅ Workflow Automation Across Multiple Platforms ✅ Financial, Sales & Operational Analytics ✅ Executive Reporting & KPI Tracking ✅ SQL, Python, Excel & Cloud Analytics Solutions ✅ AI-Powered Reporting & Predictive Insights Whether you operate in finance, logistics, healthcare, retail, manufacturing, or e-commerce, we help organizations transform complexity into clarity through data visualization, automation, and advanced analytics. Because data alone does not create growth. Insights do. DECISIONS BACKED BY DATA. GROWTH DRIVEN BY INSIGHT. 📱 WhatsApp: +254 723 632 207 #DataAnalytics #BusinessIntelligence #PowerBI #DashboardDesign #Automation #FinancialAnalytics #SQL #DataVisualization #AI #DigitalTransformation #Toyota #BusinessGrowth

0

33

Cover image for Safaricom Financial Performance Dashboard (FY20–FY24):

Safaricom Financial Performance Dashboard (FY20–FY24): Key Insights & Business Impact The Safaricom Financial Dashboard provides a clear, data-driven view of performance over five years, highlighting both growth opportunities and critical financial pressures. 🔍 Key Findings Strong Revenue Growth: Total revenue shows consistent growth, driven by digital transformation. M-PESA Dominance: M-PESA has emerged as the largest revenue contributor, reinforcing its role as a core growth engine. Mobile Data Expansion: Sustained growth in mobile data reflects increasing demand for digital services. Decline in Traditional Revenue: Voice and messaging revenues continue to decline, signaling a shift in customer behavior. Margin Pressure: Rising operating costs, direct costs, and ECL provisions are compressing profitability. Profitability Decline: Net profit has decreased despite revenue growth—highlighting inefficiencies. Cash Flow Concerns: Declining free cash flow indicates increasing capital demands. High Dividend Payouts: Continued strong dividends despite cash flow pressure raise sustainability questions. 🚀 What This Means for Businesses Growth alone is not enough — cost optimization and efficiency are critical Businesses must track performance beyond revenue to understand true profitability Real-time insights are essential to respond quickly to financial risks and opportunities 💼 How Intersect Analytics Adds Value At Intersect Analytics, we go beyond dashboards — we deliver decision intelligence. 📊 Financial Analytics Expertise Deep understanding of financial metrics, KPIs, and business drivers ⚙️ Custom Power BI Dashboards Interactive, scalable dashboards tailored to your business needs 🔗 Data Integration & Automation Seamless connection of multiple data sources with automated reporting 📈 Insight-Driven Decision Making We don’t just show data — we explain the “why” behind it 🧠 Strategic Approach Combining finance, analytics, and business strategy for real impact ✅ Why Choose Intersect Analytics Proven experience in financial analytics & dashboard development Solutions designed for clarity, scalability, and performance tracking Strong focus on business impact — not just visuals Reliable partner for end-to-end analytics and continuous support 📩 Looking to transform your financial data into actionable insights? Let Intersect Analytics build a powerful, intelligent dashboard that drives smarter decisions and business growth.

1

1

57

Cover image for Executive Review: Global Aircraft Manufacturing

Executive Review: Global Aircraft Manufacturing Intelligence Dashboard The Global Aircraft Manufacturing Intelligence Dashboard demonstrates how modern Business Intelligence can transform complex aviation datasets into strategic insights that support executive decision-making. By integrating production, delivery, market share, and regional performance data from leading aircraft manufacturers into a unified Power BI environment, the solution provides stakeholders with a comprehensive view of industry performance and emerging market trends. The analysis indicates that Airbus and Boeing continue to dominate the global commercial aviation market, while manufacturers such as Embraer, Bombardier, Dassault Aviation, Gulfstream, and COMAC continue to strengthen their presence across regional, business, and emerging aviation segments. Through interactive visualizations, users can evaluate production performance, delivery trends, market distribution, and competitive positioning to better understand the evolving dynamics of the aerospace industry. Beyond visualization, the dashboard serves as a strategic decision-support platform by enabling organizations to monitor key performance indicators, identify growth opportunities, anticipate market shifts, and improve forecasting accuracy. The ability to consolidate multiple data sources into a single, reliable reporting environment significantly reduces manual reporting effort while improving data consistency and operational visibility. At Intersect Analytics, we specialize in designing enterprise-grade Business Intelligence solutions that convert fragmented business data into actionable intelligence. Our expertise spans Power BI Dashboard Development, Financial Analytics, Executive Reporting, SQL Data Modeling, Python Analytics, Excel Automation, Office Scripts, Power Automate, Predictive Analytics, and Data Engineering. Every solution we develop is tailored to enhance reporting efficiency, strengthen decision-making, and support long-term business growth. Rather than simply building dashboards, we develop intelligent reporting ecosystems that enable organizations to automate reporting, improve operational performance, and make strategic decisions with confidence. Intersect Analytics Decisions Backed by Data. Growth Driven by Insight.

1

110

Cover image for 🚗 Executive Automotive Industry Intelligence

🚗 Executive Automotive Industry Intelligence — Powered by Power BI How do the world's leading automotive manufacturers compare when it comes to revenue, profitability, production, and market performance? At Intersect Analytics, we developed this executive Power BI dashboard to transform complex automotive industry data into a single source of truth for strategic decision-making. 📊 Executive Insights Our analysis revealed several key industry trends: 🏆 Toyota Motor Corporation continues to lead the global automotive market, generating the highest revenue while maintaining exceptional profitability and vehicle production volumes. 📈 Volkswagen Group remains one of the strongest global competitors, demonstrating consistent revenue growth and a diversified international market presence. ⚡ BYD has emerged as one of the fastest-growing manufacturers, driven by rapid expansion in electric vehicle production and increasing global demand. 💰 While several manufacturers generate significant revenue, profit margins vary considerably, highlighting differences in operational efficiency, manufacturing costs, and pricing strategies. 🌍 Asian manufacturers continue to dominate the global automotive industry, contributing the largest share of revenue and vehicle production compared to Europe and North America. 🚘 The transition toward electric and hybrid vehicles is reshaping the competitive landscape, with manufacturers investing heavily in next-generation mobility technologies. 📉 Comparing Revenue against Cost of Sales reveals that companies with stronger cost control consistently deliver higher profitability despite operating in the same competitive environment. 📊 Revenue per vehicle varies significantly across manufacturers, reflecting differences in brand positioning, product mix, and premium versus mass-market strategies. What This Dashboard Delivers ✔ Executive KPI Scorecards ✔ Revenue & Profitability Benchmarking ✔ Global Vehicle Sales Analysis ✔ Regional Performance Comparison ✔ Revenue vs Cost Analysis ✔ Net Profit Margin Analysis ✔ EV, Hybrid & ICE Market Breakdown ✔ Interactive Geographic Performance Mapping ✔ Executive-ready Multi-page Reporting Our Services At Intersect Analytics, we help organizations transform raw business data into executive intelligence through: ✅ Power BI Dashboard Development ✅ Financial Analytics & Executive Reporting ✅ Business Intelligence Solutions ✅ Excel & Google Sheets Automation ✅ SQL Data Modeling & ETL ✅ Power Query & DAX Optimization ✅ KPI Scorecards & Performance Monitoring ✅ Predictive Analytics & Decision Support Every dashboard we build is designed to help leaders move beyond reporting—to uncover trends, optimize performance, and make confident, data-driven decisions. 📊 Decisions Backed by Data. Growth Driven by Insight. If your organization is ready to unlock the full potential of its data, let's build a solution tailored to your business.

0

55

Google Sheets(2)

I transform disorganized data and messy cloud drives

New to Contra

I transform disorganized data and messy cloud drives

Cover image for Bulk Data Cleansing
Title: Multi-Source CRM

Bulk Data Cleansing Title: Multi-Source CRM Contact Database Standardization Project Description: Scrubbing and consolidating messy consumer data lists compiled across multiple event sign-up forms and legacy sheets into a single, clean master file ready for database migration. What I Did: Executed deep deduplication across 15,000 rows of raw customer contact text records. Normalized phone numbers into standard international formats and fixed mismatched date structures. Cleaned up text columns by fixing typos, capitalizing names, and separating merged text fields. The Result: Delivered a 100% error-free, tabular dataset ready for smooth CRM integration without any broken entries.

0

29

Cover image for Knowledge Management Mapping
Title: SharePoint Knowledge

Knowledge Management Mapping Title: SharePoint Knowledge Base Setup & Metadata Tagging Project Description: Migrating an organizational document registry into a modern, searchable SharePoint environment to capture institutional memory and secure data sharing. What I Did: Designed a custom metadata mapping profile layout to organize documents cleanly. Assigned explicit property tags (such as Project, Document Type, Fiscal Year, and Access Level) across the digital assets. Configured permissions and access controls to ensure strict data governance. The Result: Built a fully filterable internal wiki and knowledge repository that protected sensitive data while keeping information instantly discoverable.

0

34

Cover image for Title: Google Drive Restructuring &

Title: Google Drive Restructuring & File Taxonomy Design Project Description: Transforming a chaotic, 4-year-old corporate Google Drive into a streamlined, high-efficiency repository. The client was a growing regional operations team struggling with duplicate files, missing folders, and a complete lack of naming standards. What I Did: Audited over 3,000 corporate documents and removed a massive amount of duplicate file clutter. Designed a standard 5-tier organizational taxonomy tailored to the company’s core business tracks. Established and deployed a strict, mandatory naming convention framework (YYYYMMDD_DocumentName_v1.0). The Result: Reduced employee file retrieval times from minutes down to just three clicks. Project 2: Bulk Data Cleansing Title: Multi-Source CRM Contact Database Standardization Project Description: Scrubbing and consolidating messy consumer data lists compiled across multiple event sign-up forms and legacy sheets into a single, clean master file ready for database migration. What I Did: Executed deep deduplication across 15,000 rows of raw customer contact text records. Normalized phone numbers into standard international formats and fixed mismatched date structures. Cleaned up text columns by fixing typos, capitalizing names, and separating merged text fields. The Result: Delivered a 100% error-free, tabular dataset ready for smooth CRM integration without any broken entries.

0

45

Cover image for Cleansed the Projects Dashboard for

Cleansed the Projects Dashboard for Machakos County

1

51

Google Sheets(1)

Digital Growth Strategist for Service Businesses

New to Contra

Digital Growth Strategist for Service Businesses

Cover image for Global Cosmetics Manufacturer Sourcing Research

Global Cosmetics Manufacturer Sourcing Research - Conducted global supplier research for a beauty brand seeking suitable cosmetics manufacturers in the USA, China, and India. I evaluated 8 manufacturers based on private-label capabilities, MOQs, lead times, costs, certifications, quality standards, and reputation. I organized the findings into a structured comparison report and ranked the top 5 suppliers based on the client’s requirements, providing clear, actionable recommendations to support supplier selection and product development.

0

28

Cover image for Anyeka Digital Institute — Digital

Anyeka Digital Institute — Digital Presence & Website Developed and deployed a professional digital presence for a digital skills training institute, including the website structure, course presentation, content organization, domain setup, and professional email configuration. The project focused on creating a clear, credible online presence that makes it easier for prospective learners to understand the institute’s offerings and take the next step.

0

21

Cover image for Rise Beyond Coaching — Landing

Rise Beyond Coaching — Landing Page Concept A clean, conversion-focused landing page concept designed for a coaching business to communicate its value clearly, build trust, and guide potential clients toward taking the next step.

0

27

Cover image for JJ Luxe Salon — Landing

JJ Luxe Salon — Landing Page Concept A modern, conversion-focused landing page concept designed to give a luxury salon a polished digital presence, showcase its services, and guide visitors toward booking.

0

30

Google Sheets(1)

I am a customer service officer and UI/UX designer

I am a customer service officer and UI/UX designer

Cover image for Lengo goal tracking app

Lengo goal tracking app

0

18

Cover image for GAB Omni

0

4

Cover image for Salama Safety App

Salama Safety App

0

2

Cover image for Job Tracking System

Job Tracking System

0

2

Google Sheets(3)

Statistician and Data Analyst Expert

Statistician and Data Analyst Expert

Cover image for Quality Data Entry and Technical Writing at Affordable Rates

Quality Data Entry and Technical Writing at Affordable Rates

0

11

Cover image for Professional Statistics Tutor and Assignment Helper

Professional Statistics Tutor and Assignment Helper

0

6

Cover image for Expert Data Analysis & Statistics Services

Expert Data Analysis & Statistics Services

0

6

Placeholder project card media

View more →

Google Sheets(1)

Data Entry & Social Media Expert

Data Entry & Social Media Expert

Cover image for Data Entry / Online research

Data Entry / Online research

0

8

Cover image for Your Personal Virtual Assistant

Your Personal Virtual Assistant

0

6

Cover image for Social Media manager

Social Media manager

0

10

Placeholder project card media

View more →

Google Sheets(2)