skip to content W3C SVG

Google Cloud Applications

Aug 17, 2019
Apr 22, 2020

Google Sheets

Sheets are are people, databases are for machines

  1. Merge multiple sheets data to one
  2. Logical Tests
  3. Regular Expressions for data validation/extraction
  4. Conditional Formatting, Locking the column $
  5. Dynamic dependent dropdown Lists
    1. Data validation
    2. Match(), Indirect(), Transposr()
  6. Use App Script custom Menu to Add NEW ROW (from a template/previous row)
  7. Send emails directly from spread sheet
  8. App Script functions to share on social media
  9. App Script functions to onboard/unboard from menu or from a action button, move them b/w sheets.
  10. Make interactive Timeline from spreadsheet data
  11. ArrayFormulas ={1,2,3; 4,5,6; 7,8,9}
  12. Import HTML tables, lists from web

How to use google sheets API

Google Sign IN for webapp

Federated LogIn - Google SignIn

  • SignIn Button
    • User accepts to share information
  • First signIn, then Incrementaal authorization
    • asking for permissions as they are needed
  • Add client_ID to meta and load google.api in head of Html page
  • Render BUtton
    • Design a custom button
    • EventListner when button is pressed to run GSignIn
    • returns google object with user info
  • Google Login WOrkflow
  • How OAUTH works with nUXT
    • Use js debugger
    • Use try, catch here
    • Thankyou user for logging in
gapi.load('auth2', function () { gapi.auth2.init(); })

What do people do with it? Use cases

sheets which can do calculations

  1. Calculator
  2. Databases
  3. Analysis
  4. Modelling
  5. List Management
  6. Data Visualization
  7. Report generation
  8. Workflow Application
    1. Email everytime a new entry is added, with new entry and link to sheet
    2. Capture fields from Google Forms
  9. Documentation etc.

Its like a infant, Do not even know the boundaries of theor own ideas, they scratch theor own head.

  • Google Sheets as a JSON Endpoint

FAQ

Features

  • Copy paste to get ris of the underlying formula for us
  • Import data from multiple sources (shapes, size)
  • Can show image thumbnails
  • Rows Grouping

Footnotes