Back to Templates

TechCrunch AI Article Scraper & Classifier with GPT-4.1-nano to Sheets & Telegram

Created by

Created by: Mujahid Kabae || myhit

Mujahid Kabae

Last update

Last update 17 hours ago

Share


How it works

This workflow scrapes the latest Artificial Intelligence articles from TechCrunch, then processes and classifies the content using OpenAI and LangChain nodes. The final result is saved to Google Sheets and sent as a summary to a Telegram group.

Workflow Logic:
Trigger: Schedules daily at 6AM Bangkok time.

Scraper: Extracts URLs and publish dates from TechCrunch's AI category.

Filter: Only continues if the article is from yesterday (to avoid duplication).

Content Fetch: Downloads and extracts article body text.

AI Agent:

Summarizes the article in Thai.

Scores it using strict journalism criteria (max 100).

Categorizes the news into one of 9 predefined categories.

Output:

Saves all structured data to Google Sheets.

Sends a summary to a Telegram group.

Set up steps

🕒 Estimated setup time: 10–15 minutes

Connect your credentials:

Google Sheets (OAuth2)

Telegram

OpenAI account (via LangChain model)

Update the Telegram chatId and Google Sheets documentId/sheetName values.

Deploy and activate the workflow. It runs daily without manual intervention.