Skip to content

Using express and google spreadsheets api, injecting content into HTML page. Basically a content manager

License

Notifications You must be signed in to change notification settings

albseb511/express_html_injector

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

README

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 inside server
  • 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 the client_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"
}

https://i.ibb.co/HHnYBB9/Screen-Shot-2019-12-07-at-8-21-19-PM.png

  • 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.

About

Using express and google spreadsheets api, injecting content into HTML page. Basically a content manager

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published