[Free] Google SpreadSheet Extension Fastest Lite Version

[KartikeyMittal]

Can I use this extension to get filterd range data from spreadsheet like a range of data in bw two dates?

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

for get filtered range data from spreadsheet you need to take lecture of spreadsheet query and try it with this extension query block

[PATIN_LABS]

Nice extension,
thanks Kulldepp_Pilaniya

@Kuldeep_Pilania

for get filtered range data from spreadsheet you need to take lecture of spreadsheet query and try it with this extension query block

[PATIN_LABS]

but how to remove row number one with your extension? because it always show in my list view

[Still-learning (1-2-3-4...)]

Catch the web got response content in a global variable and from this varibale ry to remove the index 1 using the block remove the item from the list (global list ) index (1) - this willl remove the header…

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

We developed new version are you join beta test program for this extension V2.
Only for 10 users. Telegram: Contact @Google_Sheet_Extension

[Helena]

Hello, I am making an APP and I need to take each data in the column, but when receive the results come the all date in the row that have the name of filter. How can I take each data the row?

[Still-learning (1-2-3-4...)]

based on your blocks, this block will return the last data

here use one loacal or global variable to print the index 2 items and then print the variable into the label

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

Latest Updated Extension with Power of SQL Query Function.

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

V2 work with Private Restricted Spreadsheets.

[FREE/PAID API] Advance Google Sheet Extension with SQL Query

[FREE/PAID API] Advance Google Sheet Extension with Power of SQL Query This extension allow you to get full control of Google Sheet Functions with API Key. It doesn’t require any Script just Create API Key and Connect Google Spreadsheet. Google Spreadsheet Extension is Free for first 100 Users with 1 Year Validity. Step1: How to Create API Key for Google Sheet Extension. Step2: How to Connect Google Sheet with Kodular. Google Sheet Extension Blocks Google Sheet Extension Propertie…

[Hazem_Eweiss]

I get row data and need to split received data in many labels and I tried this block and not applied.

[Still-learning (1-2-3-4...)]

this is wrong… first you need to convert into list (just interchange the blocks)

[Hazem_Eweiss]

@Still-learning

this is wrong… first you need to convert into

Thank you for your support

[404_Not_Found]

This post was flagged by the community and is temporarily hidden.

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

Can you explain it in English

[Shahab_R]

Please provide documentation for GotSheet. For variables are returned, namely:

code
msg
data
total rows

What is data type for each and what do these values represent?

Does ‘data’ contain everything in the sheet? And in what format? As a dictionary or what?

Also, an example code snippet on how to parse/use data would be much appreciated.

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

in Advance google Sheet Extension
Output Response Everything Explain in Details
code int
msg string
data string
total rows int
Read Full Article

[FREE/PAID API] Advance Google SpreadSheet Extension with SQL Query

[FREE/PAID API] Advance Google SpreadSheet Extension with SQL Query This extension allow you to get full control of Google SpreadSheet Functions with API Key. It doesn’t require any Script just Create API Key and Connect Google Spreadsheet. Google Spreadsheet Extension is Free for first 100 Users with 1 Year Validity. Step1: How to Create API Key for Google SpreadSheet Extension. Step2: How to Connect Google SpreadSheet with Kodular. Google SpreadSheet Extension Blocks Google Spre…

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

Parse Data String by using these blocks

[FREE/PAID API] Advance Google SpreadSheet Extension with SQL Query

Parse JSON as Local or Global Variable its Offline and Extract Data in Millisecond. [Parse JSON] its Compatible with Get Sheet, Get Range, Get Columns, Apply Filter, SQL Query.

[Yogendra_Kumar]

[https://kodular-community.s3.dualstack.eu-west-1.amazonaws.com/original/3X/6/9/695b010ccac383b18e1eca0a156e5fdffa6df966.png]

I used your blocks arrangement for getting data in Label component from google sheet (using your provided .aix for google sheets). I got full column data in single Label. I will feel more obliged and thankful, if you could tell me the way I can get the data of only one cell in one label, and with next button, second cell data in second label and so on. Not in a list, but navigating with Next Button. Thanks

[Kuldeep_Pilania (Kuldeep Pilaniya 🇮🇳)]

get list item position by list index block