Skip to content
FlowHubFluxonLab

Code workflow'ları

78 sonuç — tümü kaynağa bağlı n8n referansı

CgmailsheetsW
free

Create purchase orders from Google Sheets using Groq AI and Gmail

Quick overview This workflow runs every 15 minutes to read approved, new requisitions from Google Sheets, validate supplier and policy rules, call an LLM risk-assessment API via HTTP, then create a purchase order record, update requisition status, write audit logs, and notify the procurement team via Gmail. How it works Runs every 15 minutes on a schedule. Reads requisitions from Google Sheets and keeps only rows where ApprovalStatus is "Approved" and ProcessingStatus is "New". Looks up each requisition’s supplier in a Google Sheets supplier master sheet and merges the supplier details into the requisition. Stops processing for items that don’t meet the duplicate/eligibility criteria, and validates supplier status, contract status, compliance, and max spend limit. For validated requisitions, sends the requisition and supplier details to an LLM risk-assessment endpoint via HTTP and parses the JSON decision, risk score, and reason. Generates a purchase order number, appends the purchase order to a Google Sheets Purchase_Orders sheet, updates the requisition to "Processed", logs the outcome to an Audit_Logs sheet, and emails the procurement team via Gmail. For failed validations, appe

WeblineIndia tarafından
CgmailW
free

Send a daily AI-ranked news brief with Anthropic Claude and Gmail

Quick Overview This workflow runs every morning to fetch recent articles from 50+ curated RSS/Atom feeds, uses Anthropic Claude to rank and rewrite the most relevant items based on your interests, then sends a category-grouped HTML news brief to you via Gmail. How it works Runs daily on a schedule trigger. Reads your configured categories, interests, and look-back window, then expands them into a list of RSS/Atom feed URLs. Fetches each feed over HTTP and parses, tags, de-duplicates, and filters articles to keep only recent items within the time window. Sends the curated article pool to Anthropic Claude to remove noise, select the top stories across categories, rewrite headlines, and assign importance scores. Formats the ranked picks into an HTML brief grouped by category with links and one-line rationales. Emails the brief to your target address using Gmail. Setup Add an Anthropic API key and set it in the workflow configuration so the HTTP request to Anthropic can authenticate. Connect a Gmail account credential for sending email. Update the configuration values for categories, interests, delivery email address, and limits (hoursBack, perFeed, maxItems, topN). Adjust the schedule

Nocode Expert tarafından
CgmailsheetsW
free

Create human-reviewed personalized PDFs from Stripe payments using OpenAI

Quick overview This workflow receives Stripe payment webhooks, looks up the customer’s order in Google Sheets, generates personalized HTML content with OpenAI, converts it to a PDF using PDFShift, then queues the request for human approval and delivers the final document via Gmail with Slack notifications. How it works Receives a Stripe payment notification via a webhook endpoint. Extracts payment details (event type, payment ID, customer email, amount, currency) and stops the main flow if the email is missing. Pulls order rows from Google Sheets and matches the order to the payer’s email. Sends the combined payment and order data to the OpenAI Chat Completions API to generate structured personalized content, then renders it into an HTML document. Converts the HTML to a PDF with PDFShift and sends the customer an acknowledgement email via Gmail. Appends the request to a Google Sheets “ReviewQueue” and notifies staff in Slack with instructions to approve via a separate webhook. When an approval webhook is received and marked approved, emails the final message to the customer via Gmail and updates the “ReviewQueue” status in Google Sheets. Setup Create and configure two webhook URLs

Naveen Choudhary tarafından
Cgmailgoogledrive
free

Save starred Gmail emails as Markdown notes to an Obsidian Google Drive folder

