AI Text Summarization and Logging with RapidAPI and Google Sheets - n8n Workflow

Users needing automated content processing and summarization tools.
n8n specialists building custom AI services for internal users.
Teams who require structured logging of external API interactions.
Anyone looking for advanced n8n templates integrating custom form inputs and third-party APIs.

This robust n8n workflow provides a powerful solution for integrating text summarization AI into business processes. It starts with a custom-built web form that serves as the primary n8n trigger, capturing the content, desired mode (bullet/paragraph), and summary length. The core value of this n8n template lies in its ability to securely interact with a high-performance RapidAPI endpoint for summarization, handle complex data mapping and transformation internally, and crucially, maintain a structured log of all operations in Google Sheets, ensuring accountability whether the API call succeeds or fails. This complete n8n solution minimizes manual data entry and maximizes automation efficiency, offering a stable and replicable text summarization service built entirely on n8n.

1. The process begins when a user submits data via the custom On form submission n8n trigger, providing text content and configuration settings.


2. The Mapping n8n node standardizes the input data, converting the selected Length (Short, Medium, Long) to the numeric codes (1, 2, 3) required by the external API.


3. An HTTP Request n8n node securely sends the prepared content and parameters (Text, Mode, Length) to the Text Summarizer service hosted on RapidAPI, using the required API key for authentication.


4. The If n8n node then analyzes the API response. This crucial n8n node checks specifically if a valid summary was returned, determining the subsequent flow direction.


5. Success Path: If the summary is present, the data flows through the Wait n8n node (optional delay) to the Google Sheets n8n node, logging the original request and the successful summary result.


6. Failure Path: If the summary is missing or empty, the flow takes the false route to the Wait1 and then to the Google Sheets1 n8n node, logging the original submission details along with an explicit error message ("Error occurred. Please try later"). This comprehensive error handling makes this n8n workflow extremely reliable.

To utilize this n8n workflow template, follow these steps:

1. Import the Workflow: Copy the provided JSON data and paste it into your n8n instance to import this complete n8n workflow.


2. Form Trigger Setup: Activate the On form submission n8n trigger node to generate the public webhook URL for your custom summarization form. Share this URL with users.


3. RapidAPI Credentials: Edit the HTTP Request n8n node. You must subscribe to the RapidAPI Text Summarizer service and update the x-rapidapi-key header parameter within this n8n node with your actual API key.


4. Google Sheets Authentication: Set up your Google Sheets credential, ideally using a Service Account for robust, long-term access.


5. Configure Google Sheets: Edit both the Google Sheets n8n nodes. Link your new credential and provide the specific Document ID (from the spreadsheet URL) and the Sheet Name where you wish to log the results of this n8n automation.

On form submission (n8n trigger): Functions as the workflow entry point. It presents a custom web form to the user, collecting mandatory fields like Title, Content, Mode, and Length, immediately starting the n8n workflow upon submission.
Mapping (Set n8n node): Essential for data preparation. Function: It transforms the user-friendly dropdown values (Short, Medium, Long) into numeric codes (1, 2, 3) required by the summarization API, ensuring the HTTP Request n8n node receives correctly formatted data.
HTTP Request (n8n node): Executes the core summarization logic. Function: Sends a POST request to the RapidAPI Text Summarizer endpoint, securely passing input data and authentication headers (x-rapidapi-key). The subsequent success or failure determines the path of the rest of the n8n workflow.
If (n8n node): Acts as the primary decision point. Function: It checks if the API response contains a non-empty summary field. This directs the n8n workflow either to the success logging path or the error logging path.
Google Sheets (n8n node - Success Path): Logs successful summarization results. Function: Appends the generated summary along with the input metadata (Title, Mode, Length, Submission Date) to the designated Google Sheet.
Google Sheets1 (n8n node - Error Path): Handles API failure logging. Function: Appends the original request details to the Google Sheet but explicitly records the summary field as an error message, providing clear documentation of the failure within this n8n workflow.