bpwebs’s gists

bpwebs / Code.gs

Created November 13, 2023 00:52

Combine CSV files with Google Apps Script

	function combineCsv() {
	const folder = DriveApp.getFolderById("1MBaI_rGJ6t_loANMAvGpDbr2MeHZwxnn");
	const files = folder.getFilesByType(MimeType.CSV);
	let combinedData = [];

	while(files.hasNext()){
	let file = files.next();
	let csvData = Utilities.parseCsv(file.getBlob().getDataAsString());
	combinedData = combinedData.concat(csvData);
	}

bpwebs / Code.gs

Created November 7, 2023 19:17

Access the CSV files in Google Drive with Google Apps Script

	function combineCsv() {
	const folder = DriveApp.getFolderById("1mSJUg80NRhtorSBBOsJylbDYTDDmpHWY");
	const files = folder.getFilesByType(MimeType.CSV);

	//Use the files variable
	}

bpwebs / CSS.html

Last active November 5, 2024 22:08

Multi-Page Google Apps Script Web App

	<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha3/dist/css/bootstrap.min.css" rel="stylesheet"
	integrity="sha384-KK94CHFLLe+nY2dmCWGMq91rCGa5gtU4mk92HdvYe+M/SXH301p5ILy+dN9+nJOZ" crossorigin="anonymous">

bpwebs / CSS.html

Created June 29, 2023 15:10

Create Your Own Personal Finance Tracker App with Google Sheets

	<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha3/dist/css/bootstrap.min.css" rel="stylesheet"
	integrity="sha384-KK94CHFLLe+nY2dmCWGMq91rCGa5gtU4mk92HdvYe+M/SXH301p5ILy+dN9+nJOZ" crossorigin="anonymous">

	<style>
	//Your CSS goes here
	</style>

bpwebs / Code.gs

Created May 29, 2023 17:33

How to Calculate the Distance Between Two Addresses in Google Sheets

	function CALCULATE_DRIVING_DISTANCE(origin, destination) {
	var directions = Maps.newDirectionFinder()
	.setOrigin(origin)
	.setDestination(destination)
	.setMode(Maps.DirectionFinder.Mode.DRIVING)
	.getDirections();

	var distance = directions.routes[0].legs[0].distance.value;

	distance /= 1000; // Convert meters to kilometers

bpwebs / Code.gs

Created May 20, 2023 19:46

Visualize Google Sheets Data in HTML Charts - Create a Dashboard

	/**
	* Visualize Google Sheets Data in HTML Charts
	* By: bpwebs.com
	* Post URL: https://www.bpwebs.com/visualize-google-sheets-data-in-html-charts
	*/

	function doGet() {
	let template = HtmlService.createTemplateFromFile('Index');
	let html = template.evaluate().setTitle('Data Visualization Web App');

bpwebs / Code.gs

Last active May 22, 2023 14:23

Visualize Google Sheets Data in HTML Charts

	function doGet() {
	return HtmlService.createHtmlOutputFromFile("Index");
	}

	function getChartData(){
	const ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data");
	const data = ss.getDataRange().getValues();

	return data;
	}

bpwebs / #Google Sheets copy data from one sheet to another

Last active March 30, 2023 18:20

Google Sheets - Copy data from one sheet to another

Google Sheets copy data from one sheet to another

bpwebs / #Generate Static Google Maps in Google Sheets - Add paths

Created March 9, 2023 18:20

#Generate Static Google Maps in Google Sheets - Add paths

Generate Static Google Maps in Google Sheets - Add paths

bpwebs / #Generate Static Google Maps in Google Sheets - Add place markers

Created March 9, 2023 18:16

#Generate Static Google Maps in Google Sheets - Add distinct colors and labels to markers

Generate Static Google Maps in Google Sheets - Add distinct colors and labels to markers

bpwebs bpwebs