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, an On form submit trigger in the Google Apps Script adds the information from the response tab to the review tab in a spreadsheet in a specified format.
• At the same time another On form summit trigger 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.