Alan Wells
  • Member for 7 years, 8 months
  • Last seen more than a month ago
Can I trigger a Google Apps Script with a HTTP POST?
Accepted answer
9 votes

Yes, you can trigger an Apps Script function with an HTTPS POST request. You'll need to add a doPost() function to a script file. The doPost() function can also receive data from the POST request. ...

View answer
Register your Apps Script application and retrieve the client ID and secret for oAuth dance
Accepted answer
3 votes

These are instructions for getting the client ID and secret for oAuth. This explains the process of navigating the Cloud Platform and getting your Apps Script project information including the client ...

View answer
Timestamp based on cell value
3 votes

This line: if( nextCell.getValue() !== '' ) //is empty? Should be: if (nextCell.getValue() === 'Complete') { nextCell.setValue(new Date()).setNumberFormat('dd-MM-yyyy HH:mm:ss'); }

View answer
Add my scripts or add-ons to new Google doc
Accepted answer
3 votes

There are two basic categories of Apps Script files - Bound to the document (Sheet, Doc, Form) Stand Alone Bound files do not show up in your Google Drive. Stand Alone Apps Scripts files do show ...

View answer
Google Sheets Script Editor action not applying to all sheets
3 votes

Get the sheet that was edited. Change code to: var sheet, ss; ss = SpreadsheetApp.getActiveSpreadsheet(); sheet = ss.getActiveSheet();//Get the active sheet Now the sheet variable is the active ...

View answer
Sending emails onSubmit using Google Apps Script Web Forms
Accepted answer
3 votes

You need to use the google.script.run.myServerFunctionName() client side API. You will need to use that anyway, in order to send the form data, unless you are using a HTTPS GET or POST request to ...

View answer
My Add-On was approved by Google, but it is available only to members of my employer's domain
1 votes

Publish a Google Add-on to the G Suite Marketplace Basic Concepts: You must use the G Suite Marketplace SDK in order to get to the “Publish” section for publishing an add-on, and you must first open ...

View answer
Please tell me about how to implement privacy policy site for my Google Apps Script project (mail from Google Apps Developers)
1 votes

The issue is whether your users will see a warning message or not when they authorize the permissions. You can publish and use an Apps Script project whether it's approved or verified by Google or ...

View answer
Google apps script to check availability
Accepted answer
0 votes

The getEvents(startTime, endTime) method of the Calendar Class can be used. That method returns an array of events. First you need to get a calendar and then chain the getEvents() method to the ...

View answer