'Automatically post the new form submissions stored in the google sheet (Integrated) to slack
I have a custom form which is automatically storing the new submissions to a google sheet. Since the form is not a google form, OnFormSubmit event trigger is not working. Is there any other way to make the event trigger as soon as a new row is added to the google sheet, which will be posting the message on slack with the details.
This is the code I have right now for the trigger and it's not working because the form is not a google form.
ScriptApp.newTrigger("submitValuesToSlack")
.forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
.onFormSubmit()
.create();
}
Since it is using AppsScript, onEdit is also not working on it to trigger the event. Any help or suggestions are appreciated, and FYI I cannot move to google forms. Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
