| /** | |
| * Fetch transcripts using Basic Authentication | |
| */ | |
| function fetchTranscripts() { | |
| var yesterday = new Date(); | |
| yesterday.setDate(yesterday.getDate() - 1); | |
| var fromDateTime = Utilities.formatDate(yesterday, 'GMT', "yyyy-MM-dd'T'00:00:00'Z'"); | |
| var toDateTime = Utilities.formatDate(yesterday, 'GMT', "yyyy-MM-dd'T'23:59:59'Z'"); | |
| var url = 'https://api.gong.io/v2/calls/transcript'; |
| function combineSheets() { | |
| var sheetNames = [ | |
| "data", "1-data" | |
| ]; | |
| var sApp = SpreadsheetApp.getActiveSpreadsheet(); | |
| sheetNames.forEach(function(sheetName) { | |
| var combinedData = []; | |
| var sheet = sApp.getSheetByName(sheetName); | |
| if (sheet) { |
| /// | |
| // Clear Spreadsheet of all data | |
| /// | |
| function clearSheet(sheet) { | |
| var lastRow = sheet.getLastRow(); | |
| var lastColumn = sheet.getLastColumn(); | |
| if (lastRow > 1) { | |
| sheet.getRange(2, 1, lastRow - 1, lastColumn).clearContent(); | |
| } |
| ////////////////////////////////////////////// | |
| // Base Data Fetches for the Google Sheet. // | |
| //////////////////////////////////////////// | |
| /// | |
| // Clear Spreadsheet of all data | |
| /// | |
| function clearSheet(sheet) { | |
| var lastRow = sheet.getLastRow(); | |
| var lastColumn = sheet.getLastColumn(); |
| /** | |
| * Fetch transcripts using Basic Authentication | |
| */ | |
| function fetchTranscripts() { | |
| var yesterday = new Date(); | |
| yesterday.setDate(yesterday.getDate() - 5); | |
| var fromDateTime = Utilities.formatDate(yesterday, 'GMT', "yyyy-MM-dd'T'00:00:00'Z'"); | |
| var toDateTime = Utilities.formatDate(yesterday, 'GMT', "yyyy-MM-dd'T'23:59:59'Z'"); | |
| var url = 'https://api.gong.io/v2/calls/transcript'; |
| // https://developers.hubspot.com/docs/api/conversations/conversations | |
| function stripHtml(htmlString) { | |
| if(htmlString) { | |
| // This regular expression finds HTML tags and removes them | |
| return htmlString.replace(/<[^>]*>/g, ''); | |
| } else { | |
| return; | |
| } | |
| } |
| function clearSheet(sheetName) { | |
| var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName); | |
| sheet.clear(); // Clears the entire sheet | |
| } | |
| function stripHtml(htmlString) { | |
| if(htmlString) { | |
| // This regular expression finds HTML tags and removes them | |
| return htmlString.replace(/<[^>]*>/g, ''); | |
| } else { |
| function exportAllSheetsToTxtExceptSkipped() { | |
| const ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| const sheets = ss.getSheets(); // Get all sheets in the spreadsheet | |
| sheets.forEach(sheet => { | |
| const sheetName = sheet.getName(); | |
| // Skip sheets with specific keywords in their names | |
| const skipKeywords = ["Instructions", "Triggers", "Raw"]; | |
| const shouldSkip = skipKeywords.some(keyword => sheetName.includes(keyword)); |
| function processTasks() { | |
| const ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| const historySheet = ss.getSheetByName("History"); | |
| const slackSheet = ss.getSheetByName("Slack"); | |
| const sheet = ss.getSheetByName("Jira Work Today Tickets"); | |
| const data = sheet.getDataRange().getValues(); | |
| const headers = data.shift(); | |
| const assigneeIndex = headers.indexOf('Assignee'); | |
| const updatedIndex = headers.indexOf('Updated'); |
Book Recommendation! “ Just Work: Get Sh*t Done, Fast & Fair” by Kim Scott
I just finished "Just Work" by Kim Scott, that hit the shelves mid last month. I must say this book is one of the best book I have read that provides some great insight into how to put feedback into practise. Seeping with relatable stories and insights I recommend a read for anyone is a team or management position. Heres a sneak peak to what the book breaks down to see if it interest you!
