LIVE DEMO
https://boiling-sierra-10669.herokuapp.com/
SETUP:
Use google sheets to fill in information inside HTML page:
- goto developer google console
- create a new project
- enable and configure Google Drive API
- select gogole drive api
- select Web server(node)
- Application data
- No for App Engine or Compute Engine
- give a name for the service account
- give it an editor as role (i think it should work as only view also)
- download the credentials
- create folder
config
insideserver
- copy the credentials file inside config folder and rename it as
client_secret.json
- Create an excel sheet and share the sheet to the
client_email
value inside theclient_secret.json
- Goto your google sheets, copy the sheet id
https://docs.google.com/spreadsheets/d/<SHEET_ID>/edit
- create a file sheet_id.json inside the config folder
{
"sheetId":"SHEET_ID"
}
- Store information in the excel sheet
- use the html tags as your id in your html page
How to use:
cd server
node index.js
// server is running
Let me know if something is not working.