arijitMondal’s gists

arijitMondal / Code.gs

Last active April 22, 2022 15:03

Google Apps Script code to fetch pagespeed data and save to google sheet

	var pageSpeedApiKey = 'PAGESPEED_API_KEY'; // use your api key here
	var urlToMonitor = 'YOUR_WEBSITE'; //replace with website you want to monitor
	var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
	var sheet = spreadsheet.getSheetByName('results');

	function createHeaders() {
	//Freezes the first row
	sheet.setFrozenRows(1);
	// Set the values we want for headers
	var values = [["Timestamp", "Device","Performance Score","LAB FCP", "LAB LCP", "LAB CLS", "LAB Interactive", "LAB Total Blocking Time", "LAB Speed Index"]];

arijitMondal / createHeaders.gs

Created August 26, 2020 03:47

	function createHeaders() {
	//Freezes the first row
	sheet.setFrozenRows(1);
	// Set the values we want for headers
	var values = [["Timestamp", "Device","Performance Score","LAB FCP", "LAB LCP", "LAB CLS", "LAB Interactive", "LAB Total Blocking Time", "LAB Speed Index"]];
	// Set the range of cells
	var range = sheet.getRange(1, 1, 1, 9);
	//Call the setValues method on range and pass in our values
	range.setValues(values);
	}

arijitMondal / spreadsheet.gs

Created August 26, 2020 03:49

	var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
	var sheet = spreadsheet.getSheetByName('results');

arijitMondal / monitor.gs

Created August 26, 2020 03:50

	function monitor() {
	var desktopInfo = getPageSpeedInfo('desktop');
	var mobileInfo = getPageSpeedInfo('mobile');
	instertDataToSheet(desktopInfo, 'desktop');
	instertDataToSheet(mobileInfo, 'mobile');
	}

arijitMondal / getPageSpeedInfo.gs

Created August 26, 2020 03:51

	function getPageSpeedInfo(strategy) {
	var pageSpeedUrl = 'https://www.googleapis.com/pagespeedonline/v5/runPagespeed?url=' + urlToMonitor + '&key=' + pageSpeedApiKey + '&strategy=' + strategy;
	var response = UrlFetchApp.fetch(pageSpeedUrl);
	var json = response.getContentText();
	return JSON.parse(json);
	}

arijitMondal / instertDataToSheet.gs

Created August 26, 2020 03:53

	function instertDataToSheet(deviceInfo, deviceType){
	sheet.appendRow([
	// GMT+8:00 is for singapore
	Utilities.formatDate(new Date(), "GMT+8:00", "yyyy-MM-dd'T'HH:mm:ss"),
	deviceType,
	deviceInfo.lighthouseResult.categories.performance.score * 100,
	deviceInfo.lighthouseResult.audits['first-contentful-paint'].numericValue,
	deviceInfo.lighthouseResult.audits['largest-contentful-paint'].numericValue,
	deviceInfo.lighthouseResult.audits['cumulative-layout-shift'].numericValue,
	deviceInfo.lighthouseResult.audits['interactive'].numericValue,

arijitMondal / duplicate_package_next.config.js

Last active September 14, 2020 16:46

	const DuplicatePackageCheckerPlugin = require('duplicate-package-checker-webpack-plugin')

	module.exports = {
	webpack: (config, { buildId, dev, isServer, defaultLoaders, webpack }) => {
	config.plugins.push(new DuplicatePackageCheckerPlugin())
	return config
	},
	}

arijitMondal / handleScrollToTop.js

Created September 13, 2020 16:58

	handleScrollToTop() {
	import('react-scroll').then(scroll => {
	scroll.animateScroll.scrollToTop({
	})
	})
	}

arijitMondal / duplicate_package_resolve_alias_next.config.js

Last active September 14, 2020 16:49

	const DuplicatePackageCheckerPlugin = require('duplicate-package-checker-webpack-plugin')

	module.exports = {
	webpack: (config, { buildId, dev, isServer, defaultLoaders, webpack }) => {
	config.plugins.push(new DuplicatePackageCheckerPlugin())
	config.resolve.alias['fast-deep-equal'] = path.resolve(
	__dirname,
	'node_modules',
	'fast-deep-equal'
	)

arijitMondal / polyfill_detection.js

Last active March 17, 2021 16:27

	if (
	typeof window !== 'undefined' &&
	'IntersectionObserver' in window &&
	'IntersectionObserverEntry' in window &&
	'intersectionRatio' in window.IntersectionObserverEntry.prototype
	) {
	let observer = new IntersectionObserver()
	//rest of the code
	} else {
	import('intersection-observer').then(() => {

Arijit arijitMondal