Skip to content

Instantly share code, notes, and snippets.

@llermaly
llermaly / elasticsearch-mcp-n8n.json
Created October 4, 2025 14:53
Agent builder + N8N Workflow
{
"name": "My workflow",
"nodes": [
{
"parameters": {
"promptType": "define",
"text": "=You are a helpful assistant that helps analyzing Google \"Peoople Ask About\" related questions for specific keywords for a given week.\n\nThe results for the keyword: {{ $json.search_parameters.q }} are:\n\n{{ $json.related_questions.toJsonString() }}\n\nI want you to use your search tool to go find historical searches using the following ESQL query:\n\n`FROM serp_results` Run this query as is.\n\nAnd then write a report analysis using the Google docs tool.\n\nYou must first create the doc, and pass the document id to the add content tool. Use the keyword and the date for the document title.\nFor the report I'm looking for the format:\n\n# Todays date, keyword\n# This week results summary\n# Total dataset results summary\n# Conclusion about differences between the current week, and the total dataset changes\n",
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.agent",
@llermaly
llermaly / esql-timeline.md
Last active June 25, 2025 02:56
ES|QL Timeline
import sys
import cv2
import pytesseract
import re
import json
import numpy as np
import glob
import csv
from datetime import datetime