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