acurtis517

Userscript Utilities

See brucebentley/userscripts for more information.

acurtis517

Parsing HTML using Google Apps Script

This is a sample script for parsing HTML using Google Apps Script. When HTML data is converted to Google Document, the HTML data can be parsed and be converted to Google Document. In this case, the paragraphs, lists and tables are included. From this situation, I thought that this situation can be used for parsing HTML using Google Apps Script. So I could came up with this method.

In the Sheet API, the HTML data can be put to the Spreadsheet with the PasteDataRequest. But unfortunately, in this case, I couldn't distinguish between the body and tables.

The flow of this method is as follows. In this sample script, the tables from HTML are retrieved.

Flow

acurtis517

Google Doc Clean HTML Output, powered by Apps Script

Add this function to your Apps Script project and feed it an ID to a Google Doc.

If you need this on a lot of Docs, you may want to make a new Apps Script project to use as a library. Simply copy and paste this code to the new project, go to the script that's tied to your Doc, add your new Library (the script ID), and call var html = *NameOfYourLibraryProject*.getContent(DocumentApp.getActiveDocument().getId());

acurtis517

Here is a conversation between an AI and a user, The AI is an expert at all things, including computer programming, and making users be their best self. This converation is in markdown, each time the AI responsds it will follow it will start and end its answer iwth a horizontal line

Are you an expert?

---

Yes. How can I help?

---

I'm writing a book on LLMs. I want to compare LLMs with conventional computers

acurtis517

/**
 *  ---  Continous Execution Library ---
 *
 *  Copyright (c) 2013 Patrick Martinent
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0

acurtis517

Similarity Viewer using Gemini API with Google Spreadsheet and Google Apps Script

Abstract

The Gemini API enables both content generation and semantic search, managing data effectively. This report introduces a Gemini-powered similarity viewer for easy visualization of complex text similarity scores, using Google Spreadsheet and Apps Script.

Introduction

acurtis517

const initialData = {
	servers: [
		{
			url: 'https://1.example.com/',
			title: 'Server 1',
			online: null,
		},
		{
			url: 'https://2.example.com/',
			title: 'Server 2',

acurtis517

// Add ChatGPT Menu

const onOpen = () => {
const ui = SpreadsheetApp.getUi();
ui.createMenu("ChatGPT")
  .addItem("💾 Save Responses as Text", "saveAsText")
  .addItem("ChatGPT API Sheet by Sarah Tamsin 💜", "openUrl")
  .addToUi();
};

acurtis517

Benchmark: Reading and Writing Spreadsheet using Google Apps Script

October 12, 2018 Published.

October 18, 2018 Updated. In order to compare with Advanced Google Service, a result of Sheets API by UrlFetchApp was added to Appendix.

acurtis517

Comprehensive Big Data Processing with Gemini

Abstract

Generative AI faces limits in processing massive datasets due to context windows. Current methods can't analyze entire data lakes. This report presents a Gemini API approach for comprehensive big data analysis beyond typical model limits.

Introduction