Jay Goldberg JayGoldberg

Full-text search of Google Apps Script Projects using Google Apps Script

These are sample scripts for achieving the full-text search of Google Apps Script projects using Google Apps Script. I have the case that I want to search a value from Google Apps Script projects using a Google Apps Script. In this post, I would like to introduce the sample scripts for achieving the full-text search of Google Apps Script projects.

1. Full-text search from all Google Apps Script Projects of standalone type in Google Drive

Before you use this script, please enable Drive API at Advanced Google services. In the case of the Google Apps Script projects of the standalone type, the full-text search can be achieved using Drive API as follows.

	# takes a csv export of the google sheet as input and tries to download pastebins
	#
	# usage:
	# download_pastebins.py <prefix> <name column> <url column> <csv file>
	#
	# example:
	# download_pastebins.py mt18 1 5 "MT18 Draw List - Played Games.csv"

	import sys, os, re, urllib.request, csv

	const router = Router();
	router.Method("GET", "/", function(req, vars) {
	return {"status": "ok"};
	});

	router.Method("GET", "/?<id>[A-Za-z0-9]+)", function(req, vars) {
	return {"status": "ok", "id": vars.id};
	});

	router.Method("POST", "/", function(req, vars) {

	function test() {
	const data = extractDataFromPdf('1jVppnsxpiK56RY7vVFMkTa1_GV8SCWxo');
	console.log(data);
	}

	function extractDataFromPdf(pdfId) {
	const PDF_LANGUAGE = 'th';
	const pdfFile = DriveApp.getFileById(pdfId);
	const { id } = Drive.Files.insert(
	{

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width,initial-scale=1.0" />
	<title>base64 + lzma + iframe</title>
	<style>iframe{position:absolute;top:0;left:0;height:100vh;width:100%;border:none}</style>
	</head>
	<body>
	<iframe sandbox="allow-same-origin allow-downloads allow-scripts allow-forms allow-top-navigation allow-popups allow-modals allow-popups-to-escape-sandbox"></iframe>

	#!/usr/bin/env bash

	# Usage:
	# create-email-alias.sh $URL_OR_DESC [$SLUG]
	# Example:
	# create-email-alias.sh "https://www.darwinsailingclub.com.au" dsc
	# Results in:
	# Email dsc.g9ahxh@example.com -> me+dsc@example.net.au, comment: "https://www.darwinsailingclub.com.au"

	# Environment variables can be supplied at run time or set in ~/.forward-email

	#!/usr/bin/env python3
	"""
	Project AlbertPWN
	(c) 2021, Sem Voigtlander (@userlandkernel)
	"""
	import sys
	import os
	import struct
	import time
	import requests

	#!/usr/bin/env sh
	#
	# by Siddharth Dushantha 2020
	#
	# Dependencies: jq, curl, w3m
	#

	version=1.1.9

	# By default 'tmpmail' uses 'w3m' as it's web browser to render

	// Imports the Google Cloud client library
	const speech = require('@google-cloud/speech');

	// Creates a client
	const client = new speech.SpeechClient();

	// const gcsUri = 'gs://my-bucket/audio.raw';
	// const encoding = 'Encoding of the audio file, e.g. LINEAR16';
	// const sampleRateHertz = 16000;
	// const languageCode = 'BCP-47 language code, e.g. en-US';