Google Sheet API | Part 3 | Delete Records From Spreadsheet | Remove Rows And Columns

Please avoid or flag spams/hateful comments. And do not spam. Enjoy :)
------------------------------------------------
Google Sheet API | Part 1 | Connect And Display Sheet Data Using PHP | Latest:-
• Google Sheet API | Par...
Google Update New Configuration :-
• Google API PHP Update ...
Download VENDOR Folder (Only for PHP version 7.2+):
unpossiblepog....
DELETING ROW IMP Link #1:-
developers.goo...
DELETING ROW IMP Link #2:-
developers.goo...
Direct Code Download Link:-
unpossiblepog.b...
Subscribe my Channel:-
www.youtube.com...
Facebook Page:-
/ unpossiblens
Twitter Account:-
/ unpossiblepog
Blog :-
unpossiblepog....
------------------------------------------------
Hey guys.
This is the video of Deleting Rows in Google Sheet using API.
First, if you don’t know how to connect google sheet with PHP, then watch both videos.
Links of those tutorials are given in description.
Now, as you can see, the current code I have is to display data from google sheet on browser.
Also, I provided two links which are important for deleting rows.
First link is to understand the array structure for deleting.
Second link is a PHP code that we have to implement.
Now In a code, make sure that the scope is SPREADSHEETS and not SPREADSHEET_READONLY
Here, comment the code which fetches the data.
Copy the code from top up to response variable.
Paste it just below spreadsheetID variable.
Now, we actually need one GOOGLE SERVICE SHEETS REQUEST. So remove the second but be careful not to mess the structure.
We also don’t need FIELDS sub-array.
Open the array structure link.
So according to this, the first parent should be “requests” which is already given in code.
So we don’t need to change it.
The second parent is “DELETE DIMENSION”. Paste it.
Third is “RANGE”.
Now RNAGE has 4 key value pairs, so paste them one by one.
Now, the first key which is sheetID is not same as spreadsheetID.
But rather it is sub-sheet.
And it is denoted as GID which you can find in URL.
In my case, the GID is 0.
Now we are deleting rows, so paste ROWS.
Now in spreadsheet, there are numbers which are actual index that we are going to use.
Make sure not to use any quotes, just type numbers.
Also a side note is, startIndex 8 means it does not delete the 8th row, deleting will start
from 9th row up to 10th row.
So if we refresh and check sheet, you see that data from row 9 and 10 are deleted and the
rest were moved upward by 2 positions.
If you want to delete only 1 row that is 9th row, then type 9 at END-INDEX and type 8 at
START-INDEX.
Now the 9th row is deleted.
You can also copy the whole code from blog link which is given in the description.
Don’t forget to like, share and subscribe.
Thanks for watching.

[@tuannguyenduy41]

Thks bro, You save my life

[@negroCardoso]

Hello there! how to find a row by some value and replace it with another? it's possible?

[@GameplayHereL]

Hello bro i follow your first part but i m getting error.. so please tell me how to fix this..

[@UnpossiblePOG]

Google made some updates whole creating app. Watch video that I provided you below kzbin.info/www/bejne/a3Sym6F7mJmXb6c

[@mddanishyusuf]

Nice tutorial. But how to get sheetId? gid with API.

[@mddanishyusuf]

We only know table name. that is string and sheetid require integer.

[@UnpossiblePOG]

@@mddanishyusuf I have to do research, until then, search on google "get google sheet gid php" :)

[@mddanishyusuf]

@@UnpossiblePOG Do you think I have not done that :)