Automations for Wins page using Google Apps Script

Automations for Wins page using Google Apps Script

• As soon as a user submits the share your wins form, the On form submit triggers two functions:
  • The first function calls the Google App Script, reformates a copy of the users' response, and sends it to the review tab in the spreadsheet.
  • The second function creates an issue to be added to our project board.
• The user's response will require an admin review to be considered for the Wins page.
• Next, a time-based trigger which triggers monthly, in the same Google Apps Script, creates a Pull Request which if merged adds the new row (in the spreadsheet with a True value in the Display column) to the Wins page on the website.