View url-active-tab
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
chrome.tabs.query({ active: true, currentWindow: true }, function (tabs) { | |
var currentUrl = tabs[0].url; | |
document.getElementById("test").innerHTML = currentUrl; | |
}); |
View serpapi.php
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
require 'google-search-results.php'; | |
require 'restclient.php'; | |
?> | |
<!DOCTYPE html> | |
<html lang="es"> | |
<head> | |
<meta charset="utf-8"> |
View serapinodejs.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//script básico para para hacer consutlas en Google con serpApi | |
const SerpApi = require('google-search-results-nodejs'); | |
const search = new SerpApi.GoogleSearch("YOUR_API_KEY"); | |
const wordsList = ["master seo", "master metaverso", "master marketing digital"]; | |
wordsList.forEach(word => { | |
const params = { | |
engine: "google", |
View copySheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
** Source sheet = Sugerencias | |
** Target sheet = Lista kw's importadas | |
*/ | |
function importar() { | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var sourceSheet = ss.getSheetByName("Sugerencias"); | |
var sourceRange = sourceSheet.getRange ("E9:D18"); |
View Gas_crear_URL_focus_kw
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function crearURL(str) { | |
var regex = /\[?\b(?:de|del|para|la)\b\]?/gi,//Expresió regular con las palabras que queremos eliminar | |
str = str.toLowerCase(); //todo en miniscula | |
str = str.split(" ").join("-"); //separamos por espacios y unimos | |
str = str.normalize("NFD").replace(/[\u0300-\u036f]/g, ""); //quitamos acentos | |
str = str.replace (/^/,'/'); //buscamos el inicio y ponemos una /, ponemos el "triangulo entre barras para escapar el caracter /^/ | |
str = str.replace(regex, ''); //quitamos las stopwords | |
str = str.replace("--","-"); // como nos generaba un espacio creaba algo asi palas--padel, remplaazamos -- por - |
View Gas-SendMail
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function sendEmail() { | |
let fechahoy = new Date().toLocaleDateString() | |
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("comparativa"); | |
var data = ss.getRange ("A1:D5").getValues(); | |
var message = getTable(data); | |
var mensaje = { | |
to: "destino", |
View sprint-python-screamingfrog.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View Gas - GetCategoryURL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Obtener la categoria según la URL | |
function getCategory(url) { | |
//var url = "https://www.mismascotas.es/219-golosinas-snacks-gatos"; | |
let mapa= new Map(); | |
mapa.set("Cat Perros","perros"); | |
mapa.set("Cat Gatos","gatos"); |
View addCalendario_Sheet_GAS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function addCalendario() { | |
//1- Acceso al calendario | |
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); // acceso al sheet | |
var calendarId = spreadsheet.getRange("B2").getValue(); //celda donde esta el ID | |
var tasktCal = CalendarApp.getCalendarById(calendarId);//le pasamos el ID | |
//2. hacer un array con la informacion a meter |
View ocultarEnlaces
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* HTML para poner enlaces, que Google no sigue | |
*/ | |
<button onclick="location.href='#'"> Anchor </button> |
NewerOlder