Untitled
unknown
plain_text
4 years ago
2.3 kB
5
Indexable
function Getwhiteboard(companyname,firstname) { if(companyname && firstname) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getActiveCell(); var currentCell = ss.getSelection(); var currentCellValue = cell.getValue(); var currentRow = sheet.getActiveRange().getRowIndex(); var currentColumn = sheet.getActiveRange().getColumnIndex(); var url = 'https://api.stamplate.com/v1/aCJlBpb4rcRdZTAhO3fNKgLO8V33/generate/ZWYzl6Fbp84KnDUwVvkj'; var auth = 'Bearer 7AHA69B-WW2MVWJ-HB16N16-6BQCFPF'; var data = { "params": { "companyname" : companyname, "firstname" : firstname, }, "contentType": "jpg", "quality": 100, "scale": 1 }; var options = { 'method' : 'post', "headers" : { 'Authorization' : auth, 'Content-Type': 'application/json' }, 'contentType': 'application/json', 'payload' : JSON.stringify(data) }; var response = UrlFetchApp.fetch(url, options); var json = response.getContentText(); var data = JSON.parse(json); return data['data'].image; } else { return 'Complete all cells on the left to generate image.' } } function Getcoffee(firstname) { if(firstname) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getActiveCell(); var currentCell = ss.getSelection(); var currentCellValue = cell.getValue(); var currentRow = sheet.getActiveRange().getRowIndex(); var currentColumn = sheet.getActiveRange().getColumnIndex(); var url = 'https://api.stamplate.com/v1/aCJlBpb4rcRdZTAhO3fNKgLO8V33/generate/fZqwV1Qb3RxhGBKJ2VVP'; var auth = 'Bearer 7AHA69B-WW2MVWJ-HB16N16-6BQCFPF'; var data = { "params": { "leadfirstname" : firstname, }, "contentType": "jpg", "quality": 100, "scale": 1 }; var options = { 'method' : 'post', "headers" : { 'Authorization' : auth, 'Content-Type': 'application/json' }, 'contentType': 'application/json', 'payload' : JSON.stringify(data) }; var response = UrlFetchApp.fetch(url, options); var json = response.getContentText(); var data = JSON.parse(json); return data['data'].image; } else { return 'Complete all cells on the left to generate image.' } }
Editor is loading...