Quick overview This workflow runs daily, finds starred Gmail emails that are not yet labeled as saved, converts each email into a Markdown note with YAML frontmatter, uploads the note to a Google Drive folder synced with your Obsidian vault, and then labels the email to prevent duplicates. How it works Runs every day at 7am on a schedule trigger. Searches Gmail for emails matching your query (default: starred) while excluding messages already labeled obsidian-saved. Converts each matching email into a Markdown file with YAML frontmatter (title, from, date, tags) and the email body, using a date-prefixed, filesystem-safe filename. Processes emails one at a time to avoid rate limits and ensure reliable saves. Creates a .md file in the selected Google Drive folder using the generated filename and Markdown content. Adds the obsidian-saved label to the original Gmail message so it is skipped in future runs. Setup Add Gmail OAuth credentials and ensure your account has access to read messages and apply labels. Add Google Drive OAuth credentials and select the destination Drive and folder ID where your Obsidian vault syncs (for example, a folder inside your vault). Create a Gmail label na

43 Sunsets tarafından
CgmailsheetsW
free

Recover Shopify abandoned carts and send weekly reports via Gmail and Sheets

Quick overview This template automates Shopify abandoned cart recovery with a 3-email Gmail sequence, tracks recoveries in Google Sheets via Shopify “order paid” webhooks, and sends a weekly HTML performance report every Monday using data aggregated from the same spreadsheet. How it works Receives a Shopify “checkout created” webhook, verifies the checkout includes an email address, and skips customers who already have an active recovery sequence logged in Google Sheets. Logs the abandoned checkout details to Google Sheets and waits one hour before checking Shopify Orders for a paid purchase by the same email. If no paid order exists, sends the first recovery email via Gmail and updates the Google Sheets row to mark Email 1 as sent. After another 23 hours, checks Shopify Orders again and, if still unpaid, sends the second recovery email via Gmail and updates Google Sheets. After another 48 hours, checks Shopify Orders again and, if still unpaid, creates a unique one-time Shopify discount (price rule + discount code) and sends the third email via Gmail, then stores the discount code and Email 3 status in Google Sheets. Receives a Shopify “order paid” webhook, looks up the customer i

Muhammed Umar tarafından
Cgmailsheets
free

Export Google Sheets to CSV or Excel and email files with Gmail

Quick Overview This workflow collects a Google Sheet ID and export preferences via an n8n Form, reads the selected tab from Google Sheets, converts the rows to CSV or Excel (XLSX), and sends the generated file as a Gmail attachment to the requester. How it works Receives a request through an n8n Form that asks for an email address, Google Sheet ID, optional tab name, export format (CSV or XLSX), and an optional file name. Reads the rows from the specified Google Sheets document and tab. Validates the email and Sheet ID, checks that the sheet contains data, and attaches export metadata (format, filename, MIME type, row count) to the items. Routes the run based on the selected format to generate either an XLSX file or a CSV file. Sends an email via Gmail to the provided address with the exported file attached. Setup Connect a Google Sheets OAuth2 credential with access to the spreadsheets you want to export. Connect a Gmail OAuth2 credential for the account that sends the export emails. Activate the workflow and share the form URL, then ensure requesters provide the correct Sheet ID and (if used) the exact tab name.

isaWOW tarafından
Cgmailsheets
free

Export Google Sheets data to CSV or Excel and send via Gmail

Quick Overview This workflow collects a Google Sheet export request via an n8n Form, reads the requested tab from Google Sheets, converts the data to CSV or Excel, and emails the generated file to the requester using Gmail. How it works Receives a sheet export request through an n8n Form that captures the Google Sheet ID, optional tab name, desired format (CSV or XLSX), output file name, and recipient email address. Reads the rows from the specified Google Sheets document and tab. Validates the inputs, stops with an error if the email or Sheet ID is invalid, and aborts if the sheet is empty or the tab name is incorrect. Routes the data to either a CSV or XLSX conversion based on the selected export format. Generates the file (CSV or Excel) from the sheet rows and attaches it to an email. Sends the exported file to the user via Gmail, including basic details like file name, format, row count, and the source Sheet ID. Setup Connect a Google Sheets OAuth2 credential with access to the spreadsheets you want to export. Connect a Gmail OAuth2 credential for sending emails and confirm the sender name and email settings. Activate the workflow and share the source Google Sheets with the con

