-
Notifications
You must be signed in to change notification settings - Fork 2k
Expand file tree
/
Copy pathCode.gs
More file actions
61 lines (60 loc) · 2.38 KB
/
Code.gs
File metadata and controls
61 lines (60 loc) · 2.38 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
/**
* Copyright Google LLC
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
// [START apps_script_triggers_form]
/**
* Responds to a form when submitted.
* @param {event} e The Form submit event.
*/
function respondToFormSubmit(e) {
const addonTitle = "My Add-on Title";
const props = PropertiesService.getDocumentProperties();
const authInfo = ScriptApp.getAuthorizationInfo(ScriptApp.AuthMode.FULL);
// Check if the actions of the trigger requires authorization that has not
// been granted yet; if so, warn the user via email. This check is required
// when using triggers with add-ons to maintain functional triggers.
if (
authInfo.getAuthorizationStatus() === ScriptApp.AuthorizationStatus.REQUIRED
) {
// Re-authorization is required. In this case, the user needs to be alerted
// that they need to re-authorize; the normal trigger action is not
// conducted, since it requires authorization first. Send at most one
// "Authorization Required" email per day to avoid spamming users.
const lastAuthEmailDate = props.getProperty("lastAuthEmailDate");
const today = new Date().toDateString();
if (lastAuthEmailDate !== today) {
if (MailApp.getRemainingDailyQuota() > 0) {
const html = HtmlService.createTemplateFromFile("AuthorizationEmail");
html.url = authInfo.getAuthorizationUrl();
html.addonTitle = addonTitle;
const message = html.evaluate();
MailApp.sendEmail(
Session.getEffectiveUser().getEmail(),
"Authorization Required",
message.getContent(),
{
name: addonTitle,
htmlBody: message.getContent(),
},
);
}
props.setProperty("lastAuthEmailDate", today);
}
} else {
// Authorization has been granted, so continue to respond to the trigger.
// Main trigger logic here.
}
}
// [END apps_script_triggers_form]