Yar Malik (Asfandyar)
AI Automation Expert | AI Call Center with Voho
Templates by Yar Malik (Asfandyar)
Generate cold emails & sales letters with OpenAI GPT & Google Docs via Chat
How it works Trigger: Listens for an incoming chat message Copy Assistant: Feeds the message (plus memory) into an OpenAI Chat Model and exposes two “tools” Cold Email Writer Tool Sales Letter Tool• Tool execution: Depending on the user’s intent, the appropriate tool generates the copy • Save output: Writes the generated email or sales letter into your target document via the Update a document node Set up steps • Configure your OpenAI Chat Model credentials in n8n (no hard-coded keys!) • Add and authenticate the Simple Memory credential (to keep context across messages) • Create Google Docs (or MS Word) credentials for the Update a document node • Ensure your Chat trigger is pointing at your incoming-message endpoint • Mandatory: Drop sticky-note annotations on each tool node explaining where to enter API keys and how to tweak prompts Once everything’s wired up, send a test chat message like “Write me a cold email for a fintech startup” and watch the workflow spin up a polished draft in your document. How to use Import the workflow JSON into n8n. Configure your Chat trigger (webhook or form) to receive incoming messages. Send a chat prompt like: “Write me a cold email for a B2B SaaS offering.” The “Copy Assistant” custom GPT picks the right tool (Cold Email or Sales Letter). Generated copy is written directly into your linked Google Doc or Word document. Requirements OpenAI API Key (with Chat Completions & Custom GPTs enabled) Custom Assistant created in your ChatGPT dashboard (Assistant ID pasted into the Chat Model node) n8n instance (Cloud or self-hosted) with credentials set up for: Simple Memory (to persist context) Google Docs or Microsoft Word (for document output) Customising this workflow Tweak system and user prompts inside the Copy Assistant node to fit your brand voice. Swap in Slack, Teams or email nodes instead of a document writer to deliver copy where you need it. Add or remove tools (e.g., “Follow-up Email Writer”) by duplicating the existing tool pattern. Use sticky-note annotations on every node to explain where to enter API keys, Assistant IDs, or prompt tweaks.
By Yar Malik (Asfandyar)Task deadline reminders with Google Sheets, ChatGPT, and Gmail
Intro This template is for project managers, team leads, or anyone who wants to automatically remind teammates of tasks due today—no manual copy‑and‑paste required. How it works Schedule Trigger runs every morning at 8 AM. Google Sheets node reads your “Tasks” sheet. If node filters rows where Due Date = today. Summarize (ChatGPT HTTP Request) generates a friendly reminder per person. Message a model sends the prompt to your ChatGPT Assistant and returns the AI response. Send a message (Gmail) emails each assignee their personalized reminder. Required Google Sheet Structure | Column Name | Type | Example | Notes | |-------------|--------|---------------------------|-------------------------| | Name | string | Alice Johnson | Person to remind | | Email | string | user@example.com | Recipient email address | | Task | string | Submit quarterly report | Task description | | Due Date | date | 2025‑07‑29 | Format: YYYY‑MM‑DD | Detailed Setup Steps Google Sheets Create your sheet with the columns above. In n8n → Credentials, add Google Sheets API (do not include real sheet IDs in the name). ChatGPT Assistant In the OpenAI Dashboard → Assistants, click Create Assistant. Choose a model (e.g., gpt-4), copy the Assistant ID. In n8n → Credentials → OpenAI, add your API Key and Assistant ID. Gmail In n8n → Credentials → Gmail (OAuth2 or SMTP), connect your account without embedding your real address in the credential name. Import & Configure Export this workflow’s JSON (three‑dot menu → Export). Paste it under Template Code in the Creator form. In each node, select your Google Sheets, OpenAI, and Gmail credentials. Sticky Notes A note on the Schedule node: “Set your desired run time.” A note on the ChatGPT node: “Customizes reminder text.” A note on the Gmail node: “Sends reminder email.” Customization Guidance Change schedule: edit the Cron expression in Schedule Trigger. Adjust tone: modify the system prompt in your ChatGPT Assistant. Email format: update Subject and Body in the Gmail node. Batch processing: insert a SplitInBatches node before Summarize for large sheets. Troubleshooting Ensure your Google Sheet is shared with the connected service account. Verify Due Date format (YYYY‑MM‑DD). If ChatGPT fails, check your API key and quota. Security & Best Practices Do not hard‑code API keys, sheet IDs, or real emails. Use n8n Credentials or environment variables only. Remove any private information before submitting.
By Yar Malik (Asfandyar)Schedule daily email reminders from Google Sheets with Gmail
Intro This template is for teams, individuals, or businesses who want to automatically send daily email reminders (e.g., updates, status alerts, follow‑ups) using n8n + Gmail. How it works Cron Trigger fires every day at your specified time. Google Sheets node reads all rows from your sheet. If node filters rows matching your condition (e.g., Status = "Pending"). Send a message (Gmail) sends a customized email to each filtered row. Required Google Sheet Structure | Column Name | Type | Example | Notes | |-------------|--------|--------------------------|------------------------------------| | Email | string | user@example.com | Recipient email address | | Status | string | Pending | Filter criterion | | Subject | string | Daily Status Update | Email subject (supports variables) | | Body | string | “Please update your task”| Email body (text or HTML) | Detailed Setup Steps Google Sheets Build your sheet with the columns above. In n8n → Credentials, add Google Sheets API (avoid sensitive names). Gmail In n8n → Credentials → Gmail (OAuth2 or SMTP), connect your account. Do not include your real email in the credential name. Import & Configure Export the workflow JSON (three‑dot menu → Export). Paste it under Template Code in the Creator form. In each node, select your Google Sheets and Gmail credentials. Sticky Notes On the If node: “Defines which rows to email.” On the Gmail node: “Sends the email.” Customization Guidance Adjust schedule: change the Cron expression in Cron Trigger. Modify filter: edit the condition in the If node. Customize email: use expressions like {{$node["Get row(s) in sheet"].json["Subject"]}}. Troubleshooting Verify the Google Sheet is shared with the connected service account. Check your Cron timezone and expression. Ensure Gmail credentials are valid and not rate‑limited. Security & Best Practices Remove any real email addresses and sheet IDs. Use n8n Credentials or environment variables—never hard‑code secrets. Add sticky notes for any complex logic.
By Yar Malik (Asfandyar)Manage tasks and deadlines via WhatsApp using GPT-4 and Google Sheets
Who’s it for This template is for anyone who wants to manage tasks, deadlines, and updates directly from WhatsApp. It’s especially useful for teams, freelancers, and small businesses that track their work in Google Sheets and want quick AI-powered assistance without opening spreadsheets. How it works / What it does This workflow turns WhatsApp into your personal task manager. When a user sends a message, the AI agent (powered by OpenAI) interprets the request, retrieves or updates task information from Google Sheets, and sends a concise response back via WhatsApp. The workflow can highlight overdue tasks, upcoming deadlines, and provide actionable suggestions. How to set up Connect your WhatsApp API account in n8n. Add your OpenAI credentials. Link your Google Sheets document where tasks are stored. Deploy the workflow and test by sending a message to your WhatsApp number. Requirements WhatsApp Business API account connected to n8n OpenAI account for AI responses Google Sheets with task data How to customize the workflow Adjust the AI prompt to change tone or instructions. Modify the Google Sheets fields (Task, Status, Due Date, Notes) to match your structure. Add conditions or filters to customize which tasks get highlighted.
By Yar Malik (Asfandyar)Manage Google Sheets data with GPT-4 natural language processing & calculator
Who’s it for This template is for users who want to combine the power of AI with Google Sheets for managing and calculating data quickly. It’s ideal for small businesses, data entry teams, and anyone who tracks lists, orders, or tasks in Google Sheets and needs AI-driven insights or calculations. How it works The workflow connects an AI agent with Google Sheets and a calculator tool. When a user sends a chat message, the AI interprets the request, retrieves or updates rows in the connected sheet, and performs calculations when needed. For example, it can read a list of orders from a sheet and calculate totals or averages instantly. It also supports creating, updating, and deleting rows from the sheet through natural language instructions. How to set up Copy the provided Google Sheet into your Google Drive. Connect your Google Sheets credentials in n8n. Add your OpenAI credentials for the AI agent. Deploy the workflow and start interacting with it by sending chat prompts. Requirements OpenAI account (for AI responses) Google Sheets account with a spreadsheet n8n instance with LangChain nodes enabled How to customize the workflow Change the spreadsheet fields (ID, Name, etc.) to match your own data structure. Modify the AI prompt to guide the agent’s tone or behavior. Extend the workflow by adding more Google Sheets operations or AI tools for advanced tasks.
By Yar Malik (Asfandyar)