A boiler plate code for getting started with Google Sheets API.
Contributions are always welcome!
- Refactored code🤘
- Added few comments for readability.
Server: Node, Express, Dotenv, googleapis
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!
For support, email [email protected].