isaWOW tarafından
CgmailsheetsW
free

Generate and email invoice PDFs from Google Sheets with PDFMunk and Gmail

Quick overview This workflow watches a Google Sheets order sheet for new invoice rows, generates a unique invoice number, appends the normalized record to another sheet, converts an HTML invoice into a PDF via PDFMunk, and emails the PDF to the client using Gmail. How it works Triggers when a new row is added to a specified Google Sheets worksheet. Maps the incoming columns (client details, item, quantity, price, due date, and status) into a standardized structure and generates an invoice number. Appends the invoice data, including the generated invoice number, into a second worksheet in Google Sheets. Builds an HTML invoice template and calculates totals from quantity and unit price. Sends the HTML to the PDFMunk API to generate a PDF link, then downloads the PDF file. Sends the invoice to the client via Gmail with the PDF attached. Setup Connect your Google Sheets OAuth credentials and select the correct spreadsheet and source/target worksheets for the trigger and append actions. Create a PDFMunk API key (or equivalent header auth) and add it as HTTP Header Auth credentials for the PDF generation request. Connect your Gmail OAuth2 credentials and confirm the email subject/body an

Muhammad Salman Anwar tarafından
CgmailsheetsW
free

Monitor crypto news risk with CoinDesk RSS, OpenAI, Gmail, and Google Sheets

Quick overview This workflow polls the CoinDesk RSS feed every 10 minutes, filters for crypto-related stories, checks Google Sheets to avoid duplicates, uses OpenAI to score and summarize risk, logs results to Google Sheets, and sends Gmail alerts when the risk priority is HIGH or MEDIUM. How it works Polls the CoinDesk RSS feed every 10 minutes and retrieves the latest articles. Extracts each article’s title, description, link, and publish date, generates an article ID, and filters to only crypto-relevant items using a keyword match. Checks a Google Sheets “Seen Articles” tab to skip any article IDs that have already been processed. Sends the article text to the OpenAI Chat Completions API to return a JSON risk assessment including summary, coins, risk level, score, and recommended action. Parses the OpenAI response, normalizes the risk level into a HIGH/MEDIUM/LOW priority, and appends the article ID to the “Seen Articles” tab and the full analysis to a “Risk Log” tab in Google Sheets. Sends a formatted Gmail alert email for articles marked HIGH or MEDIUM priority. Setup Add an OpenAI API credential (OpenAI API) for the HTTP request to the Chat Completions endpoint. Create a Goog

isaWOW tarafından
CgmailsheetsW
free

Screen, score and route job applicants with Gemini, Gmail, Sheets and Slack

Quick Overview This workflow runs daily to pull job applicants from Google Sheets, score each candidate against role requirements using the Google Gemini API, log results back to Google Sheets, and notify a Slack channel when an applicant meets or exceeds a minimum score. How it works Runs every day at 08:00 on a schedule. Reads applicant records from an “Applicants” tab in Google Sheets. Combines the job title, requirements, and each applicant’s resume text into a screening prompt. Sends the prompt to the Google Gemini API and requests a JSON response with score, verdict, strengths, gaps, and summary. Parses the returned JSON and normalizes the screening fields (score, verdict, strengths, gaps, and summary). Appends the screening result for every applicant to a “Screening” tab in Google Sheets. Posts a formatted message to a Slack channel when the applicant’s score is greater than or equal to the configured minimum score. Setup Connect credentials for Google Sheets OAuth, Google Gemini (PaLM) API, and Slack OAuth. Select your Google Sheets spreadsheet and ensure it has an “Applicants” sheet with fields like Name, Email, and Resume/ResumeText, plus a “Screening” sheet to store resu

Oka Hironobu tarafından
CgmailsheetsW
free

Triage and route support emails with Gemini, Gmail, Sheets and Slack

