Sheets Subordinate

Index

• About
• Note
• Demo
• Running Project Locally
• Project Status

About

A few clicks and you will be able to count the number of columns or tabs in your Google Sheets

Note

The project is hosted but it is not production ready kindly test the project locally, apologies for the inconvenience

Demo

Running Project Locally

• Fork the repo

• Clone the forked repo in your local machine

• Switch to dev branch (Recommended step)

  git checkout dev 
  

• Install Backend packages

  npm install 
  

• Create a .env file and paste it inside that

  ATLAS_URI="mongodb+srv://demoUser123:Ytt5vCgO6CxvrB5s@cluster0.0qeoht7.mongodb.net/sheetsdb?retryWrites=true&w=majority"

  ACCESS_TOKEN_SECRET=randomPairOfWords 

• Start the server locally (Configured Port:3000)

  npm start
  

• Go to the client folder (Open a new terminal to avoid the hassle )

  cd client
  

• Install frontend packages

  npm install
  

• Run the site locally (Port :5173)

   npm run dev
  

• Replace the url from 127.0.1 to localhost on your browser (IMPORTANT step for Oauth2 authentication)

• Raise an issue or contact me at shubhenduse322@gmail for any queries

Project Status

• Currently in the development phase (Facing issues in authenticating users via G Oauth2 on the hosted site)
• Tasks Completed
  1. jwt authentication + userData stored in the backend (used bcrypt for password hashing and salting)
  2. Added Subscriptions, and Dashboard in the frontend
• Tasks Pending
  1. Persisting user's credentials/access after Outh2 authentication for more than an hour
  2. Saving dashboard state in the database
  3. Refactoring code as it contains unnecessary Context Providers to transfer state along with some repetitive code
  4. An attractive User Interface, frontend authentication and error handling
  5. Properly host the site as well as the API