How to use Google Sheet as a CRM with Google Cloud Script automation

Ivan Oung

Cohort 6 Production is a web development company that focuses on helping SMEs to increase revenue and profit by offering web/app development services. This case was created as part of the automation project where I built a cost-effective, lightweight CRM for Cohort 6 Product to streamline their sales operation. The result?
  • 95% reduction of time spent on task per staff: Reduced time spend from 10 minutes → 30 seconds
  • Error-free: 100% elimination of human operation error
  • Cost-effective: Low-cost, tailor-made, highly standardized, full automation

What was the problem?

Pitching clients and managing project quotations are time-consuming and onerous, especially when the team is focusing on value-adding business activities, C6P wanted a CRM with automated document management functionality that helps them streamline their sales process.
  • Either building bespoke systems or existing alternatives are expensive
  • Need the solution to be flexible yet robust
  • Do not want to be tied down by subscriptions

Going through the process

As to keep the system simple, here are the business requirements.
  • Content management system with access permission control
  • Simple dashboard, easy to use
  • Use pre-built templates as a replica for all operations
In order to identify what I need to build, I created a flow diagram of the business process to identify where in the process the user needs to interact with the system, and what kind of results the user can expect at the end of the operation.
Business operation flow

My personal takeaways

The project was a success, not only it helps Cohort 6 Productions get their feet off the ground, but it is also a great way to introduce Google Script to the business, where the business can leverage the power of Google’s API to solve all kinds of business problems without investing into bespoke systems that build from scratch. Here’s what I’ve learned:
  • Code smarter — Use recursive for reading folders and generate templates for scalable growth without being limited by the codebase.
  • Allow user confirmation and self-correction —  By allowing the user to confirm their input before committing, not only reduces the frustration when mistakes are made, but it also reduces the chance where the user has to redo the procedure.

Navigation Menu


Stay In Touch!

I'll only send the good stuff, no spam, no bs, I promise!

More Readings

10 Reasons Why WordPress is the Ultimate Choice for Your Blogging Journey

Blogging has become a popular way for individuals and businesses to share their ideas, opinions, and experiences with the world. It allows people to connect with others who have similar ... Read more

Maximizing Your Website’s Potential with a CMS: A Beginner’s Guide

Content Management Systems (CMS) have become an essential tool in website management. With the increasing complexity of websites and the need for frequent updates, CMS provides a user-friendly interface that ... Read more

Unleashing the Power of Development: How to Foster Growth and Progress

Development is a crucial aspect of growth and progress in any field or industry. It involves a continuous process of improvement and innovation to achieve better results. Whether it’s in ... Read more

A WordPress Developer Who You Can Trust.

I always build my relationships with my clients based on trust. I want to see you grow as much as I myself. Let's work together to grow your business.

Get A Free Quote
Share to...