Quick Overview This workflow monitors unread Gmail support emails, uses Google Gemini to classify and summarize each message and draft a reply, logs the ticket details to Google Sheets, creates a Gmail draft response, and sends a Slack alert when the ticket is marked high priority. How it works Triggers every minute when a new unread email arrives in Gmail. Adds brand context and support guidelines, then builds a prompt that asks Google Gemini to return a JSON classification, priority, summary, and suggested reply. Sends the prompt to the Google Gemini API and parses the returned JSON into structured ticket fields. Appends the ticket details (sender, subject, category, priority, summary, and suggested reply) to a Google Sheets tab. Creates a Gmail draft reply in the original thread using the suggested response text. Sends a Slack message to a chosen channel when the ticket priority is high. Setup Connect credentials for Gmail, Google Gemini (PaLM) API, Google Sheets, and Slack. Update the brand name and support guidelines values used to guide Gemini’s response. Select the target Google Sheets spreadsheet and the “Tickets” sheet (and ensure your header columns match the fields you w

Oka Hironobu tarafından
CgmailsheetsW
free

Handle NPS survey responses with OpenAI, Gmail, and Google Sheets

Quick Overview This workflow runs every 6 hours to read new NPS survey responses from Google Sheets, generates a personalized reply with OpenAI, and sends the email via Gmail. It then routes promoters, passives, and detractors for follow-up actions and marks each response as processed. How it works Runs on a schedule every 6 hours. Reads NPS responses from a Google Sheets tab and keeps only rows where Status equals "new". Validates required fields, parses the 0–10 NPS score, and classifies each response as Promoter, Passive, or Detractor. Sends the response context to OpenAI (Chat Completions) to generate a concise, personalized email body and builds a segment-specific subject line. Sends the personalized reply to the respondent using Gmail. For promoters, appends the comment as a quote to a separate Google Sheets testimonials tab and updates the original row’s Status to "Processed". For passives, updates the original Google Sheets row’s Status to "Processed", and for detractors, emails an alert to a support inbox via Gmail and then updates Status to "Processed". Setup Add credentials for Google Sheets, Gmail, and OpenAI in n8n. Replace YOUR_NPS_SHEET_ID with your Google Sheets doc

Incrementors tarafından
CgmailsheetsW
free

Handle NPS survey replies and routing with OpenAI, Gmail, and Google Sheets

Quick Overview This workflow runs every 6 hours to read new NPS responses from Google Sheets, uses OpenAI to draft a personalized reply, sends it via Gmail, routes respondents by NPS segment, logs promoter quotes back to Google Sheets, alerts support on detractors, and marks each row as processed. How it works Runs on a schedule every 6 hours and reads NPS response rows from a Google Sheets document. Filters the sheet to keep only rows where Status equals “new” to avoid reprocessing. Validates required fields, parses the 0–10 NPS score, and classifies each response as Promoter, Passive, or Detractor. Calls the OpenAI Chat Completions API to generate a warm, personalized email body based on the score segment and the customer’s comment. Sends the generated reply to the customer via Gmail and then routes the workflow by segment. For promoters, appends the customer comment as a quote to a “promoter-quotes” tab in Google Sheets and marks the original row as Processed; for passives, it marks the row as Processed. For detractors, sends an alert email to your support team via Gmail and then updates the original Google Sheets row status to Processed. Setup Create credentials for Google Shee

Incrementors tarafından
Cgmail
free

Send quote PDFs from form submissions with Acrewity and Gmail

Quick overview This workflow collects quote requests via an n8n Form, generates a styled PDF quote using Acrewity, emails it to the prospect through Gmail, and automatically sends a follow-up email after a configurable delay. How it works Receives a new quote request submission through the built-in n8n Form. Applies your company and follow-up settings (company name, sender name, quote validity, and delay) to the submission data. Builds an HTML quote that includes a generated quote number, validity date, and the requester’s details. Converts the HTML into a PDF using Acrewity and prepares it as an email attachment. Sends the quote PDF to the requester via Gmail with the quote number and validity date in the subject and body. Waits the configured number of days and then sends a Gmail follow-up email referencing the same quote. Setup Install the community node @acrewity/n8n-nodes-acrewity and add an Acrewity API credential. Add a Gmail credential with permission to send email from the account you want to use. Update the workflow configuration values (company name, sender name, quote validity days, follow-up delay days, and any notes) to match your business. Activate the workflow and s

Acrewity tarafından
Cgmailgooglebigquerygooglecloudfirestore
free

Draft personalized welcome emails for new signups with Twain, Gmail, and Slack

Quick overview This workflow receives new signup events, enriches each contact with Twain (and optionally a LinkedIn lookup), drafts a personalized welcome email in Gmail, and posts review-ready previews to Slack, with optional LinkedIn-step handoff to HeyReach. How it works Receives a new signup via a POST webhook secured with header authentication (with optional disabled schedule-based backfills from Google BigQuery or Google Firestore). Normalizes the signup fields (email, name, UID, timestamps, LinkedIn URL) and de-duplicates signups by UID across workflow executions. If the signup has no LinkedIn URL but does have an email, looks up a LinkedIn profile URL via Findymail (or other disabled provider alternatives) and merges the resolved profile back into the contact. If the contact has a usable work email or LinkedIn URL, calls the Twain Generate Sequence API to research the person and generate a personalized welcome sequence, otherwise posts a “skipped” notice to Slack. Builds a formatted draft payload and previews (email steps vs LinkedIn steps) from the Twain response, including any warning flags and a link back to the lead in Twain. If a work email is available, creates a Gma

Mohamed Yahya Chahin tarafından
Cgmailgoogledrivesheets
free

Generate and email PDF invoices from Google Sheets with Acrewity and Gmail

Quick overview This workflow watches for new order rows in Google Sheets, generates a styled HTML invoice, converts it to a PDF using Acrewity, emails the PDF via Gmail, archives it in Google Drive, and updates the order row status so successful and failed rows are clearly tracked. How it works Triggers every minute when a new row is added to the selected Google Sheets Orders worksheet. Applies your invoice settings (company name, logo URL, tax rate, currency, and email subject prefix) and builds invoice HTML from the row data. Validates required fields (including a valid customer email and a JSON array in the Items column) and writes an error message back to the sheet for invalid rows. Converts valid invoice HTML to a PDF using the Acrewity HTML-to-PDF API and turns the result into a binary file attachment. Sends the PDF invoice to the customer using Gmail. Uploads the PDF to a chosen Google Drive folder and updates the corresponding Google Sheets row with Status = Invoiced. Setup Install the community node package @acrewity/n8n-nodes-acrewity and add an Acrewity API credential. Add Google Sheets, Gmail, and Google Drive credentials in n8n. Create an Orders sheet with headers that

Acrewity tarafından
Cgmailsheets
free

Send Google review request and reminder emails with Gmail and Google Sheets

Quick overview This workflow runs daily and reads a Google Sheets job ledger to send Google review request and reminder emails via Gmail, then updates the sheet with sent dates to prevent duplicate messages. How it works Runs every day at 9am on a schedule. Loads your email templates and timing settings, then reads all rows from the selected Google Sheets document. Keeps only rows with status set to open, a valid job_date, and a customer email, and decides whether a first request (2+ days after the job) or a reminder (7+ days after the request) is due. Personalizes the subject and body with the customer details and your Google review link. Sends the appropriate plain-text email to each customer through Gmail. Updates the matching row in Google Sheets (by job_id) to stamp request_sent or reminder_sent with today’s date so the workflow never sends the same email twice. Setup Connect Google Sheets credentials and select the target spreadsheet and sheet in both Google Sheets nodes. Connect Gmail credentials for the mailbox you want to send from. Ensure your sheet has headers job_id, customer_name, customer_email, job_description, job_date, status, request_sent, reminder_sent and uses s

43 Sunsets tarafından
CgmailW
free

Send gold-silver ratio opportunity alerts with GoldAPI and Gmail

Quick overview This workflow fetches live gold (XAU) and silver (XAG) prices from GoldAPI.io, calculates the gold-silver ratio, evaluates it against buy/hold thresholds, and sends a formatted opportunity alert email via Gmail. How it works Starts manually and loads configuration values such as the GoldAPI.io key, currency, alert email, and ratio thresholds. Requests the latest gold and silver prices from GoldAPI.io and extracts the numeric price values. Combines both price results and calculates the gold-silver ratio. Compares the ratio to the configured thresholds to decide whether to signal “buy silver”, “buy gold”, or “hold”. Generates a timestamped alert message with an insight and interpretation for the selected signal. Sends the full report (prices, ratio, signal, and explanation) to the configured recipient using Gmail. Setup Create a GoldAPI.io account, copy your API key, and paste it into the workflow configuration value used by the GoldAPI.io requests. Connect a Gmail OAuth2 credential in n8n and ensure the workflow can send email from your Gmail account. Set the recipient email address, currency code (for example, INR), and your buy-silver and buy-gold ratio thresholds i

WeblineIndia tarafından
Cgmail
free

Generate and email Stripe invoice PDFs with PDFBolt and Gmail

Quick overview This workflow triggers on successful Stripe invoice payments, formats the invoice data for a PDFBolt template, generates a PDF invoice, and emails it to the customer through Gmail. How it works Triggers when Stripe emits an invoice.payment_succeeded event for a paid invoice. Extracts the Stripe invoice object, formats amounts, and maps customer and line-item fields into templateData for PDFBolt. Generates a PDF from a published PDFBolt template using the Direct endpoint and returns the file as binary data. Sends the generated PDF as an attachment in a Gmail email to the customer’s email address from the Stripe invoice. Setup Connect your Stripe account and ensure the trigger can receive invoice.payment_succeeded events. Add your PDFBolt API key from https://app.pdfbolt.com/api-keys, publish an invoice template in PDFBolt, and paste its Template ID into the PDFBolt node. Connect your Gmail account and adjust the email subject or body text if you want different wording or branding. Requirements Stripe account connected in n8n PDFBolt account and API key Published PDFBolt invoice template Gmail account connected in n8n Customization Use your own PDFBolt Template ID Matc

PDFBolt tarafından
CgmailW
free

Draft personalized pre-demo messages from demo bookings with Twain, Gmail, and Slack

Quick overview This workflow triggers on new demo bookings (webhooks or Google Calendar), uses Twain to research the prospect and generate a personalized pre-demo sequence plus an AE brief, drafts the email in Gmail, optionally queues LinkedIn steps in HeyReach, and posts everything to Slack for review. How it works Triggers when a demo booking is received via a webhook (generic, Chili Piper, or HubSpot) or when a new Google Calendar event is created. Normalizes the incoming booking payload into a consistent format, filters to demo meetings only, and de-duplicates repeat bookings across executions. If no LinkedIn URL is provided but an email exists, looks up a LinkedIn profile URL using Findymail and merges it back into the contact. If a usable work email or LinkedIn URL is available, calls the Twain API to generate contact research, an AE pre-demo brief, and a multi-step outbound sequence; otherwise it posts a “skipped” notice to Slack. Builds an email-ready draft (subject and HTML body) plus previews for email and LinkedIn steps from the Twain output. If a work email exists, creates a Gmail draft and posts the brief and draft preview to Slack (or posts a “no draft created” messag

Mohamed Yahya Chahin tarafından
Cgmail
free

Send daily Zillow new-listing digests to Gmail with ScraperAPI

Quick Overview This workflow monitors Zillow searches using ScraperAPI’s AI Parser, stores seen listings in n8n Data Tables, and emails a daily HTML digest of newly found listings via Gmail. How it works Runs on a daily 9AM schedule or manually to check for new listings across saved Zillow search URLs. Loads all search configurations from an n8n Data Table and processes them one at a time. Uses ScraperAPI AI Parser to scrape each Zillow search results page and extract listing fields like address, price, beds, baths, and URL. Filters the scraped listings against the search thresholds and compares them to previously logged ZPIDs in an n8n Data Table to identify new listings. Writes each newly discovered listing into the “seen” Data Table to prevent duplicate alerts in future runs. Retrieves all listings first seen today, builds an HTML digest grouped by search name, and sends it as a Gmail email. Setup Create n8n Data Tables access (or enable Data Tables in your n8n instance) and run the manual initialization trigger once to create and seed the zillow_searches and zillow_seen tables. Add your ScraperAPI credentials, run the “Create Parser” manual trigger once, and copy the resulting

ScraperAPI tarafından
Cgmailgooglecalendarsheets
free

Calculate litigation deadlines from intake forms with Google Calendar, Sheets, Slack and Gmail

Quick Overview This workflow collects litigation matter intake details via an n8n form, calculates limitation and procedural deadlines using a built-in rules table, then creates deadline and reminder events in Google Calendar, logs each deadline to Google Sheets, and sends a summary via Slack and Gmail. How it works Receives a submission from an n8n form with the matter details, jurisdiction, claim type, and trigger dates. Loads the configured limitation rules, procedural rules, holidays, reminder offsets, and target Google Calendar/Google Sheets/Slack/email settings. Calculates limitation and procedural due dates (and any review notes) from the provided dates, rolling deadlines off weekends/holidays and generating reminder dates. Appends each calculated deadline record to a Google Sheets register. Creates an all-day Google Calendar event for each calculated deadline and separate all-day events for each upcoming reminder offset. Posts a consolidated deadline summary to a Slack channel and emails the same summary via Gmail to the responsible lawyer (or a fallback team email). Setup Connect credentials for Google Calendar, Google Sheets, Slack, and Gmail. In the rules/settings step,

Kevin Yu tarafından
Cgmailsheets
free

Send scheduled quote follow-up emails with Gmail and Google Sheets

Quick Overview This workflow runs daily to read open quotes from Google Sheets, calculates how many days have passed since each quote was sent, and sends the appropriate 3-, 7-, or 14-day follow-up email via Gmail, then writes a sent date back to the sheet to prevent duplicates. How it works Runs every day at 9am on a schedule trigger. Loads your business details, follow-up day offsets, and email subject/body templates from a preset configuration. Reads all quote rows from a Google Sheets spreadsheet. Keeps only quotes with status set to open, calculates days since sent_date, and selects the next due follow-up (day 3, 7, or 14) that has not been sent yet. Sends a plain-text follow-up email through Gmail to each due quote’s customer using the filled template. Updates the matching Google Sheets row (by quote_id) to stamp the corresponding followup_1, followup_2, or followup_3 column with today’s date. Setup Add Google Sheets credentials, select the target spreadsheet and sheet in both Google Sheets steps (read and update). Add Gmail credentials for the mailbox you want to send follow-ups from. Create a quotes sheet with headers quote_id, customer_name, customer_email, quote_amount, s

43 Sunsets tarafından
Cgmail
free

Generate and email PDFBolt template PDFs via Gmail webhook

Quick overview This workflow receives a POST webhook payload, validates required fields, generates a PDF from a published PDFBolt template using provided template data, emails the PDF as an attachment via Gmail, and returns a JSON success or 400 error response to the caller. How it works Receives a POST webhook request containing templateData and a recipientEmail. Validates the payload, builds a safe PDF filename, and prepares the email subject and message text. Returns a 400 JSON response when required fields are missing. Sends the validated templateData to PDFBolt to render a PDF from the specified published template and returns it as binary data. Emails the generated PDF attachment to the recipient using Gmail. Responds to the original webhook request with a JSON success message including the filename and recipient email. Setup Install the PDFBolt community node and add your PDFBolt API key credentials. Create and publish a template in PDFBolt, then paste the template ID into the PDFBolt node. Connect a Gmail account in n8n with permission to send emails. Activate the workflow, copy the production webhook URL, and configure your source system to POST a JSON body that includes te

PDFBolt tarafından