Skip to content

A script to store data in google spreadsheets via frontend or backend.

Notifications You must be signed in to change notification settings

pagarevijayy/google-spreadsheet-script

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Collect user data in google sheets (instead of DB)

A script (more like a function that can be used in any node.js env) to store data in google spreadsheets.

Can be used as a quick hack where we don't need DB but want to collect some user data. (or migrate existing data to sheets)

This example is hard coded. Modify the script and data/input as per your use case.

How to run?

1. Create a .env file 
2. Store your sheet api_key and email_id inside the .env file
3. Run spreadsheet.js using node

// the concept can be extended to work on cliend-side

About

A script to store data in google spreadsheets via frontend or backend.

Topics

Resources

Stars

Watchers

Forks

Packages