-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathtrigger.gs
More file actions
58 lines (50 loc) · 1.89 KB
/
trigger.gs
File metadata and controls
58 lines (50 loc) · 1.89 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
// BEFORE USING:
// make sure you have the `appscript.json` file set up
// that file contains all the permissions that set up the oauth frontend
// see: https://developers.google.com/identity/protocols/oauth2/scopes
function callFormsAPI() {
// the form you want to monitor. Get ID from URL
const formId = '<GOOGLE FORM ID>';
// this will create new triggers each time you run
// make sure to delete old triggers manually after each run
ScriptApp.newTrigger('getVanId').forForm(formId).onFormSubmit().create();
}
function getVanId(e) {
const formResponse = e.response.getItemResponses();
// get the responses to each field
// stick it into an object to make it easier to send across to backend
var formdata = {
fname: formResponse[0].getResponse(),
lname: formResponse[1].getResponse(),
hno: formResponse[2].getResponse(),
street: formResponse[3].getResponse(),
zip: formResponse[4].getResponse(),
phone: formResponse[5].getResponse(),
van_key: '<VAN API KEY>',
van_sq: '<VAN SURVEY QUESTION>',
van_sr: '<VAN SURVEY RESPONSE>',
van_ct: '<VAN CONTACT TYPE ID>',
van_it: '<VAN INPUT TYPE ID>'
};
// standard fetch to backend cloudwatch function
// will fail without `Authorization` header
const response = UrlFetchApp.fetch('<HANDLER URL>', {
method: 'post',
muteHttpExceptions: true,
contentType: 'application/json',
payload: JSON.stringify(formdata),
headers: {
Authorization: `Bearer ${ScriptApp.getIdentityToken()}`
}
});
// put stuff into spreadsheet by id
const vanId = response.getContentText();
const sheetId = '<GOOGLE SHEET ID>';
const sheetName = '<GOOGLE SHEET NAME>';
var activeSheet = SpreadsheetApp.openById(sheetId);
var sheet = activeSheet.getSheetByName(sheetName);
var cell = '<VAN ID COLUMN>' + sheet.getDataRange().getNumRows();
sheet.getRange(cell).setValue(vanId);
// write to couldwatch (or whatever google calls it?) logs
// Logger.log(vanId);
}