Priyanka Rana
Founder - SoulAds.ai, BuildmyAIFlow.agency, peppy production. The curious mind behind many startups and now the driving force behind a new wave of AI-powered brand storytelling through SoulAds.ai and automation through BuildmyAIflow.agency.
Templates by Priyanka Rana
Seo blog content automation with GPT-4o-mini and human approval in Google Docs
Overview This n8n workflow automates the entire content creation process for SEO blog posts, from topic submission and AI drafting to human approval, revision, and final storage in Google Docs. It ensures high-quality, SEO-optimized content is generated efficiently while keeping a human in the loop for quality control. Prerequisites To use this workflow, you need the following accounts and credentials: Google Sheets Account: To manage the content tracker. The sheet must contain columns for Topic, Reference URL, Title, Status, and Link to document. OpenAI API Key (for GPT-4o-mini): To power the initial content drafting and subsequent revisions. Gmail Account: To send the content for human approval and wait for feedback. Google Docs Account: To create and store the final approved blog posts. How It Works The workflow operates in four main stages: Topic Submission, AI Content Creation, Human Approval & Revision Loop, and Final Publishing. Stage 1: Topic Submission and Tracking This stage captures a new blog topic and adds it to the content tracker. On form submission (Form Trigger): The workflow is initiated when a user submits a Topic and an optional Reference link through the form. Append row in sheet (Google Sheets): The new topic and reference link are added as a new row in your content tracker sheet. Get Topic from Google Sheets: The workflow fetches the newly added row, including the system-generated row_number for tracking updates. Stage 2: AI Content Creation (Initial Draft) The workflow uses an expert AI agent to generate the first draft of the blog post. Copywriter AI Agent: Acting as an expert SEO content strategist, the agent receives the topic and reference URL. The agent improves the provided topic into an SEO-optimized title. It writes a complete, conversational, SEO-friendly blog post (800–1200 words) using proper Markdown headings and lists. OpenAI Chat Model (GPT-4o-mini): Powers the agent's generation. Structured Output Parser: Ensures the output is in a JSON format with separate title and content keys. Set Data: The AI-generated title and content are mapped to workflow variables (Topic Title, Content) for easy use in subsequent nodes. Stage 3: Human Approval and Revision Loop This is the critical quality control step where a human reviews the draft and decides on the next action. Send Content for Approval (Gmail): The generated title and content are sent via email to the approver (<your email>). This uses a custom form that allows the user to choose Yes (Approve), No (Request Revision), or Cancel. The form also includes a Content Feedback textarea. Approval Result (Switch): The workflow pauses until the approver submits the form, and then directs the flow based on their choice. If "Yes" (Approved): Proceeds to the final publishing stage. The Update Topic Status on Google Sheets node is executed, setting the Status to Approved and logging the new Title. If "No" (Revision Requested): Proceeds to the revision loop. Copywriter Revision Agent: This agent takes the original content, the topic title, and the user's Content Feedback. It is instructed to incorporate the feedback, preserving the existing structure and tone, and outputs a revised blog post. The flow loops back through the Set Data node and then returns to the Send Content for Approval node for a new review. If "Cancel": Stops the workflow, and the Update Topic Status on Google Sheets node is executed. Stage 4: Final Publishing Once approved, the content is stored in Google Docs and the tracker is updated. Create Blog file (Google Docs): A new Google Doc is created using the approved Topic Title. Add blog content in file (Google Docs): The final Content (in Markdown format) is inserted into the newly created document. Update sheet with blog post link (Google Sheets): The final tracker update logs the Link to document and the Published date. Customization Tip Recommend using AI humanazier and AI detector tools before approval to make the SEO score better.
By Priyanka RanaAutomate lead nurturing with ChatGPT-4o & Gemini for personalized email drafting
Overview This n8n workflow automates the entire process of capturing leads, enriching their data with company information using an AI Agent, and then generating highly personalized introductory emails (using ChatGPT-4o) saved as drafts in your Gmail account. This prepares your sales team for a high-quality outreach with minimal manual effort. Requirements To use this workflow, you need the following accounts and credentials: Google Sheets Account: To store and track lead information (the workflow uses a sheet with ID). Below are the columns of the sheet First name Last name Email ID Company Name Company Information Designation Message Location Status Intro email Date Reminder 1 needed? Reminder 1 Email Date OpenAI API Key (for ChatGPT-4o): For drafting the personalized introductory emails. Google Gemini API Key: For the AI Agent to perform online company research. Gmail Account: To save the final personalized emails as drafts. How It Works The workflow is structured into two main phases: Lead Capture & Enrichment, and Personalized Email Drafting. Phase 1: Lead Capture and Enrichment This phase collects user inquiries and uses an AI Agent to search the web for additional company details to enrich the lead profile. On form submission (Form Trigger): The workflow starts when a potential lead fills out the embedded lead capture form, which collects details like First Name, Last Name, Company Name, Email ID, Designation, and a Message/inquiry. This is optional as many company may have other ways to capture leads. Append row in sheet (Google Sheets): The initial lead data collected from the form is added to your Google Sheet tracker, setting the Status to To Send. AI Agent: The AI Agent is prompted to search online for the client's company name to gather two pieces of information: A 1-2 sentence Company Description (what they do). The Company Location, categorized as Delhi/NCR, Bangalore, Mumbai, or Other. This should be changed basis your need. Code: This node processes the structured text output from the AI Agent and separates the Company Description and Company Location into distinct fields. Update row in sheet (Google Sheets): The newly researched Company Information and Location are updated and added to the lead's row in the Google Sheet, matching on Email ID. Phase 2: Personalized Email Drafting and Logging This phase retrieves leads ready for outreach, drafts a personalized email using AI, and saves it for the sales team. Get row(s) in sheet (Google Sheets): The workflow fetches all leads whose Status is either To send or To Send (using an OR filter). Introductory email (OpenAI - ChatGPT-4o): For each lead, the OpenAI node is used as a B2B marketing assistant to write a personalized introductory email based on a predefined template. The prompt uses the lead's data (First Name, Company Name, Message, etc.) and instructs the AI to: Create a subject line: Following up on your interest in <your company name> for [shorter version of pain point]. Personalize the body by referencing their pain points and suggesting how <your company> has helped similar companies. Include a call-to-action (CTA) for a quick 15-minute chat. Provide a P.S. line about a relevant success story that your company has delivered. The output is structured into EmailSubject, EmailContent, and Emailid variables. Create a draft (Gmail): The personalized email is saved as a draft in the specified Gmail account, using the AI-generated Subject and Content. Best Practice: It is recommended to add an auto-signature in the Gmail account used for the draft. Append or update row in sheet (Google Sheets): The lead's row is updated to reflect the outreach effort. The Status is set to Drafted, and the current date is logged in the Intro email Date column. Customization Notes Initial Data: You can replace the On form submission trigger with a Google Sheets Trigger or a Webhook to capture leads from other sources (e.g., a CRM or LinkedIn). AI Prompt: To ensure the best results, update the agent prompt in the Introductory email node to make it more relevant for your company. Sender: Ensure the email ID used for drafting corresponds to the sales team's email.
By Priyanka RanaB2B lead follow-up automation with Gemini AI, Gmail and Google Sheets
Overview This n8n workflow template automates your B2B marketing follow-up process. It tracks which introductory emails have received a reply, identifies leads who haven't responded within a set time, uses Gemini AI to draft a personalized, casual reminder, sends the follow-up as a reply on the original thread, and updates your lead tracker in Google Sheets. Best if used with preivously created workflow that sends an automated introductory email with templatized subject. Requirements To use this workflow, you need the following accounts and credentials: Gmail Account: To check for replies and send the reminder emails. Google Sheets Account: To manage your lead tracking spreadsheet (the workflow uses a sheet with ID). Below are the Sheet columns *First Name Last Name Email ID Company Name Company Information (optional) Designation (optional) Message - the main form enquiry Location (optional) Status (auto) Intro email Date (auto) Reminder 1 needed? (auto) Reminder 1 Email Date (auto)* Google Gemini (PaLM) API Key: For the AI Agent node to generate the personalized email content. How It Works This automation is broken down into three main stages: Stage 1: Check for Replies and Update Tracker This stage excludes leads who have already replied to your introductory email and updates the status in your tracker. When clicking ‘Execute workflow’ (Manual Trigger): The workflow starts manually or can be scheduled. Get many messages (Gmail): The node searches your inbox (CATEGORY_PERSONAL) for replies to your introductory email (using the search query subject: <template of your introductory email>). Update row in sheet (Google Sheets): For every incoming reply found, the workflow matches the lead by Email ID and updates the column Reminder 1 needed? to No. Stage 2: Identify Who Needs a Reminder This stage finds leads who have not yet received a reminder and checks if the introductory email was sent over 5 days ago. Get row(s) in sheet (Google Sheets): The workflow retrieves all leads from the tracker where the column Reminder 1 needed? is not set to No (i.e., they haven't replied and a reminder status hasn't been logged). If: A condition checks if the Intro email Date is older than 5 days (DateTime.now().minus({ days: 5 })). Only leads that meet this age criteria are passed forward. Stage 3: Send Personalized Reminder and Final Update For eligible leads, the AI generates a follow-up, finds the original email thread, sends the reply, and logs the action. AI Agent: The AI Agent acts as a B2B marketing assistant to write a short, friendly first reminder email. It uses lead data (First Name, Company Name, Message) to personalize the content, referencing the original introductory email and the client's pain point. Note: The AI is instructed to format its output into ClientEmail and ClientEmailBody using the Structured Output Parser. Edit Fields (Set): The structured output from the AI is mapped to workflow fields. Get many messages1 (Gmail): The workflow searches the SENT label for the original email using the client's email and the introductory subject line to find the correct threadId and messageId. Reply to a message (Gmail): The personalized body is sent as a reply on the original thread to maintain context. Update row in sheet1 (Google Sheets): The final step updates the lead's row in the tracker, setting Status to Reminder 1 Drafted, Reminder 1 needed? to Yes, and recording the current date in the Reminder 1 Email Date column. Customization Currently it has option to send first reminder. This can be extended to add another reminder. Write to priyanka@buildmyaiflow.agency for more customizations.
By Priyanka Rana