Gmail workflow'ları
2.590 sonuç — 304 indirilebilir workflow dosyası, 2.286 kaynağa bağlı n8n referansı
Send daily product newsletters via Gmail and track events in Google Sheets
Quick overview This workflow sends a daily product newsletter from Google Sheets via Gmail and tracks opens, clicks, and unsubscribes through an n8n webhook, logging all events back to Google Sheets. How it works Runs every day at 08:00 (configured in the Schedule Trigger). Reads products from Google Sheets and keeps only rows whose send_date matches today. If there are products to send, builds an HTML newsletter with a per-campaign newsletter ID, tracked click URLs, a tracking pixel, and an unsubscribe link, and logs the newsletter contents to Google Sheets. Reads recipients and the unsubscribe list from Google Sheets, removes unsubscribed addresses, and personalizes the newsletter HTML for each recipient by inserting their email and the campaign ID into tracking links. Sends each personalized email via Gmail and appends a “sent” event to the Google Sheets tracking log. Receives open, click, and unsubscribe requests on a webhook endpoint, routes by event type, and logs the event to Google Sheets. For clicks and unsubscribes, filters likely bot/duplicate requests (user-agent checks and recent-event deduping), then redirects to the product URL or returns an unsubscribe confirmation
Detect duplicate Google Drive files and log results to Google Sheets
Quick overview This workflow manually scans a specified Google Drive folder for duplicate and near-duplicate filenames, appends the results to a Google Sheets log, and optionally sends a single Gmail notification when duplicates are found. How it works Runs when you click “Execute workflow” in n8n. Reads the target Google Drive folder ID from the configuration values and retrieves all files in that folder with key metadata (name, size, timestamps, link, and MIME type). Analyzes the file list to detect exact duplicates (same filename) and near-duplicates (common copy/version naming patterns) and assigns a recommended action such as KEEP, DELETE, or REVIEW. If duplicates are found, appends one row per flagged file to a Google Sheets tab and sends a single Gmail notification that the scan needs review. If no duplicates are found, appends a single “NONE FOUND” scan record to Google Sheets to maintain an audit trail. Setup Connect your Google Drive OAuth2 credentials so the workflow can list files in the target folder. Connect your Google Sheets OAuth2 credentials and set the spreadsheet ID in the configuration values, and ensure the target tab (for example, “Sheet1”) has matching colum
Manage inventory reorders with Google Sheets, Slack, and Gmail
Quick overview Youtube Video: https://www.youtube.com/watch?v=y0uCepHhwSA This workflow monitors inventory from Google Sheets on a schedule, calculates reorder quantities using vendor lead times, logs pending reorders back to Google Sheets, and posts grouped reorder requests to Slack, then sends vendor reorder emails via Gmail when an authorized Slack user approves. How it works Runs on a schedule and reads product inventory and vendor catalog data from Google Sheets. Calculates stock runway and a reorder quantity per product using recent sales and vendor average delivery time. Filters to only items that need reordering and aggregates reorder lines into a vendor-level request. Checks the existing reorder log in Google Sheets to avoid reordering items that are pending/sent or were completed within the last 14 days, then groups remaining items by vendor. Writes each vendor reorder request to a Google Sheets reorder log with status set to pending and posts a formatted restock notification to a Slack channel. Triggers on a Slack reaction event, verifies the reacting user matches the configured approver, extracts the Reorder ID from the Slack thread, and looks up the matching row in Goo
WPublish weekly SMB blog posts with Perplexity, Claude, Gemini, Supabase, and Gmail
Quick overview This workflow runs weekly to generate, research, write, illustrate, and publish a new blog post by combining Supabase (content + storage), Perplexity (topic + research), Anthropic Claude (writing), Google Gemini (cover image), and Gmail (notification). How it works Runs every Friday at 10:00 (cron: 0 0 10 * * 5). Fetches titles of already published posts from Supabase and builds a rotating topic focus that avoids repeating prior angles. Uses Perplexity to propose one fresh, SEO-relevant blog topic and then research it with trends, examples, and SMB-focused insights. Sends the topic and research notes to Anthropic Claude to write a complete post with title, excerpt, meta description, category, read time, and HTML body. Parses the generated text into structured fields, generates a slug, and prepares a published blog post record. Uses Google Gemini to generate a 16:9 cover image, uploads it to Supabase Storage, and attaches the public cover image URL to the post. Inserts the finished post into the Supabase blog_posts table with status set to published and emails the team via Gmail with the publication details. Setup Create a Supabase project with a blog_posts table and
Send appointment reminders from Google Sheets via Gmail and Slack
Quick Overview This workflow runs daily at 9:00, reads appointments from Google Sheets, emails next-day patients reminders via Gmail, and posts a reminder count to a Slack channel. How it works Runs every day at 9:00 using a schedule trigger. Reads all appointment rows from a specified Google Sheets worksheet. Filters the rows to keep only appointments whose Date matches tomorrow’s ISO date (YYYY-MM-DD). Sends a personalized reminder email for each remaining appointment using Gmail. Counts how many reminders are sent and generates a summary payload for tomorrow’s date. Posts the reminder count summary to a selected Slack channel. Setup Connect Google Sheets OAuth and set the target spreadsheet and sheet, ensuring columns like Patient, Email, Date, and Time exist. Ensure the Date values in Google Sheets are stored in a format compatible with the filter logic (ISO-style YYYY-MM-DD at the start of the field). Connect Gmail OAuth and update the sender account, subject, and message text as needed. Connect Slack OAuth and select the channel where the front desk summary should be posted.
Capture real estate leads with Google Sheets, Gmail, and Slack
Quick Overview This workflow captures real estate property inquiries via a webhook, saves the lead to Google Sheets, sends an auto-reply email through Gmail, and posts a notification to a Slack channel before returning a JSON confirmation to the website. How it works Receives a POST request from your website form through a webhook endpoint. Extracts and standardizes the lead details (name, email, phone, property ID, and message) from the incoming request. Appends the inquiry details to a Google Sheets CRM spreadsheet. Sends an acknowledgement email to the prospect using Gmail with the referenced property details. Posts a new-lead alert to your agent team in Slack. Returns a JSON response (for example, { "status": "received" }) to confirm the submission was accepted. Setup Connect Google Sheets OAuth credentials and update the target spreadsheet and sheet tab used to store new leads. Connect Gmail OAuth credentials and customize the subject/body of the auto-reply message. Connect Slack OAuth credentials and choose the channel where agent notifications should be posted. Copy the webhook URL from the webhook trigger and configure your website inquiry form to send a POST request with n
Log ecommerce orders, send Slack alerts, and store data in Google Sheets
Quick Overview This workflow receives ecommerce orders via a webhook, formats key order fields, appends each order to Google Sheets, and posts a Slack notification to different channels based on whether the order total exceeds 200. How it works Receives a POST webhook request containing a new order payload from your store. Extracts and normalizes the order ID, customer name, email, total, and items from the webhook body. Appends the order data to a Google Sheets spreadsheet for logging and reporting. Compares the numeric order total to a 200 threshold to determine whether the order is high value. Posts a message to a Slack VIP channel for orders over 200, or to a standard Slack orders channel for all other orders. Returns a JSON confirmation response (including the order ID) back to the webhook caller. Setup Configure your store to send new order events to this workflow’s webhook URL (POST /new-order). Add a Google Sheets OAuth2 credential and set the target spreadsheet and sheet where orders should be appended. Add a Slack OAuth2 credential and set the channel IDs for the VIP and standard order notifications. Adjust the high-value threshold (currently 200) to match your order rout
PG&E Daily Cost Tracker — Gmail
On a daily schedule, scrapes PG&E billing data with Airtop and emails the cost summary via Gmail.
Scheduled Gmail Digest
On a schedule, fetches Gmail messages, filters them, and compiles them into a list.
HubSpot Workflow — Gmail
On a Typeform submission, updates HubSpot contacts and sends a conditional follow-up email via Gmail.
Forward Netflix Emails to Multiple Email Addresses with Gmail and Mailjet
On a new Netflix email in Gmail, forwards it to multiple recipients via Mailjet.
RSS, Gmail & Todoist Sync
On a schedule, reads new RSS items, emails them via Gmail, and creates matching Todoist tasks.
n8n Node Update Email Check
When triggered by another workflow, checks n8n for node updates and emails the findings via Gmail.
Send Gmail Message
On manual run, builds a message and sends it via Gmail.
Batch Process Gmail Messages
On manual run, fetches Gmail messages and processes them in batches.
Get Messages with a Certain Label, Remove the Label, and Add a New One — Gmail
On manual trigger, fetches Gmail messages with a given label, removes that label, and applies a new one.
RSS + Trello + Gmail Automation
On a schedule, reads an RSS feed, filters and sorts items, creates Trello cards, and emails a digest via Gmail.
DeepSeek v3.1 — Gmail
On a new Notion item, runs an AI agent that sends Gmail messages and publishes WordPress posts via MCP tools.
Gmail MCP Server
Run manually, exposes Gmail actions as tools for an MCP server to send and manage email.
Gmail Tool for AI Agent
Runs manually to perform Gmail send and read actions exposed as an AI agent tool.
RSS + Gmail Automation
On a schedule, reads RSS feeds in batches and emails new matching items via Gmail.
Gmail to Vector Embeddings with Pgvector and Ollama
On new Gmail emails, processes messages in batches, generates embeddings, and stores them as vectors in Postgres.
Clearbit-Enriched Gmail Responder
On form submission, enriches the contact via Clearbit and sends a conditional Gmail email based on the result.
RSS to Jira Issue Creator
On manual run, reads an RSS feed, filters items, creates Jira issues, and sends Gmail notifications.