google-apps-script-sheets-to-front-end-crud

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #golang #android #docker #java #awesome #awesome-list #pytorch #openai

google-apps-script-sheets-to-front-end-crud

(★ 14)

google apps scrips that makes sheets the database and scripts the backend for web front ends

google-apps-script-sheets-to-front-end-crud 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# google-apps-script-sheets-to-front-end-crud

The Google Sheets (GS) are confortable, powerful and free tool to keep data.
The Google Apps Scripts can handle GET and POST requests and is natively connected to google sheets as data storage.
netlify.com allows to host html+js pages from git.

joined together it may be a solution for numerous business cases.
and it's free, serverles and robust.

here will be the fishbone scrips that I use for GS to Web UI integrations

# Getting started
Separate GS with backend scripts from GS with data. It's safe, scaleable and don't cofuse users.
As scripts works as API and are nested in GS i name those files as GAPI {project name}
here is a template 
https://docs.google.com/spreadsheets/d/1toEbphpNpyR8v6mXPvZFpQ6cNyCpSR8YGydC7iOQMqI/edit?usp=sharing

# GAPI file sheets
a. "config" - it's good idea to keep as much as you can out from script. that makes changes faster and makes script reusable.

b. "web log" - to debug and log web requests and responses i log them here

c. "console" - sometimes results and error detaila need to be printed somewhere.

# Common scripts
# initConfig()
most of scripts starts from these rows to get config values
```
  function doIt(config){  
    if(config===undefined){
      config= initConfig()
    }
 }
 ```

# Log(data, [destination])
just put whatever you want to log here and get it as row added with timestamp in the destination ("web log" by default)
it's recommended to make new file for log destination if there will be 10K+ log rows to keep GAPI file small and fast.

# web.js
have files that get GET POST requests, route them to handler, prepare and return responses.

# Drive()
class that handles sheets access operations and returns responses with structureda data or handled and documented errors.

google-apps-script-sheets-to-front-end-crud

google-apps-script-sheets-to-front-end-crud 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

google-apps-script-sheets-to-front-end-crud

google-apps-script-sheets-to-front-end-crud 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README