Skip to content

Instantly share code, notes, and snippets.

Avatar
🟢
available

Aina Lluna seoutopico

🟢
available
View GitHub Profile
@seoutopico
seoutopico / save_sheet_google_cloud_sql
Last active May 9, 2018
# Save Google Sheet in Google Cloud SQL
View save_sheet_google_cloud_sql
// Replace the variables in this block with real values.
// You can find the "Instance connection name" in the Google Cloud
// Platform Console, on the instance Overview page.
var connectionName = 'xxx';
var user = 'xxx';
var userPwd = 'xxx';
var db = 'xxx';
var dbUrl = 'jdbc:google:mysql://' + connectionName + '/' + db;
@seoutopico
seoutopico / ExtraerPreguntasGoogle.txt
Last active Aug 22, 2019
Bookmarklet para Extraer preguntas de Google
View ExtraerPreguntasGoogle.txt
javascript:(function(){output="<html><head><title>Extraer preguntas de Google</title></head><body>";var preguntas = document.getElementsByClassName("kno-ato");for(var i = 0; i < preguntas.length; i++){var pregunta = preguntas[i].innerText;output+=pregunta+"<br />";};with(window.open()){document.write(output);document.close();}})();
View funciones_Personalizadas_Sheet_GAS
/**
* Función para calcular el % de cambio
*
* @param {numero} antiguoValor Valor Antiguo
* @param {numero} nuevoValor Valor Orginal
* @return El % de cambio entre los dos valores
* @customfunction
*/
function porcentajeCambio(antiguoValor, nuevoValor) {
View funciones_SEO_Sheet_Gas
/*Obtenemos el status code*/
function getStatusCode(url){
var options = {
'muteHttpExceptions': true,
'followRedirects': false
};
var url_trimmed = url.trim();
var response = UrlFetchApp.fetch(url_trimmed, options);
You can’t perform that action at this time.