Google sheets data loader 2.1


Based on:

https://github.com/chriszarate/sheetrock


Valid querys:

https://developers.google.com/chart/interactive/docs/querylanguage


More info:

https://visualneo.com/forum/topic/neogsheets-google-sheets-plugin


Sample App:
https://visualneo.com/tutorials/neogsheets

 

neoGSheetsLoad

Purpose:

Load Google Sheets data into an Array of JSON objects


Query sampe: select A,B,C where E = 'VAL' order by L desc

Category:

neoGSheets

Syntax:

neoGSheetsLoad "gsheets" theArray "sqlquery" subroutine

 

gsheets

Public Google sheet URL

theArray

JSON data object to store the data

sqlquery

Query (optional)

subroutine

Callback subroutine (optional)

 

neoGSheetsLoadColumn

Purpose:

Load Google Sheets data into an Array of JSON objects


Query sampe: select A,B,C where E = 'VAL' order by L desc

Category:

neoGSheets

Syntax:

neoGSheetsLoadColumn "gsheets" theArray "columnLetter" subroutine

 

gsheets

Public Google sheet URL

theArray

Array to store the data

columnLetter

Column letter (A,B,C...)

subroutine

Callback subroutine (optional)

 

neoGSheetsLoadCell

Purpose:

Load Google Sheets data into an Array of JSON objects


Query sampe: select A,B,C where E = 'VAL' order by L desc

Category:

neoGSheets

Syntax:

neoGSheetsLoadCell "gsheets" myVariable "columnLetter" rowNumber subroutine

 

gsheets

Public Google sheet URL

myVariable

Variable to store the data

columnLetter

Column letter (A,B,C...)

rowNumber

Row number

subroutine

Callback subroutine (optional)

 

neoGSheetsLoadAsTable

Purpose:

Load Google Sheets data into an Array of JSON objects


Query sampe: select A,B,C where E = 'VAL' order by L desc

Category:

neoGSheets

Syntax:

neoGSheetsLoadAsTable "objId" "gsheets" "sqlquery" subroutine

 

objId

Container to show the data

gsheets

Public Google sheet URL

sqlquery

Query (optional)

subroutine

Callback subroutine (optional)

 

neoGSheetsLoadByName

Purpose:

Load Google Sheets data into an Array of JSON objects


Query sampe: select @@name,@@profession,@@email where @@age > 55 order by @@salary desc

Category:

neoGSheets

Syntax:

neoGSheetsLoadByName "gsheets" theArray "fieldPrefix" "sqlquery" subroutine

 

gsheets

Public Google sheet URL

theArray

JSON data object to store the data

fieldPrefix

characters used before fieldNames in sqlquery

sqlquery

Query (optional)

subroutine

Callback subroutine (optional)