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 for admin review.
  • The second function, creates an issue to be added to our project board.
• 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.