Jay Goldberg JayGoldberg

When someone submits a response to a Google Form, you get an email telling you that someone submitted a response but not what they actually submitted

That suuuucks.

So this project is meant to send you the actual response the person entered, and if you capture their email, the Reply feature in your email client will go back to the respondent.

Insert this code into the Script editor of the Google Form.
Copy the template into an HTML file in the script editor
Install a From form - On form submit trigger to call sendFormResponseByEmail() when someone submits the form.

	#!/bin/bash
	# GCPmakeSpeech.sh
	# run in Google Cloud Shell in the Cloud Console
	# adapted from https://cloud.google.com/text-to-speech/docs/create-audio-text-command-line

	# Check if text argument is provided
	if [ -z "$1" ]; then
	echo "Usage: $0 \"TEXT_TO_SYNTHESIZE\" [OUTPUT_FILE.mp3]"
	exit 1
	fi

	<!DOCTYPE html>
	<html>
	<head>
	<title>ESPHome Circuit finder</title>
	<style>
	.status-container {
	display: grid;
	grid-template-columns: repeat(auto-fit, minmax(100px, 1fr));
	grid-gap: 10px;
	}

	import os
	from google.auth.transport.requests import Request
	from google.oauth2.credentials import Credentials
	from google_auth_oauthlib.flow import InstalledAppFlow
	from googleapiclient.discovery import build
	from googleapiclient.errors import HttpError

	API_SERVICE_NAME = 'youtubeAnalytics'
	API_VERSION = 'v2'
	CLIENT_SECRETS_FILE='ytsecret.json'

	# adds organic noise to AI generated images
	# requires ImageMagick `convert` command
	function makenoise {
	# Get the input extension and use the same one for output
	imageName="$1"
	basename=$(basename "$imageName")
	extension="${imageName##*.}"

	# Split the image into channels
	convert "$imageName" -separate "channel_%d.png"

	function getAllFiles(folderId) {
	const accumulated = [];
	const folder = DriveApp.getFolderById(folderId);

	// Function to copy a file to GCS, handling file or folder path as argument
	function traverseOrReturnItem(item, currentPath) {
	const itemName = item.getName(); // Handles file or folder names
	const thisPath = `${currentPath}${currentPath ? "/" : ""}${itemName}`; // Construct GCS object key

	// if (typeof item === 'object' && item.getMimeType() ? false : true && DriveApp.getFolderById(item.getId()) ? true : false) { // If it's a folder, process contents recursively

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>URL Parameter Stripper</title>
	</head>
	<body>
	<h1>URL Parameter Stripper</h1>

	#!/usr/bin/env python3
	# See: https://medium.com/@lakshmanok/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4

	import json
	import sys

	def convert_geojson(input_file_path):
	with open(input_file_path, 'r') as ifp:
	with open('to_load.json', 'w') as ofp:
	features = json.load(ifp)['features']

	// https://medium.com/google-cloud/how-to-load-geojson-files-into-bigquery-gis-9dc009802fb4
	// Javascript (NodeJS) vs Python
	function convertGeoJsonBq() {
	const fs = require('fs');

	fs.readFile(process.argv[1], 'utf8', (err, data) => {
	if (err) throw err;

	const geojson = JSON.parse(data);
	const features = geojson.features;

	const options = {
	'muteHttpExceptions': true,
	'followRedirects': false
	};

	function getStatusCode(url) {
	const url_trimmed = url.trim();

	let cache = CacheService.getScriptCache();
	let result = cache.get(url_trimmed);