dzuluaga

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

dzuluaga

Step 1: Run below commands in GCP CloudShell

Step 2: Configure Edgemicro

```bash

```

**Recommendations**
Store in ~/.profile environment variables. APIGEE_ORG, APIGEE_ENV, ae_username, and ae_password.

dzuluaga

CF cli Google Cloud Shell Installation

Go to console.cloud.google.com and sign in and start Google Cloud Shell

For Debian and Ubuntu-based Linux distributions, perform the following steps:

Add the Cloud Foundry Foundation public key and package repository to your system:

$ wget -q -O - https://packages.cloudfoundry.org/debian/cli.cloudfoundry.org.key | sudo apt-key add -

dzuluaga

How to install ngrok in Google Cloud Shell

These steps will surface a public endpoint through ngrok with no authentication.

1. Download ngrok

$ curl https://bin.equinox.io/c/4VmDzA7iaHb/ngrok-stable-linux-amd64.zip -o ngrok-stable-linux-amd64.zip

dzuluaga

#!/bin/bash

file="$HOME/ngrok"
if [ -f "$file" ]
then
	echo "$file found."
else
	echo "$file not found. Downloading."
	curl https://bin.equinox.io/c/4VmDzA7iaHb/ngrok-stable-linux-amd64.zip -o $HOME/ngrok-stable-linux-amd64.zip
	unzip $HOME/ngrok-stable-linux-amd64.zip -d $HOME

dzuluaga

#!/usr/bin/env bash

# Replaces the current existing of Gradle with 5.2.1
# Run this script directly from the command line
#
# $ curl "https://gist.githubusercontent.com/dzuluaga/80df9a5316b56c19da982054e335468a/raw/update-gradle-cloud-shell.sh?$(date +%s)" | sudo bash

echo 'Downloading Gradle...'
curl https://downloads.gradle.org/distributions/gradle-5.2.1-bin.zip -o gradle-5.2.1-bin.zip

dzuluaga

#!/usr/bin/env bash

# Installs ngrok on GCP Cloud Shell in a single command
# Run this script directly from the command line
#
# $ curl "https://gist.githubusercontent.com/dzuluaga/b3b18a98c2ba9c326c3e6680301b26b8/raw/install-ngrok-gcp-cloud-shell.sh?$(date +%s)" | sudo bash

echo 'Downloading ngrok...'
curl https://bin.equinox.io/c/4VmDzA7iaHb/ngrok-stable-linux-amd64.zip -o ngrok-stable-linux-amd64.zip

dzuluaga

#!/usr/bin/env bash

# Installs oh-my-zsh on GCP Cloud Shell in a single command.
# Run this script directly from the command line
#
# $ curl "https://gist.githubusercontent.com/dzuluaga/3bf775217728debf360a4377c7eb5118/raw/install-oh-my-zsh-gcp-cloud-shell.sh?$(date +%s)" | sudo bash
# 
# you can also append an alias to ~/.bashrc to install-zsh at anytime
#
# alias install-zsh="curl \"https://gist.githubusercontent.com/dzuluaga/3bf775217728debf360a4377c7eb5118/raw/install-oh-my-zsh-gcp-cloud-shell.sh?$(date +%s)\" | sudo bash"

dzuluaga

#!/usr/bin/env bash

# Runs localtunnel on GCP Cloud Shell in a single command.
# Run this script directly from the command line
#
# $ curl "https://gist.githubusercontent.com/dzuluaga/b9428ea1a1d1a3fb831c53cbf39316dd/raw/run-localtunnel-gcp-cloud-shell.sh?$(date +%s)" | bash

echo "Installing zsh..."
echo ""
npm install -g localtunnel

dzuluaga

# add this line at the end of ~/.bashrc file
# this alias installs zsh and oh-my-zsh by calling $ install-zsh
# useful for GCP Cloud Shell, which will remove zsh everytime your Cloud Shell container is terminated.

alias install-zsh="curl \"https://gist.githubusercontent.com/dzuluaga/3bf775217728debf360a4377c7eb5118/raw/install-oh-my-zsh-gcp-cloud-shell.sh?$(date +%s)\" | sudo bash"