rana tamure
I'm the founder and CEO of LetsAutomate, an agency dedicated to building smart scalable automation systems using n8n. With deep hands on experience, I design workflows that power lead generation, AI agents, scheduling CRM syncs and more all built entirely in n8n.
Templates by rana tamure
Generate SEO blog content with GPT-4, Perplexity & WordPress auto-publishing
This n8n workflow automates the creation of high-quality, SEO-optimized blog posts using AI. It pulls keyword data from Google Sheets, conducts research via Perplexity AI, generates structured content (title, introduction, key takeaways, body, conclusion, and FAQs) with OpenAI and Anthropic models, assembles the post, performs final edits, converts to HTML, and publishes directly to WordPress. Ideal for content marketers, bloggers, or agencies looking to scale content production while maintaining relevance and engagement. Key Features Keyword-Driven Generation: Fetches primary keywords, search intent, and related terms from a Google Sheets spreadsheet to inform content strategy. AI Research & Structuring: Uses Perplexity for in-depth topic research and OpenAI/Anthropic for semantic analysis, outlines, and full content drafting. Modular Content Creation: Generates sections like introductions, key takeaways, outlines, body, conclusions, and FAQs with tailored prompts for tone, style, and SEO. Assembly & Editing: Combines sections into a cohesive Markdown post, adds internal/external links, and applies final refinements for readability and flow. Publishing Automation: Converts Markdown to styled HTML and posts drafts to WordPress. Customization Points: Easily adjust AI prompts, research depth, or output formats via Code and Set nodes. Requirements Credentials: OpenAI API (for GPT models), Perplexity API (for research), Google Sheets OAuth2 (for keyword input), WordPress API (for publishing). Setup: Configure your Google Sheets with columns like "keyword", "search intent", "related keyword", etc. Ensure the sheet is shared with your Google account. Dependencies: No additional packages needed; relies on n8n's built-in nodes for AI, HTTP, and data processing. How It Works Trigger & Input: Start manually or schedule; pulls keyword data from Google Sheets. Research Phase: Uses Perplexity to gather topic insights and citations from reputable sources. Content Generation: AI nodes create title, structure, intro, takeaways, outline, body, conclusion, and FAQs based on research and SEO guidelines. Assembly & Refinement: Merges sections, embeds links, edits for polish, and converts to HTML. Output: Publishes as a WordPress draft or outputs the final HTML for manual use. Benefits Time Savings: Automate 80-90% of content creation, reducing manual writing from hours to minutes. SEO Optimization: Incorporates primary/related keywords naturally, aligns with search intent, and includes semantic structures for better rankings. Scalability: Process multiple keywords in batches; perfect for content calendars or high-volume blogging. Quality Assurance: Built-in editing ensures engaging, error-free content with real-world examples and data-backed insights. Versatility: Adaptable for any niche (e.g., marketing, tech, finance) by tweaking prompts or sheets. Potential Customizations Add more AI models (e.g., via custom nodes) for varied tones. Integrate image generation or social sharing for full content pipelines. Filter sheets for specific topics or add notifications on completion.
By rana tamureComprehensive SEO keyword research & analysis with DataForSEO and Google Sheets
Overview This n8n workflow, named "Keyword Search for Blogs," automates the process of gathering and organizing keyword research data for SEO purposes. It integrates with Google Sheets and Google Drive to manage input and output data, and leverages the DataForSEO API to fetch comprehensive keyword-related information, including related keywords, keyword suggestions, keyword ideas, autocomplete suggestions, subtopics, and SERP (Search Engine Results Page) analysis. The workflow is designed to streamline SEO research by collecting, processing, and storing data in an organized manner for blog content creation. Workflow Functionality The workflow performs the following key functions: Trigger: Initiated manually via the "When clicking ‘Test workflow’" node, allowing users to start the process on-demand. Input Data Retrieval: Reads primary keywords, location, and language data from a specified Google Sheet ("SEO PRO"). Spreadsheet Creation: Creates a new Google Sheet with a dynamic title based on the current date (e.g., "YYYY-MM-DD-seo pro") and predefined sheet names for organizing different types of keyword data (e.g., keyword, SERP, Content, related keyword, keyword ideas, suggested keyword, subtopics, autocomplete). Google Drive Integration: Moves the newly created spreadsheet to a designated folder ("seo pro") in Google Drive for organized storage. API Data Collection: Related Keywords: Fetches related keywords using the DataForSEO API (/v3/dataforseolabs/google/relatedkeywords/live), including SERP information and keyword metrics like search volume, CPC, and competition. Keyword Suggestions: Retrieves keyword suggestions via the DataForSEO API (/v3/dataforseolabs/google/keywordsuggestions/live). Keyword Ideas: Collects keyword ideas using the DataForSEO API (/v3/dataforseolabs/google/keywordideas/live). Autocomplete Suggestions: Gathers Google autocomplete suggestions through the DataForSEO API (/v3/serp/google/autocomplete/live/advanced). Subtopics: Generates subtopics for the primary keyword using the DataForSEO API (/v3/contentgeneration/generatesub_topics/live). People Also Ask & Organic Results: Pulls "People Also Ask" questions and organic SERP results via the DataForSEO API (/v3/serp/google/organic/live/advanced). Data Processing: Uses Split Out nodes to break down API responses into individual items for processing. Employs Edit Fields nodes to map and format data, extracting relevant fields like keyword, search intent, search volume, CPC, competition, keyword difficulty, and SERP item types. Filters SERP results to separate "People Also Ask" and organic results for targeted processing. Data Storage: Appends processed data to multiple sheets in the destination Google Sheet ("2025-06-08-seo pro") across different tabs: Master Sheet: Stores comprehensive data including keywords, search intent, related keywords, SERP analysis, and more. Related Keywords: Stores related keyword data with metrics. Suggested Keywords: Stores suggested keyword data. Keyword Ideas: Stores keyword ideas with relevant metrics. Autocomplete: Stores autocomplete suggestions. Subtopics: Stores generated subtopics. Organic Results: Stores organic SERP data with details like domain, URL, title, and description. Key Features Automation: Eliminates manual keyword research by automating data collection and organization. Scalability: Processes multiple keywords and their related data in a single workflow run, with a limit of 100 related items per API call. Dynamic Organization: Creates and organizes data in a new Google Sheet with a timestamped title, ensuring easy tracking of research over time. Comprehensive SEO Insights: Collects diverse SEO metrics (e.g., keyword difficulty, search intent, SERP item types) to inform content strategy. Error Handling: Uses filters to ensure only relevant data (e.g., "peoplealsoask" or "organic" results) is processed and stored. Use Case This workflow is ideal for SEO professionals, content creators, and digital marketers who need to perform in-depth keyword research for blog content. It provides a structured dataset that can be used to identify high-potential keywords, understand search intent, analyze SERP competition, and generate content ideas, all of which are critical for optimizing blog posts to rank higher on search engines. Inputs Google Sheet ("SEO PRO"): Contains primary keywords, location names, and language names. Google Drive Folder: Destination folder ("seo pro") for storing the output spreadsheet. DataForSEO API Credentials: Requires HTTP Basic Authentication credentials for accessing DataForSEO API endpoints. Outputs A new Google Sheet titled with the current date (e.g., "2025-06-08-seo pro") containing multiple tabs: Master Sheet: Aggregated data for all keyword types. Related Keywords: Detailed metrics for related keywords. Suggested Keywords: Suggested keywords with metrics. Keyword Ideas: Keyword ideas with metrics. Autocomplete: Google autocomplete suggestions. Subtopics: Generated subtopics for content planning. Organic Results: Organic SERP data including domains, URLs, titles, and descriptions. Benefits Time-Saving: Automates repetitive tasks, reducing manual effort in keyword research. Organized Data: Stores all data in a structured Google Sheet for easy access and analysis. Actionable Insights: Provides detailed SEO metrics to guide content creation and optimization strategies. Scalable and Reusable: Can be reused for different keywords by updating the input Google Sheet. Technical Details Nodes: Utilizes n8n nodes including manualTrigger, googleSheets, googleDrive, httpRequest, splitOut, set, and filter. API Integration: Leverages DataForSEO API for real-time keyword and SERP data. Credentials: Requires Google Sheets OAuth2 and Google Drive OAuth2 credentials, along with DataForSEO HTTP Basic Authentication. Data Mapping: Uses set nodes to map API response fields to desired output formats, ensuring compatibility with Google Sheets. Potential Enhancements Add error handling for API failures or invalid inputs. Include additional DataForSEO API endpoints for more granular data (e.g., competitor analysis). Implement deduplication logic to avoid redundant keyword entries. Add a scheduling node to run the workflow automatically at regular intervals. This workflow is a powerful tool for SEO-driven content planning, providing a robust foundation for creating optimized blog content.
By rana tamureGenerate personalized cold emails with GPT-4o-mini and Google Sheets
Google Email Ice Breaker Workflow Description This n8n workflow automates the creation of personalized cold emails for dental clinics to promote an AI chatbot service. It retrieves verified email data from a Google Sheet, generates tailored email subject lines and bodies using OpenAI’s GPT-4o-mini model, processes the output, and updates the Google Sheet with the results. Designed for dental clinics or marketers, it streamlines outreach by crafting engaging, seemingly hand-researched emails that drive appointment bookings through an AI chatbot integration. Key Features Data-Driven Outreach: Pulls verified emails, company names, descriptions, and websites from a Google Sheet to create targeted emails. AI-Powered Email Generation: Uses OpenAI’s GPT-4o-mini to craft concise, persuasive, and personalized cold email content. Personalization: Shortens company names and locations (e.g., "San Fran" instead of "San Francisco") and references specific business details for a tailored feel. Batch Processing: Handles multiple prospects efficiently using a looping mechanism. Google Sheet Integration: Updates the sheet with generated email subjects, bodies, and a status marker for tracking. Customizable Prompts: Easily modify the AI prompt to adapt the tone or service offering for different industries. Requirements Credentials: Google Sheets OAuth2 API (for data access) and OpenAI API (for email generation). Setup: Configure a Google Sheet with columns for "EMAIL verified", "companyName", "description", "website", "category", "email subject", "body", and "email created". Ensure the sheet is accessible via your Google account. Dependencies: No external packages required; uses n8n’s built-in Google Sheets, OpenAI, and Code nodes. How It Works Trigger & Input: Starts manually (e.g., via "Test workflow") and retrieves data from a Google Sheet, filtering for rows where "category" is "Good" and "email created" is "no". Batch Processing: Loops over filtered rows to process each prospect individually. Email Generation: OpenAI generates a JSON output with a subject and body, personalized using the prospect’s company name, description, and website. Content Processing: A Code node cleans and parses the AI output, extracting the subject and body. Sheet Update: Updates the Google Sheet with the generated subject, body, and sets "email created" to "yes". Looping: Continues processing until all prospects are handled. Benefits Time Efficiency: Automates cold email creation, reducing manual effort from hours to minutes. Personalized Outreach: Crafts emails that feel deeply researched, increasing engagement rates. Scalability: Processes large lists of prospects in batches, ideal for high-volume campaigns. Tracking: Updates the Google Sheet to track which emails have been generated. Versatility: Adaptable for other industries by modifying the AI prompt or Google Sheet structure. Potential Customizations Prompt Adjustments: Tweak the OpenAI prompt to target different services (e.g., marketing tools, SaaS products) or industries. Filter Modifications: Change Google Sheet filters to target specific prospect categories or regions. Output Expansion: Add nodes to send emails directly or integrate with CRMs like HubSpot. Notifications: Include email or Slack notifications when the workflow completes.
By rana tamure