Google Sheets workflow'ları
70 sonuç — tümü kaynağa bağlı n8n referansı
WCreate 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
WTrack competitor pricing changes with Google Sheets, OpenAI, and Gmail
Quick Overview This workflow runs daily, checks competitor webpages listed in Google Sheets, compares the latest page text to the previous snapshot using OpenAI, stores the updated snapshot in Google Sheets, and emails a consolidated HTML change report via Gmail. How it works Runs every day at 9:00 AM on a schedule. Reads the list of competitor sites (Site ID, Site Name, URL) from a Google Sheets tab. Fetches each competitor URL and extracts the visible page text from the HTML body. Looks up the previous saved snapshot for the same Site ID in a Google Sheets “Snapshots” tab. Uses OpenAI (gpt-4o-mini) to compare previous vs current text and summarize pricing, plan, and campaign changes or return “No changes detected”. Saves the current page text and fetch timestamp back to Google Sheets (append or update by Competitor Site ID) and formats each result into an HTML table row. Aggregates all rows into a single HTML table and sends the daily report email through Gmail. Setup Create a Google Sheets file with a “Monitored Sites” tab (Site ID, Site Name, URL) and a “Snapshots” tab (Competitor Site ID, Last Fetched At, Page Text). Add Google Sheets OAuth credentials and set your spreadsheet
WCreate 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
WAnalyze compliant documents with PromptLock Guard, Claude, and Google Sheets
Quick overview Screen contracts, intake forms, and reports for HIPAA, GDPR, and PCI data — plus always-on prompt-injection detection — before Claude summarizes them. Clean documents pass through, risky ones get flagged for review or blocked, and every document gets an audit row in a Google Sheet. How it works Receives a POST request to a webhook containing either a PDF upload or a JSON body with a text field. Extracts text from PDFs or uses the provided JSON text as-is. Sends the document text to PromptLock Guard to screen for regulated-data and prompt-injection risk, failing closed on screening errors. If the document is allowed or redacted, sends the cleaned text to Anthropic Claude and returns a structured JSON analysis in the webhook response. If the document is flagged, sends a Gmail notification email for human review instead of sending the content to the AI model. If the document is blocked (or screening is unavailable), returns a JSON webhook response indicating the block/unverified reason. Appends a per-document audit row (timestamp, action taken, risk score, and compliance status) to a DocAuditLog tab in Google Sheets. Setup Install the n8n-nodes-promptlock-guard communit
WRecover 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
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.
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
WGenerate 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
WMonitor 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
WScreen, 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
WTriage 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
Deliver workflows after Stripe checkout with Gmail and Google Sheets
Quick overview This workflow listens for completed Stripe Checkout sessions, validates payment status, fetches the purchased workflow from your n8n instance, exports it as a JSON file, emails it to the buyer via Gmail, and logs the sale details to Google Sheets. How it works Triggers when Stripe sends a checkout.session.completed event for a Checkout session. Normalizes key fields from the Stripe event (buyer email, payment status, amount, session ID, and the workflow ID from client_reference_id). Verifies the event is a completed checkout session and the payment status is not unpaid. Retrieves the purchased workflow from the n8n API using the workflow ID passed through Stripe. Appends a sales record to Google Sheets with the timestamp, buyer email, amount, session ID, and workflow details. Exports the fetched workflow to a formatted JSON file and sends it to the buyer as a Gmail attachment with import instructions. Setup Add credentials for Stripe, n8n API, Gmail OAuth2, and Google Sheets OAuth2 used by the workflow. Create or select a Google Sheets spreadsheet and a Sales sheet tab, and ensure the column headers match the fields being appended (Timestamp, Workflow ID, Workflow Na
WHandle 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
WHandle 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
WCreate personalized videos from Google Sheets with iLoveVideoEditor and Gmail
Quick overview This workflow watches Google Sheets for new rows, renders a personalized video with iLoveVideoEditor using the row data, uploads the finished MP4 to Google Drive, writes the Drive link back to the same sheet row, and emails the link to the recipient via Gmail. How it works Triggers on a schedule when a new row is added to a specified Google Sheets worksheet. Skips rows where the Title field is empty. Starts a video render in iLoveVideoEditor from the cinematic-title template using the row’s Title and Subtitle as template variables. Polls iLoveVideoEditor every 60 seconds (up to 20 attempts) until the render status becomes completed, or stops early if the status becomes failed. When completed, downloads the MP4 from the render URL, uploads it to a specified Google Drive folder, and generates a shareable Drive view link. Updates the original Google Sheets row (matched by ID) with the Video URL and sends the Drive link to the row’s Email address via Gmail. If the render fails, times out, or errors, sends a failure alert email via Gmail with the row details. Setup Install the community node n8n-nodes-ilovevideoeditor (required for self-hosted n8n) and add your iLoveVideo
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
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
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,
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
WTrack positive Instagram comment sentiment with OpenAI, Google Sheets, and Gmail
Quick overview This workflow runs twice daily to fetch recent Instagram post comments via the Instagram Graph API, uses OpenAI to classify sentiment, saves new positive comments to Google Sheets, and emails an HTML digest of the day’s positive comments to your team using Gmail. How it works Runs every day at 9 AM to fetch the most recent Instagram media posts from the Instagram Graph API. Pulls up to a set number of comments per post and enriches each comment with post context like the permalink. Sends each comment to OpenAI Chat Completions to classify it as POSITIVE, NEUTRAL, or NEGATIVE with a score. Filters to keep only non-empty comments classified as POSITIVE. Checks Google Sheets for an existing row with the same Instagram comment ID to prevent duplicates. Appends new positive comments to a Google Sheets tab for later reporting. Runs every day at 8 PM to read the saved rows from Google Sheets, build a formatted HTML summary for today, and send the digest email via Gmail. Setup Create a Facebook app with Instagram Graph API access and provide a long-lived access token plus your Instagram Business Account ID in the workflow’s configuration step. Add an OpenAI API credential fo
WTrack SIP goals with OpenAI ChatGPT, Gmail and Google Sheets
Quick Overview This workflow collects SIP and mutual fund details via an n8n Form, calculates goal and performance metrics, generates a personalized advisory using OpenAI, emails a color-coded HTML report via Gmail, and appends each submission to a Google Sheets log for ongoing tracking. How it works Receives an investor submission through an n8n Form with SIP, fund, and goal details. Calculates months invested, total invested, returns, an approximate CAGR, goal completion percentage, and an estimated monthly top-up needed to reach the goal. Sends the calculated metrics to OpenAI Chat Completions to generate a structured, plain-English advisory (including ELSS 80C context when applicable). Parses the AI response with a fallback advisory if parsing fails, and assigns colors for performance, returns, and goal progress. Builds a color-coded HTML email report with KPI cards, a goal progress bar, and the advisory sections. Appends the submission and calculated metrics to a Google Sheets “SIP Log” tab and emails the report to the investor via Gmail. Setup Add an OpenAI API credential and ensure the OpenAI Chat Completions endpoint is accessible from your n8n instance. Connect Google Shee
WOnboard employees and manage Slack access with Google Sheets and Gmail
Quick Overview This workflow automates HR onboarding by capturing new hires via a webhook, saving them to Google Sheets, emailing a Slack invite via Gmail, and notifying managers in Slack, then listening for Slack team_join events to add new hires to department channels and update onboarding status. How it works Receives a POST webhook request from an HR form with new employee details and validates required fields. Appends the employee record to a Google Sheets spreadsheet and assigns a department-based list of Slack channels plus a static Slack invite link. Sends the new hire a welcome email through Gmail containing their start details and the Slack workspace invite link. Sends a Slack direct message to a manager user with the new hire details and the channels they will be added to, then updates the Google Sheets row to “Invite Sent” with a timestamp and responds to the HR form. Receives Slack Events API requests for the workspace and replies to url_verification challenges or immediately acknowledges real team_join events within 3 seconds. Extracts the joining user’s Slack ID and email, looks up the matching employee row in Google Sheets, and resolves the department’s target chann
Register event attendance via webhook with Google Sheets and Gmail
Quick overview This workflow powers a QR code-based event attendance system. A presenter displays a QR code (generated via the companion web app) which participants scan with their phones. Scanning opens a registration form pre-filled with the Event ID; on submission, the form POSTs to this webhook. How it works Receives a POST request via a webhook secured with Basic Auth. Validates the request body (name, email format, and optional role/event/day) and generates a timestamp plus a target Google Sheets tab name. If validation fails, returns an error JSON response to the caller. Reads all existing rows from the Google Sheets tab for the selected day and checks whether the email address is already registered. If the email is a duplicate, returns an “already registered” JSON response. If the email is new, appends the attendee details to Google Sheets, sends a confirmation email through Gmail, and returns a success JSON response. Setup Configure the webhook Basic Auth credentials and share the webhook URL with the form/app that submits attendance data. Add Google Sheets OAuth2 credentials and update the spreadsheet ID and ensure each day has a matching tab name (for example, “Day 1” ma
WExplain prescription PDFs for patients with GPT-4o-mini, Gmail and Google Sheets
Quick overview This workflow collects a patient’s prescription PDF via an n8n form, extracts its text, uses OpenAI (gpt-4o-mini) to generate a plain-language medicine-by-medicine explanation in the chosen language, emails the result via Gmail, and logs each processed prescription to Google Sheets. How it works Receives a form submission with the patient’s name, email, preferred language, optional doctor/health notes, and a prescription PDF upload. Extracts selectable text from the uploaded PDF. Validates required fields, checks that the PDF contains readable text, and truncates/cleans the extracted content for the AI prompt. Sends the prescription text and context to OpenAI Chat Completions (gpt-4o-mini) and requests a structured JSON explanation of each medicine in the selected language. Parses and validates the returned JSON, ensuring at least one medicine is found and merging the AI output with the patient context. Appends an audit row (date, patient details, doctor, medicine count, language, status, processed time) to a Google Sheets “Log” worksheet. Builds a formatted HTML email with the medicine explanations and disclaimer, then sends it to the patient using Gmail. Setup Add