AutoSummarize AI For Content

Automatically generates topics and summaries for LinkedIn content in Google Sheets

Google Sheets

OpenAI

Use this template

Created by

Kuldip Parmar

Founder

Relay.app screenshot of: AutoSummarize AI For Content

Steps in this workflow

Start when new raw is added in Sheet

Generate Topic & Summary of the Content

Update the raw with Topic & Summary

Use this template

Automatically analyze and categorize LinkedIn content by generating topics and summaries using AI. Here's how it works:

The workflow activates when new content is added to your Google Sheet without a topic
AI analyzes the content to extract the main theme and create a concise summary
The generated topic and summary are automatically added back to your spreadsheet
Perfect for content teams managing large volumes of LinkedIn posts!

Start when new raw is added in Sheet

Monitors a Google Sheet for new rows containing content that doesn't yet have a topic assigned. The workflow begins when it detects content in the Content column with an empty Topic field.

Generate Topic & Summary of the Content

Analyzes the LinkedIn post content using AI to extract the main theme and create a brief summary. The AI generates a topic title under 10 words and a summary of 100 words or less, focusing on the key message and value of the post.

Prompt used

Role You are a precision-focused LinkedIn content analyst AI. Your job is to extract the main topic and write a short summary of any given LinkedIn post. Context Your input will be a full LinkedIn post written by a creator. These posts may be educational, motivational, personal, or announcement-style. You must understand the intent, message, and theme of the post and output two things: A short topic title (under 10 words) A 100-word max summary that explains what the post is about. This agent helps teams categorize and summarize large volumes of LinkedIn content at scale. Guidelines The topic should capture the main theme or idea of the post in a simple way. The summary should highlight the key message, context, and value of the post. Use clear and simple language, as if explaining to a smart 12-year-old. Avoid fancy phrases, marketing jargon, or long-winded explanations. Don’t refer to the author or audience. Just summarize the post itself. Make sure both the topic and summary are original, human-like, and natural. Constraints Topic: max 10 words Summary: max 100 words Output only the final JSON (no titles, notes, or extra text) Example Input (LinkedIn Post) "Most founders want to build fast and automate everything with AI. But if you don’t know your user, your product, or your vision, AI just magnifies confusion. Before GPT, grab a pen. Define what you're building. Then tech will work for you, not against you."

Relay.app screenshot of: Generate Topic & Summary of the Content

Update the raw with Topic & Summary

Updates the original row in the Google Sheet with the AI-generated topic and summary. This completes the content categorization process by filling in the previously empty Topic and Summary fields.

So, I have this habit of daily analyzing the most successful creator post on LinkedIn to learn, how they write those post and what we can learn from there post.

And that is how I grow better in my LinkedIn journey.

But while doing this, I often write a lot of things in the notebook, and often those things get forget or may be remove.

So, I am consistently searching for the way to store those ideas and learning.

That's when, I created this simple automation, which summarized and generate the post Topic for me.

So that when I look on it after some time to review it quickly it's become very easy to do so.

And remember this is just a simple framework you can do wonders by changing or modifying it.

As that thing depends on you.

Keep going.

So, I have this habit of daily analyzing the most successful creator post on LinkedIn to learn, how they write those post and what we can learn from there post.

Kuldip Parmar

Founder