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 geobro2310@gmail.com.