CRUD Method using Private Google Sheets

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

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

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

Added Row Functions:

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

More coming Tmr!!

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

Added New Column Functions:

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

More coming Tmr!!

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

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

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

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

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.