CRM-App

CRM application is built on the Node.js platform, leveraging the power of Google Sheets as a flexible and scalable backend database. This innovative solution aims to streamline and enhance customer interactions, providing businesses with a robust tool to manage, analyze, and optimize their relationships with clients.

Features

Utilize the familiarity and accessibility of Google Sheets as the primary backend database.
Seamlessly sync data between the Node.js application and Google Sheets for real-time updates and collaboration.
Efficiently organize and manage customer contacts with detailed profiles.
Easily add, edit, and delete contacts, ensuring an up-to-date database.

Environment Variables

To run this project, you will need to add the following environment variables to your .env file

GCLOUD_PROJECT GOOGLE_APPLICATION_CREDENTIALS GOOGLE_SHEET_ID GOOGLE_SHEET_NAME SCHEMA_SHEET_NAME

Run Locally

Pre-requisite

Update the .env file with the correct Google Sheets
Refer https://docs.google.com/spreadsheets/d/1FMyPS9jasayfPLxdX8McuB-AWMufq5bVQjNuZKqbTm4/edit?usp=sharing for details on how to setup google sheet

Clone the project

  git clone https://github.com/vipulbehl/CRM-App

Go to the project directory

  cd CRM-App

Install dependencies

  npm install

Start the server

  npm run start

Creating a windows executable

  pkg . -t node18-win