What are some examples of Google Apps Script?

What are some examples of Google Apps Script?

Google Apps Script is a powerful tool for automating tasks in Google Workspace. Here are a few examples:

1. Automating email responses in Gmail.
2. Creating custom functions in Google Sheets.
3. Generating reports from Google Forms data.
4. Sending reminders via Google Calendar.

Can you show me a simple script for sending emails?

Sure! Here's a simple script to send an email using Google Apps Script:

function sendEmail() {
  MailApp.sendEmail('[email protected]', 'Subject', 'Email body text');
}

Just replace the recipient, subject, and body with your own content.

How do I set a trigger for this script?

To set a trigger, go to the Apps Script editor, click on the clock icon (Triggers), and then add a new trigger. You can choose to run the script on a schedule or based on an event.

Can I use Google Apps Script with Google Sheets?

Absolutely! You can create custom functions, automate data entry, and manipulate data in Google Sheets using Google Apps Script.