bpwebs’s gists

bpwebs / #How to pull data from Google Sheets to HTML table.txt

Last active March 12, 2026 11:09

How to pull data from Google Sheets to HTML table - bpwebs.com

How to pull data from Google Sheets to HTML table

bpwebs / #Google Apps Script - Upload files to Google Drive

Last active January 18, 2026 16:28

Upload files to Google Drive using Google Apps Script Web Apps and save records in Google Sheets.

bpwebs / Code.gs

Created February 27, 2022 16:42

Getting crypto price updates to Google Sheets from CoinMarketCap with Google Apps Script

	/**
	* CRYPTO PORTFOLIO TRACKER
	* CREATE BY: www.bpwebs.com
	*/

	const SHEET_NAME = 'Crypto Portfolio';
	const RN = 7; //The row number of the first coin the coins table

	function getCryptoUpdates() {

bpwebs / #Email Google Sheets table to inbox.txt

Last active November 30, 2022 16:30

Email Google Sheets table to inbox

#Email Google Sheets table to inbox.txt

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

Last active March 9, 2023 18:13

Generate Static Google Maps in Google Sheets - Add place markers

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 / #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 / #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 / 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 / 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 bpwebs