1 / 20

Automate Google Sheets: An Introduction to Google Apps Script

An introduction to using Google Apps Script to automate tasks in Google Sheets, with examples of standalone and bound scripts. Learn how to avoid duplicates in spreadsheet data and enhance your workflow.

ceileen
Download Presentation

Automate Google Sheets: An Introduction to Google Apps Script

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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.

  10. Choose the menu Tools > Script Editor.

  11. Copy and paste the following script:

  12. Before After running the function

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

More Related