... ottograjeda

Next-Level Data Automation: Gemini CLI, Google Sheets, and MCP

Abstract

This article explores the integration of the Gemini Command-Line Interface (CLI) with Google Sheets using the Model Context Protocol (MCP). It demonstrates how to leverage the open-source projects MCPApp and ToolsForMCPServer to create a bridge between the Gemini CLI and Google Workspace. This enables users to perform powerful data automation tasks, such as creating, reading, and modifying tables in Google Sheets directly from the command line, using natural language prompts. The article provides practical examples and sample prompts to illustrate the seamless workflow and potential for building sophisticated, AI-powered applications within the Google Cloud ecosystem.

Introduction

Developing a GAS Powered Google Workspace Add-on And Launching It To The Marketplace

This guide will walk you through creating a public Google Workspace Add-on, and launching it in the Google Workspace Marketplace for as free as possible.

This guide was written as I developed and launched my first add-on: Nacho Auto Vacation for Gmail™.

Redeploying Web Apps without Changing URL of Web Apps for new IDE

At March 15, 2021, one endpoint is created for one deployment. Ref By this, when you redeploy "Web Apps", the endpoint is changed. Because the deployment ID is changed. It seems that this it the new specification. In this report, I would like to introduce the method for redeploying Web Apps without changing the URL of Web Apps for new IDE.

Deploy Web Apps

Open "New deployment" dialog with "Deploy" -> "New deployment".
Select "Web app" for "Select type".

Copying Protections for Spreadsheet using Google Apps Script

This is a sample script for copying the protections for Spreadsheet using Google Apps Script. When several protections of the sheet protection and the range protection are set to a Google Spreadsheet and the Spreadsheet is copied using the script and the manual copy with the browser, unfortunately, the protections of ranges are not copied. And also, the protections of sheets can be copied. But, the editor emails are not included. It seems that this is the current specification.

In this post, I would like to introduce a sample script for copying all protection conditions.

Sample script

Please add the following function to your script. And, please enable Sheets API at Advanced Google services.

Simple Installer for Docker Compose on Container-Optimized OS on Google Computing Engine

The easiest way to make Docker Compose available on Container-Optimized OS on Google Compute Engine (GCE) on Google Cloud Platform (GCP).

This is minimal Bash script version of Community Tutorial.

How to use

Simply, download installer.sh, run it, and then reload bash by source ~/.bashrc or re-login.

Sample Scripts for Requesting to Web Apps by Various Languages

These are the sample scripts by the various languages for requesting to Web Apps created by Google Apps Script.

curl
Google Apps Script
Javascript
ajax

	// Create a loading bar in your Google Sheet using Google Apps Script
	// Author: Al Chen ([email protected])
	// Last Updated: April 13th, 2021
	// Notes: Assumes you are using the V8 runtime (https://developers.google.com/apps-script/guides/v8-runtime)
	// Example Google Sheet: https://docs.google.com/spreadsheets/d/1ngvYKEMunqCVufR10rlK42iENAERp-uyiPN_aiq-MKo/edit?usp=sharing

	SOURCE_SHEET_ID = 'YOUR_GOOGLE_SHEETS_ID'
	SOURCE_WORKSHEET_NAME = 'YOUR_WORKSHEET_NAME'

	function loop() {

	https://jennamolby.com/how-to-use-cookies-to-capture-url-parameters/

	let YOUR_DOMAIN = "YOUR_DOMAIN.TLD" // ex: scrapingbee.com

	function getParameterByName(name) {
	name = name.replace(/[\[]/, "\\[").replace(/[\]]/, "\\]");
	var regex = new RegExp("[\\?&]" + name + "=([^&#]*)"),
	results = regex.exec(location.search);
	return results === null ? "" : decodeURIComponent(results[1].replace(/\+/g, " "));
	}

	local FooBar = {}
	FooBar.__index = FooBar

	function FooBar.new()
	local this = {
	_privateVariable = 137,
	}
	return setmetatable(this, FooBar)
	end