How to create a Slack Bot from Google Sheets
Kanza Akhwand A lot of my reporting is repetitive mindless work. The fun part of data for me is the analysis but if I spend time updating my sheets and sending reports…
Google App Script
How to Bulk add events to calendar | Kanza Akhwand
The following is to push Events from a google sheet to google calendar script: function addEvents() {var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var lr = ss.getLastRow();var cal = CalendarApp.getCalendarById(“c_3qjs8u1i5cu0re1coi8ageo51s@group.calendar.google.com”); var data = ss.getRange(“A2:E”…
How to Pull Calendar Data to Google Sheets | Kanza Akhwand
Want to add your Google Calendar Data to Google Sheets? function getEvents() {var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var cal = CalendarApp.getCalendarById(“kanza.akhwand@yayvo.com”); var events = cal.getEvents(new Date(“07/01/2020 12:00 AM”), new Date(“07/31/2020 11:59 PM”));…