Fetch excel data directly to Google Sheet from Email

Here is the code // GLOBALS //Array of file extension which you would like to extract to Drive var fileTypesToExtract = [‘xlsx’]; //Name of the folder in google drive i which files will be put var folderName = ‘FOLDER NAME’; //Name of the label which will be applied after processing the mail message var labelName […]

Read More

Adsense API

Get Adsense data directly to your google sheet. Here is the app script for this.   function generateReport() { var ss = SpreadsheetApp.openById(“SHEET ID HERE”); var sheet = ss.getSheetByName(‘adsense1’); var adnetwork = “ADSENSE”; var startDate = getYesterdayDate(); var endDate = getYesterdayDate(); var adClientId = “ca-pub-ADSENSE PUB ID HERE”; var args = { ‘filter’: [‘AD_CLIENT_ID==’ + […]

Read More