[FREE/PAID API] Advance Google SpreadSheet Extension with Read, Write, Modify or Delete Functions

[FREE/PAID API] Advance Google SpreadSheet Extension with Read, Write, Modify or Delete Functions

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 to Test with 30 Days Validity.

Step1: How to Create API Key for Google SpreadSheet Extension.

Step2: How to Connect Google SpreadSheet with Kodular.

Google SpreadSheet Extension Blocks

:gear: Google SpreadSheet Extension Properties

:memo: Create New Sheet

Input

  • Sheet Name : String

Output

  • Sheet Name : String (New Created Sheet Name)

1

:spiral_notepad: Get All Sheet List

Output

  • Values : ListView
    2

:writing_hand: Create Columns / Titles

3

:writing_hand: Create Single / Multipe Rows

Input

  • Values : List for Single Row
  • Values : List of Lists for Multiple Rows

Output

  • Row Number : Return Created Last Row Number
    4

:arrow_right: Get Row by Row Number

Output

  • Values : ListView
    5

:arrow_up: Update Row by Row Number

6

:x: Delete Row by Row Number

7

:arrow_right: Get Cell by Row or Column

8

:arrow_up: Update Cell by Row or Column

9

:arrow_right: Get Sheet All Data

10

:arrow_right: Get Multiple Columns

Input

  • Columns : A,B,C / Get All Columns Property

Output

  • Data : String (Data Extract by Parse JSON or X Blocks)
    11

:arrow_right: Get Range

Input

  • From Cell : A1
  • To Cell : D20

Output

  • Data : String (Data Extract by Parse JSON or X Blocks)
    12

:arrow_up: Update Range

Input

  • From Cell : A1
  • To Cell : D20
  • Data : List of Data Lists
    13

Advance SQL Blocks

:arrow_right: Apply Filter

Input

  • Columns : A,B,C / Get All Columns Property
  • Conditions : Read More Documents
  • Order By :
    A (Only Column Name for Ascending)
    B DESC (for Descending)
    Note: Apply order on those columns that you get from Columns.
  • Rows Limit : int (Data Rows you want to Get)

Output

  • Data : String (Data Extract by Parse JSON or X Blocks)
    14

:arrow_right: SQL Query

Input

Output

  • Data : String (Data Extract by Parse JSON or X Blocks)
    15

:arrow_right: Find Row or Cell Data by Unique Column

Input

  • Unique Column : Unique Column Title
  • Find Text : String
  • From Column :
    Empty : Return Cell Value from Same Column Text Find
    Column Name: Return Cell Value From Column Text Find

Output

  • Code Message :
    200 Found Row Successfully
    201 Text Not Found
  • Value : Cell Value (String)
  • Values :
    Text Found: Return Row List
    Text Not Found: Return Empty List

16

:arrows_clockwise: Replace Row by Unique Column

Input

  • Unique Column : Unique Column Title
  • Find Text : String
  • Update Data : List of Values

Output

  • Code Message :
    200 Replace Row Successfully
    201 Text Not Found

17

:arrows_clockwise: Replace Cell Data by Unique Column

Input

  • Unique Column : Unique Column Title
  • Find Text : String
  • Set Column : in Column you want to Update Cell
  • Replace Text : New Cell Value you want to Update

Output

  • Code Message :
    200 Replace Cell Successfully
    201 Text Not Found
    18

:x: Remove Row by Unique Column

Input

  • Unique Column : Unique Column Title
  • Find Text : String

Output

  • Code Message :
    200 Remove Row Successfully
    201 Text Not Found
    19

:hammer_and_wrench: Extract Received Data

Extract Data, Received from Got Sheet, Got Columns, Filter Result, SQL Result, Got Range Events
These all are Offline Blocks its improve your app speed or reduce app response time.

Inputs

  • First Use Parse JSON Function : It’s Activate all X Blocks by using you can Filter Received Data easily or use all X Blocks as local or global variable.
  • Data : String
    (from Got Sheet, Got Columns, Filter Result, SQL Result, Got Range Events)

Outputs

  • JSON List : Convert String Data into List
  • X Column : Return any Column List from Parse Data
  • X Row : Return any Row List from Parse Data
  • X Cell : Return any Cell Value from Parse Data
  • X Length : Return Length of Parse Data
  • X Row Index : Return Row Index of Text Find from Parse Data
  • X Row Search : Return Row List of Text Find from Parse Data
  • X Cell Search : Return Cell Value by Text Find Row or from Column

:arrow_down: Download Extension or Admin App

GoogleSheet.aix (35.7 KB)
GoogleSheet.aia (49.6 KB)

or [Download Admin App for CREATE API KEY ]

GoogleSheet.apk (7.4 MB)

All Response Code Message

Success

  • 200 : Success Response
  • 201 : Text Not Found
  • 202 : Invalid Row / Column Name

Failed

  • 400 : Invalid Sheet Connection
  • 404 : API Key Expired
14 Likes

Nice useful Extension, we can reduce blocks using this extension…

3 Likes

image
I am trying take just the version and applink as variable, but no sucess, My ideia is check is version is actuall, if no, downloading by link.
image
Can I help me?

2 Likes

in Get Columns, Apply Filter or SQL Query columns as A,B,C…
Get Cell or Update Cell or All other functions work with Title as Column Name…
AiA file Update in Post use AIA for Testing with your API key or Sheet ID…

3 Likes

Update Cell Blocks

Single Cell Support String with Special Characters / Regional Language or Also Support List Values and Get Back Cell data and Convert them in List View by Json List Block

3 Likes


I would like get the version in Sheet, and if than more, the aswser will be yes, and will give the link to download new version by apk

1 Like

I will test with aia now.

1 Like

Update App Manually Blocks

2 Likes

How to Create Google Sheet Query and Test in Google Sheet
if Return Correct data than use it in Extension and Save your Time.

in Full Query only Green Text Query used in This Extension…
Like => SELECT * WHERE …

Google Sheet Query Full Lecture Playlist Here…

2 Likes

Thankyou so much, its possible ths in the free version with no power of SQL?

1 Like

In free version you can’t secure your sheetdata it’s open to all any one can view your data by using your sheet I’d and in free version update data is not possible easily.

1 Like

Thank you very much

1 Like

thank you very much , Rely it is Great

1 Like

Parse JSON or All X Blocks

Parse JSON as Local or Global Variable its Offline and Extract Data in Millisecond.

its Compatible with Get Sheet, Get Range, Get Columns, Apply Filter, SQL Query.

3 Likes

Upcoming Blocks

if you want any other block than tell us…

2 Likes

Amazing… you rocking regarding gsheet and all of its relevant functions…

All the best and thanks for supporting the community…

:clap:

2 Likes

I have no idea how GoogleMaps Marker Components works.

1 Like

How can I call A data into List view in order from bottom to top?

use query and in the end of query just add this “desc”

1 Like

I can’t send you a private message.