Skip to content

GeoBrodas/google-sheets-crud

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Google Sheets CRUD API

A boiler plate code for getting started with Google Sheets API.

Contributing

Contributions are always welcome!

What's new in v1.0?

  • Refactored code🤘
  • Added few comments for readability.

Tech Stack

Server: Node, Express, Dotenv, googleapis

Run Locally

Clone the project

  git clone https://github.com/GeoBrodas/google-sheets-crud.git

Go to the project directory

  cd my-project

Install dependencies

  npm install
  • Create a new .env file.

  • Make a new project in Google Cloud console.

  • Integrate Google sheets API with the project.

  • Make a new service account, and a new Key.

  • Copy the downloaded file to your remote workspace and rename it as credentials.json.

  • Add the service email to the newly created Google sheets file at https://docs.google.com/spreadsheets

  • Start the server

  npm run dev

For full step-by-step tutorial visit this Blog!

Support

For support, email [email protected].