Skip to content

Latest commit

 

History

History
25 lines (19 loc) · 1023 Bytes

README.md

File metadata and controls

25 lines (19 loc) · 1023 Bytes

graph_api_google_sheets

see the sample website

  1. Create a google sheet
  2. Change permission to Anyone on the internet with the link can view
  3. Get key of the document
    eg: https://docs.google.com/spreadsheets/d/18XF7jOBaUOMoN5KuTi5NNzq-HgAV-7Rmt1-V3H674HA/edit#gid=0 "18XF7jOBaUOMoN5KuTi5NNzq-HgAV-7Rmt1-V3H674HA" is the document id for the above url
  4. Add the key to script.js
  5. Add sheet name to script.js. If not provided, first sheet is considered
    var gsKey = '18XF7jOBaUOMoN5KuTi5NNzq-HgAV-7Rmt1-V3H674HA'; var sheet_name = null var gql = "SELECT *";
  6. Add required gquery. learn more about query language
  7. You can't use table headers to query, you have to use Column Name(eg: A,B,C like that)

For adding data to google sheet

  1. Google Forms
  2. Appsheet by Google