TechPrufer
Get started
Google
Google logoGoogle · Feature trail

Google Sheets API and Automation

1 post · Feb 2015 – Mar 2016

What this trail covers

This feature thread tracks the evolution of Google Sheets' capabilities for developers, focusing on programmatic control and automation. Early efforts likely involved the initial release of Google Sheets and its basic API. Subsequent developments have introduced more advanced functionalities, such as controlling protected ranges and sheets, enabling finer-grained access management and automation of spreadsheet workflows. This evolution aims to empower developers to build more sophisticated applications. This post details changes to the Mail Service in Apps Script, impacting how developers interact with email functionality.

All Google trails
  1. Change to Mail Service in Apps Script- Google Developers BlogThis post announces a change to the Mail Service in Google Apps Script, specifically regarding the handling of email addresses. Previously, the Mail Service would automatically append the script's owner's email address to emails sent via `MailApp.sendEmail()`. This behavior has been changed to no longer automatically append the owner's email address. The post also clarifies that this change does not affect emails sent using `GmailApp.sendEmail()`, which continues to use the sender's email address. Developers are advised to update their scripts if they relied on the previous automatic appending behavior.
  2. Control protected ranges and sheets in Google Sheets with Apps Script- Google Developers BlogThis post introduces the ability for developers to control protected ranges and sheets within Google Sheets using Apps Script. This significantly enhances programmatic control over spreadsheet security and access, enabling more sophisticated automation and data management workflows.