Skip to content

Daily

Store new reviews in Pinecone and flag bad ones on Telegram

Every new review of your business is saved for later analysis, and you get a Telegram message the same day about any one- or two-star review.

Runs
Daily
Apps
Pinecone, Telegram
AI
Yes, uses the built-in AI allowance
Access
Pinecone write; Telegram bot token

Send this to your assistant

Create a ClickRuntime automation: every morning, fetch new reviews of my business, add them to my Pinecone index, and message me on Telegram about any 1 or 2 star review with a short summary.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A family-run restaurant group with three locations lives and dies by its Google reviews. The owners read them when they remember to, which means a furious one-star review about a cold delivery can sit unanswered for a week while potential customers read it. They also have a sense that the same complaints keep coming up, but no easy way to check.

This automation handles both problems. Each morning new reviews are stored in a Pinecone index, building a searchable history of everything customers have said. Any review of one or two stars is summarised and sent straight to the owner on Telegram, so it can be answered while the customer is still listening.

What you get out of it

  • Reply to unhappy customers quickly

    A fast, polite reply to a bad review shows future customers you care and sometimes turns the reviewer around. Getting the alert the same day makes that possible.

  • A searchable history of every review

    Reviews stored in Pinecone can be searched by meaning later. Asking which reviews mention slow service or parking finds them even when customers used different words.

  • Spot patterns across locations

    With every review in one place, recurring complaints at one site stand out. That turns scattered feedback into something managers can act on.

  • Only the reviews that need attention

    Good reviews are stored quietly and only low ratings trigger a message. The owner's phone stays calm on good days and lights up when it matters.

How it works

What happens, step by step

  1. Every morning, ClickRuntime fetches the latest reviews of your business from your review source.

  2. It skips any review it has already stored, so each one is handled once.

  3. New reviews are added to your Pinecone index with their rating, location and date.

  4. For each review of one or two stars, AI writes a one-line summary of the complaint, and a Telegram message is sent to you with the rating, summary and a link to reply.

Before it runs live

  • Connect Pinecone
  • Connect Telegram

What you get

RunsDaily
Store new reviews in Pinecone and flag bad ones on Telegramtoday, 9:00Succeeded
Telegram · Review alerts⭐ review at Northwind Bistro (Riverside): delivery arrived 50 minutes late and cold.

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Run it at a different time, more or less often, or only on weekdays
  • Change what the AI looks for, or how it writes the result
  • Add another app, for example also send it to Slack
  • Combine it with other Pinecone and Telegram steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
index_new_reviews_in_pinecone_and_alert_on_telegram.pyexample
from clickruntime import on_trigger, credentials, http, state, ai, report_fetched

REVIEWS_URL = "https://api.example-reviews.com/v1/reviews?business=northwind-bistro"
OWNER_CHAT_ID = 123456789

@on_trigger
def run(event):
    seen = set(state.get("seen") or [])
    reviews = [r for r in http.get(REVIEWS_URL, headers={"Authorization": f"Bearer {credentials.secret('REVIEWS_API_KEY')}"}).json()["reviews"] if r["id"] not in seen]
    report_fetched(len(reviews))
    if not reviews:
        return {"new": 0}
    embeds = http.post("https://api.pinecone.io/embed", headers={"Api-Key": credentials.secret("PINECONE_API_KEY"), "X-Pinecone-API-Version": "2025-01"},
                       json={"model": "multilingual-e5-large", "inputs": [{"text": r["text"][:2000]} for r in reviews]}).json()["data"]
    http.post(f"https://{credentials.secret('PINECONE_HOST')}/vectors/upsert", headers={"Api-Key": credentials.secret("PINECONE_API_KEY")},
              json={"vectors": [{"id": r["id"], "values": e["values"], "metadata": {"text": r["text"][:2000], "rating": r["rating"], "date": r["date"]}} for r, e in zip(reviews, embeds)]})
    bad = [r for r in reviews if r["rating"] <= 2]
    for r in bad:
        summary = ai.generate(f"Summarise this complaint in one line:\n{r['text'][:2000]}", max_output_tokens=60).text.strip()
        http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage",
                  json={"chat_id": OWNER_CHAT_ID, "text": f"{'⭐' * r['rating']} review: {summary}\n{r.get('url', '')}"})
    state.set("seen", list(seen | {r["id"] for r in reviews})[-2000:])
    return {"new": len(reviews), "alerts": len(bad)}

FAQ

Common questions

Where do the reviews come from?
From a review source you connect, such as Google reviews through a reviews API or your booking platform's export. The automation needs a list of reviews with a rating, text and date.
Can I change the rating that triggers an alert?
Yes. You can alert on three stars and below, or only on one star. You can also ask to be alerted on any review that mentions a word such as "sick" or "refund".
Does it reply to the review for me?
No. It tells you about the review and summarises the complaint. Replying stays with you, so the response sounds like you and fits the situation.
What permissions does it need?
Pinecone write; Telegram bot token. Nothing else in your accounts is used.
Does it need AI?
Yes. It uses ClickRuntime's built-in AI, so you don't need an OpenAI or Anthropic key. Every plan includes a monthly AI allowance.
How many runs does it use?
One run each time it runs (daily). Checks that find nothing to do and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Store new reviews in Pinecone and flag bad ones on Telegram” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.