售 价:¥
温馨提示:数字商品不支持退换货,不提供源文件,不支持导出打印
为你推荐
Learning Google Apps Script
Table of Contents
Learning Google Apps Script
Credits
About the Author
About the Reviewer
www.PacktPub.com
eBooks, discount offers, and more
Why subscribe?
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Introducing Google Apps Scripts
Google Applications
Google Apps Script
Visual Basic for Applications
The advantages of GAS over VBA
The limitations of GAS
Google Drive
Gmail
Google Calendar
Google Docs
Google Sheets
Google Apps services
Creating Google Sheets in Drive and sharing them with your friends and the public
Script projects
Creating standalone script projects
Creating new projects in Sheets
Creating a custom formula in Sheets
Google Forms
Creating Forms within Google Sheet
Some research
Summary
2. Creating Basic Elements
Creating a clickable button
Showing toast when a button is clicked
Creating a custom menu
Creating a sidebar
Creating an Add-ons menu
Creating a modal dialog
Creating a modeless dialog
Debugging your script
Summary
3. Parsing and Sending E-mails
Creating Gmail Contacts by script
Accessing Sheet, cell, range, and offset
Reading and writing the Sheet data
Building a Gmail Contact search application
Building the Gmail parser application
Properties service
Downloading Gmail attachments to Drive
Sending e-mails using the MailApp service
Sending an e-mail notification on Form submission
Creating triggers manually
Creating and deleting triggers by script
Forwarding e-mails if the specific keyword is found in the message body
Sending e-mail with attachments
Embedding inline images in an e-mail message
Building an e-mail merger application
Summary
4. Creating Interactive Forms
Creating Forms using script
Publishing the script as a web application
HtmlService
Creating a Form using HtmlService
Submitting form using Google script API method
Creating forms using add-ons CSS and jQuery libraries
Creating an e-voting application
Creating a ticket reservation application
Summary
5. Creating Google Calendar and Drive Applications
The CalendarApp class
Creating Calendar events from a simple description
Creating simple Calendar events
Creating events with options
Creating events from Sheets data
Creating events from an external CSV file's contents
Enabling advanced Google services
Listing all the Calendars
Listing Calendar events in Sheets
Syncing events from one Calendar to another Calendar
The DriveApp class
Creating customized PDF files
Creating a Drive file routing application
Creating a Drive file search application
Summary
6. Creating Feed Reader and Translator Applications
The UrlFetchApp class
Creating a Google search application
Creating a stock quote ticker application
Logging Bitcoin quotes
RSS and Atom feeds
Skeleton of a RSS feed document
Creating an RSS reader application
Skeleton of an Atom feed document
Creating an Atom feed reader application
Using optional parameters with the UrlFetchApp class
The LanguageApp class
Creating the language translator application
Creating a document reviewing and instant inline commenting application
Summary
7. Creating Interactive Webpages
Creating a web app to render Sheet data as HTML
Creating a web app to return JSON
Converting Sheet data as a PDF file
Sending an HTTP/HTTPS request with query string
Creating RSS feed using ContentService
Creating a file upload application
Creating an employee timesheet application
Summary
8. Building a Workflow Application
Order processing workflow – steps explained
Configuring Google Sheets
Creating the Order form
Enhancing the Order form
Creating the dispatch form
Dispatching the articles
Enabling the user to acknowledge the article delivery
Summary
9. More Tips and Tricks and Creating an Add-on
Overcoming the "script exceeded maximum execution time" error
Configuring your script project to use external libraries
Using JSDoc annotations
Using the OAuth open source library
Creating, testing, and publishing add-ons
Installing add-ons from Chrome Web Store
Creating custom add-ons
Testing your add-on
Creating an add-on that uses an OAuth2 external library
Other useful links
Summary
Index
买过这本书的人还买过
读了这本书的人还在读
同类图书排行榜