[Google Apps Script] Manipulate with your Google Spreadsheet

google spreadsheet crud article

If you are looking for the script to create, insert, append, delete (CRUD) the google sheets with the google app script. This article will show you how to manipulate the google app script with your google spreadsheet.

1. Initiate your Script

Let’s start your first google App Script, Click here.

Initiate the spreadsheet & tab.

2. Read

Read the specific column.

Read the last row or column.

3. Write

Insert to first rows or first columns.

Use the getLastRow() and getLastColumn() to get last value in spreadsheet and insert it 5 more row or column.

Use the getMaxRows() and getMaxColumns() to get the max row or column in spreadsheet.

4. Update

Update the value of the data.

5. Delete

Delete the value of the data.

6. Other

Format the text in google spreadsheet

Set Sheet Tab color.

Debug for the google app script.

7. Try it with Simple example

It is a function for hash the data in the google spreadsheet.

You can use the function simply in the google spreadsheet.


Thanks for your reading. I hope this article will help you better understand google app script.

References:

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。