Zum Inhalt springen
Data ProcessingPro — €97

Summarize Text with RapidAPI and Log Results to Google Sheets

85/100
17 Nodes

Beschreibung

Automate djeknet_n8n-master-workflows_Summarize_Text_with_RapidAPI_and_Log_Results_to_Google_Sheets

Setup-Anleitung

# Text Summarizer

This workflow allows users to input a block of text via a web form and receive a summarized version of that text using a third-party API. The result is then recorded in Google Sheets—success or failure.

---

## 📌 Overview

| Feature               | Description                                   |
|----------------------|-----------------------------------------------|
| **Form Inputs**       | Title, Content, Mode (Paragraph/Bullet), Length (Short/Medium/Long) |
| **Summarization API** | RapidAPI Text Summarizer                      |
| **Output**            | Google Sheets (Success or Error Logging)     |

---

## 🧩 Node Descriptions (Single-line)

| Node Name            | Description                                                       |
|----------------------|-------------------------------------------------------------------|
| **On form submission** | Triggers the workflow when the user submits the text summarization form. |
| **Mapping**            | Formats the input data to match the API requirements.             |
| **HTTP Request**       | Sends the text, mode, and length to the external summarization API. |
| **If**                 | Checks if a valid summary was returned from the API.              |
| **Wait**               | Adds a short delay before storing successful summaries.           |
| **Google Sheets**      | Logs successful summaries to a Google Sheet.                      |
| **Wait1**              | Adds a short delay before storing error information.              |
| **Google Sheets1**     | Logs an error message to the Google Sheet if summarization fails. |

---

## 🔄 Workflow Logic

1. **User fills out a form** with the Title, Content, Mode, and Length.
2. The **formTrigger node** starts the workflow and captures the inputs.
3. The **Mapping node** transforms inputs:
   - `Mode` to lowercase.
   - `Length` to a number (1 = Short, 2 = Medium, 3 = Long).
4. The transformed data is sent via **HTTP Request** to a summarization API.
5. The **If node** checks if a `summary` was returned.
6. If successful:
   - Wait briefly (`Wait`).
   - Log the summary to **Google Sheets**.
7. If failed:
   - Wait briefly (`Wait1`).
   - Log the error message to **Google Sheets1**.

---

## ✅ Benefits

- Automates summarization using AI.
- Keeps structured logs in Google Sheets.
- Handles success and failure cases gracefully.
- Easy to customize for different use cases.

Benötigte Integrationen (5)

Form Trigger

formTrigger

If

if

Google API

googleSheets

API Key

HTTP Request

httpRequest

API Key

Wait

wait

Workflow freischalten

Kaufe das Pro Bundle für €97 — erhalte sofortigen Zugang zu diesem und allen weiteren Starter + Pro Workflows als ZIP-Datei zum Import in n8n.

Sichere Zahlung via Stripe. 7-Tage Geld-zurück-Garantie.
← Zurück zum Marketplace