Generate Comparison Blog Posts for AEO and SEO
This automation creates high-quality, AEO/SEO-optimized comparison blog posts. It sources topics from a Google Sheet, conducts in-depth research on two companies, writes a balanced article based on a custom style guide, and saves the final output as a new Google Doc.
Airtop Community
Featured Apps
This automation streamlines your content creation pipeline for competitive analysis articles. Here's how it works:
- Reads Your Topics: The workflow begins by connecting to a Google Sheet you specify, looking for rows that have companies to compare but haven't been written yet.
- Conducts In-Depth Research: For each article, it researches the two companies. It visits their homepages to understand their core value proposition and uses a search engine to gather details on features, target audience, pricing, and key differentiators.
- Generates a Compelling Title: Using the research and your specific company context, it crafts an "outcome-first" title designed to capture user intent and perform well in search.
- Writes a Balanced Article: Guided by your provided style guide in a Google Doc, the automation writes a comprehensive comparison article. The content is structured for readability and SEO, including sections like a TL;DR, feature comparisons, target audience analysis, and an FAQ.
- Adds Visuals (Optional): If enabled, it will visit each company's website, take a screenshot, and add links to the images in the article.
- Creates the Final Document: The complete article is saved as a new Google Doc in your designated Google Drive folder.
- Updates Your Sheet: Finally, it goes back to your source Google Sheet and updates the row with the newly generated article title and a direct link to the Google Doc, closing the loop on your content workflow.
Usage Ideas
- Automate the creation of "Alternative to" articles for your product to capture high-intent search traffic.
- Generate a continuous stream of competitor comparison posts for your company blog.
- Create detailed product and feature showdowns for an affiliate marketing website.
- Quickly produce internal competitive "battle cards" for your sales and marketing teams.
- Build a content engine for a review site that compares products or services in a specific niche.
Customization Ideas
This template is designed to be a powerful starting point that you can easily tailor to your specific content strategy. You have the flexibility to:
- Use Your Own Sources: Connect your own Google Sheet with your content calendar. The column names for company names and article titles can also be adjusted.
- Match Your Brand Voice: Provide a link to your own Google Doc style guide to ensure every article reflects your brand's unique tone, style, and structure.
- Control the Output: You can define the target word count, choose where to save your articles in Google Drive, and decide whether or not to include screenshots.
- Guide the Narrative: By providing specific context about your company, you can steer the AI to focus on the key differentiators and value propositions that matter most to you.
- Customize the Content: The entire structure of the blog post, from the research questions asked to the final sections in the article (like "TL;DR" or "Who It's For"), can be modified to fit your content templates.
- Integrate Other Tools: While it's pre-configured for Google Workspace, the automation can be adapted to pull data from other sources or publish content to other platforms, like your CMS.
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
defaultCompany | string | None |
Default company to use for comparisons when 'Company 2 - Optional' column is empty | ||
googleDriveFolderUrl | string | None |
URL to the Google Drive folder where generated blog post documents will be saved | ||
googleSheetUrl | string | None |
URL to your Google Sheet with the list of companies to compare | ||
styleGuideDocUrl | string | None |
URL to your style guide Google Doc showing writing tone and blog structure | ||
Optional Parameters
Name | Type | Default |
|---|---|---|
captureScreenshots | boolean | true |
Whether to capture and include website screenshots in the blog posts | ||
companyContext | string | |
Optional company background and specific instructions for writing articles (e.g., 'focus on the capabilities of Agents that are built by the platform') | ||
maxBlogPostsToProcess | number | 2 |
Maximum number of blog posts to create per automation run. Use -1 to process all available | ||
targetWordCount | string | 1000-2000 |
Target word count range for blog posts (e.g., '1000-2000') | ||
