Works for me...
Have you set up your service account and downloaded your credentials.json file, then uploaded this to your assets ? You won't be able to change a google sheet unless you do this.
Sorry, I left out a bracket, add a closing bracket to the end, before the semi-colon
How do you do it using a service account
Also I wanna delete the row and add a new one not clear one just to clarify I have bad English I guess
Then use the original DELETE command for that.
You could also try using the UPDATE command by sending empty strings (no changes to script required, just additional blocks)
Read everything, including the links here:
The method is slightly different to the one provided....MIT have never updated it.
Yes, if all blank rows, below the non blank rows have been deleted from the spreadsheet, otherwise, that blank row is already there - pointless.
If you want to INSERT a blank row somewhere in the data, then I believe you will need GAS for that.
yes for this we need Apps Script and its not possible through Spreadsheet component
Does the sheet in question have a column containing a unique key, or are you relying on row IDs to link sheets?
What do you mean by GAS and i wanna add a blank row at the end of the spreadsheet everytime like
if the data in 2 row should be deleted it will delete the row and add a new row at the end of the sheet.
like do you mean in the sheet ? also just to confirm i want the data like do you see the row thats highlighted in the picture i want it in a way where i command the app to delete the specific value or id containing in the column A and it should delete the row and add a new blank row at the end of the sheet
Yes the normal spreadsheet component cant add it blank so we need an app script
but instead of Deleting and Adding the Row, you can make all the values of the row "blank" / "empty",
so the Row will be blank just like an blank row.
which will be completed in single process
from your screenshot, you already have just under 1000 blanks rows at the end of your rows that do have data. What is the point of adding another blank row below your data ?
I dont want any blank rows to be in the middle as it will corrupt the data for the app
and what is this ?
where is it from i think i have adden it by mistake i was adding and testing out the data sorry and thanks for reporting that
Every time you delete a row the number of rows decrease so i wanna keep regenerating it everytime its deleted
Why ?
Everytime you add a row (with data), if there are no spare rows below, google sheets will add a row for you.