Yagisanatode Yagisanatode

Google Developer Expert in Google Workspace with a focus on Google Sheets and Google Apps Script.

Yagisanatode / Index.html

Last active August 18, 2021 07:16

Added link to tutorial

	<!DOCTYPE html>
	<html>
	<head>
	<base target="_top">
	</head>
	<body>
	<h1 style="color:blue">You are worthy!</h1>
	</body>
	</html>

Yagisanatode / Code.gs

Last active November 3, 2021 09:23

Update Date-Time stamp on checkbox clicked in Google Sheets with Google Apps Script

	// @author Yagisanatode @link https://www.yagisanatode.com
	// Link to attached sheet. Go to File > Make a copy
	// @link https://docs.google.com/spreadsheets/d/14orOMBnjpjHewUsWUgunZQKbeNNnZHM9JKMpkaCxRDA/edit#gid=0

	// ####### on Edit trigger function #######
	/**
	* Custom Apps Script Trigger function that runs when sheet is edited.
	* @param {Object} e - Apps Script trigger event object.
	*/
	function onEdit(e) {

Yagisanatode / list_hidden_google_sheets.gs

Last active September 9, 2022 00:04

List hidden Google Sheets by name and id with Google Apps Script

	/**
	* @OnlyCurrentDoc
	*/

	/**
	* Get a list of hidden or visible sheets.
	* [The video tutorial]{@link https://youtu.be/jsTvi_F_Xk8}
	* @author Scott (Yagi) <[email protected]>
	* @license Attribution-NonCommercial 4.0 International (CC BY-NC 4.0)
	*/

Yagisanatode / Index.html

Created December 28, 2023 04:48

For tutorial on CSRF in Google Apps Script for Yagisanatode blog

	<!DOCTYPE html>
	<html>
	<head>
	<base target="_top">
	<link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css">
	</head>
	<body>
	<div id="container">
	<h1>Choose Your Goat</h1>
	<form id="goatForm" onsubmit="event.preventDefault();">