CRUD Method using Private Google Sheets

Guides
1

Hey Everyone,
Many of you know the CRUD method by @TIMAI2 but I found a problem while using it THE GOOGLE SHEET HAS TO BE PUBLIC and this caused me to think how can i safeguard the data and make sure its not editable by the outside world(Strangers).

This is why I recreated CRUD method using google app script for Private/Public Google Sheets.

Here are the google app scripts:
(I wanted it to not be super long and as simply written as possible so I posted a google docs)

Click here to open

NOTE: I am Still Adding stuff and modifying some of these functions (Maybe in the future I will provide a video tutorial)

Test the data flow here using this aia (I will update this aia as I am adding new functions):
CRUD_PrivateSheets.aia (7.4 KB)
Test APK.apk (5.6 MB)

Here is the link to google sheets connected with this test apk

Thanks,
Sai Athulith Neela

1 Like
2

Remember to Create a New Deployment set it to Web App and the who has access to anyone and execute it as to me:

image
image754×629 5.07 KB

also dont forget to Authorize it with your account where the google sheet is located

3

Added Row Functions:

  1. Create Row
  2. Remove Row
  3. Write Row
  4. Get Row

More coming Tmr!!

4

@Ajdeveloper could you give me perms to edit this topic title and details I dont see an edit button

5

Added New Column Functions:

  1. Create Column
  2. Remove Column
  3. Write Column
  4. Get Column

More coming Tmr!!

6

Added Instructions for users to setup the scripts and blocks in the google docs

7

Hey Everyone,
This is a New CRUD method basically kind of similar to @TIMAI2 version of CRUDQ version 2 but I kind of made it more easier for people to understand it and expand the script if needed.

This is why I recreated CRUD method using google app script for Private/Public Google Sheets.

Here are the google app scripts:
(I wanted it to not be super long and as simply written as possible so I posted a google docs)

Click here to open

NOTE: I am Still Adding stuff and modifying some of these functions (Maybe in the future I will provide a video tutorial)

Test the data flow here using this aia (AIA link is provide in Google Docs link provided above):

Test APK.apk (5.6 MB)
(This APK hasnt Changed in a long time) compile the aia for the latest Functions

Here is the link to google sheets connected with this test apk

Thanks,
Sai Athulith Neela

9

@Akash_Kinha Can you make this the first post I am unable to edit it Please

10

Added Cell Functions and Find Functions!!

  1. Get Cell using cellid
  2. Find Cell by checking the whole sheet given result cellid
  3. Find value in a particular row given result cellid
  4. Find value in a particular column given result cellid

Will add more functions Tmr

11

Added Extra Features

  1. Find Row number of a value in a Column
  2. Create a New Sheet
  3. Query

I am done creating all kinds of different function that came on my thought if you guys have any idea or something that you need a script for in google sheets post your question here I will try to help when i can.

1 Like