Automate Google Sheets: An Introduction to Google Apps Script

1. Automate Google Sheets: An Introduction to Google Apps Script FPPT.com

2. A powerful tool

3. Getting Started with Google Apps Script There are two main types of scripts you can use with Google Apps: standalone and bound scripts.

4. 1. Standalone scripts Standalone scripts are not attached to any particular app in your Google account. Instead, think of them as macros that perform system-wide functions.

5. A standalone script could search your Google Drive for all items with the name ‘untitled’ (the default name Google gives to files when the name isn’t specified), for example, as a handy way to keep your Google Drive clutter-free. You'll see standalone scripts alongside your other Google Drive files, and each file contains JavaScript for your particular function.

6. 2. Bound scripts Bound scripts extend the functionality of a certain file in one of your Google apps. They perform specific actions directly to that particular file. For example, you could create a script bound to a specific Google Sheet that checks for and removes duplicate rows.

7. example: Removing Duplicate Rows in a Spreadsheet Goal This example how to avoid duplicates when you want to automate the process of copying data in G Suite and specifically how to remove duplicate rows in spreadsheet data. Google Apps Script lets you copy email attachments from Gmail to a collection in Google Docs, sync spreadsheet data with a list page in Google Sites or with Google Calendar or with your contact list. The example shown below can be used to avoid duplicates in each of those cases.

8. Time to Complete Approximately 5 minutes. Prerequisites Before beginning this tutorial, you should feel comfortable using the Script Editor and have experience using the most basic Spreadsheet functions.

9. Running a simple example Open a new spreadsheet in Google Docs or use an existing spreadsheet containing duplicates. if the spreadsheet is empty, add a few rows of data (for example, a list of contacts, parts inventory, etc.) and duplicate some of them.

12. Choose the menu Tools > Script Editor.

14. Copy and paste the following script:

19. Before After running the function

20. If we change the age of زينب عباس to 20 After running the function