Google-Apps-Script

Collection of Google Apps Script Automation scripts written and compiled by Aryan Irani.

AddGoogleMeet.js - Create Calendar Events with a Google Meet link using Google Apps Script. The Calendar Events contain data from a Google Sheet.

              Blog Link : https://bit.ly/3bw8KsI
              Video Tutorial : https://www.youtube.com/watch?v=_pY9eK1V_JA

ChangeCellColour.js - Changes colour of cells in Google Sheets using Google Apps Script.If a change is made in the Google Sheet, that meets the conditions mentioned in the script, the colour of the cell will be changed.

                  Blog Link : https://bit.ly/3jSV5Rk
                  Video Tutorial : will be out soon :)              

CreateBulkClassroom.js - Bulk create Google Classrooms, with custom data present in Google Sheets using Google Apps Script. After the classrooms are created, the class codes are pasted in the Google Sheet for further use.

                     Blog Link : https://bit.ly/3nIkUVk
                     Video tutorial : https://www.youtube.com/watch?v=YZQdkrJSVgQ&t=2s
                     

Create_Events.js - Create calendar events with data from Google Sheets using Google Apps Script. Bulk create calendar events wtih custom details for each event.

               Blog Link : https://bit.ly/3q0VwN4
               Video Tutorial : https://www.youtube.com/watch?v=DKYM8CYwSUE
               

ExtractCellNotes.js - Extract cell notes from Google Sheets using Google Apps Script. Extract cell notes into the adjacent column using Google Apps Script.

                  Blog Link : https://bit.ly/3bqgWuy
                  Video Tutorial : https://www.youtube.com/watch?v=z0k0nNieL2o

FiltersGoogleSheets.js - Create filters in Google Sheets using Google Apps Script. Instead of manually creating filters, automate the process using Google Apps Script, by just specifying the filter criteria.

                     Blog Link : https://bit.ly/2ZB7gem
                     Video Tutorial : https://www.youtube.com/watch?v=0dKQy0yakvI&t=139s
                 

GetEvents_CalendarAPI.js - Get calendar events with all the details from your Google Calendar into your Google Sheet using Google Apps Script.

                       Blog Link : https://bit.ly/3pRoUW8
                       Video tutorial : https://www.youtube.com/watch?v=YDhln3ukH7Y&t=2s
                       

LimitResponses.js - Limit responses in Google Forms, using Google Apps Script.

                Blog Link : https://bit.ly/317vQ78
                Video Tutorial :https://www.youtube.com/watch?v=Uee_7cZW0p0&t=2s