[FREE/PAID API] Advance Google Sheet Extension with Power of 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 its 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 Properties

Create New Sheet

Input

  • Sheet Name : String

Output

  • Sheet Name : String (New Created Sheet Name)

1

Get All Sheet List

Output

  • Values : ListView
    2

Create Columns / Titles

3

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

Get Row by Row Number

Output

  • Values : ListView
    5

Update Row by Row Number

6

Delete Row by Row Number

7

Get Cell by Row or Column

8

Update Cell by Row or Column

9

Get Sheet All Data

10

Get Multiple Columns

Input

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

Output

  • Data : String (Filter by Sheet Functions)
    11

Get Range

Input

  • From Cell : A1
  • To Cell : D20

Output

  • Data : String (Filter by Sheet Functions)
    12

Update Range

Input

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

Advance SQL Blocks

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 (Filter by Sheet Functions)
    14

SQL Query

Input

Output

  • Data : String (Filter by Sheet Functions)
    15

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

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

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

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

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

Download Extension

GoogleSheet.aix (35.7 KB)

or
Download Admin App

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
8 Likes

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

1 Like