Code Workflows
78 Ergebnisse — ausschließlich quellenverknüpfte n8n-Referenzen
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
Manage clinic appointments and prescriptions with Telegram, Gmail and Google
Quick overview This workflow manages clinic appointments across Google Sheets and Google Calendar, using webhooks and Telegram to book and confirm visits, Gmail and Telegram to deliver prescriptions, scheduled Telegram reminders for upcoming appointments, and Slack notifications for workflow errors. How it works Receives a POST webhook request to book an appointment, generates a Booking ID, stores the booking in Google Sheets, and notifies the doctor via Telegram. Triggers when a patient messages your Telegram bot, extracts the Booking ID from the message, and replies with instructions if the ID is missing or invalid. When the Booking ID is valid, updates the matching Google Sheets row to Confirmed, sends a confirmation message to the patient on Telegram, and creates a Google Calendar event. Reads the confirmed appointment details from Google Sheets and sends the full patient and appointment information to the doctor via Telegram. Receives a POST webhook request with post-visit prescription details, updates the matching Google Sheets row to “Prescription Sent,” emails the prescription link and medicines to the patient via Gmail, and sends the same details via Telegram. Runs every h
Generate, email, and archive PDFs from HTML with PDFBolt, Gmail, and Google Drive
Quick overview This workflow receives an HTML payload from an n8n webhook, validates it, converts HTML to PDF with PDFBolt, emails the PDF through Gmail, archives it in Google Drive, and returns a JSON response with success or error details. How it works Receives HTML and delivery details through an n8n webhook. Validates required fields and prepares the filename, email subject, and message. Returns a 400 JSON error response if html or recipientEmail is missing. Converts HTML to PDF with PDFBolt using the Direct endpoint. Sends the generated PDF as an email attachment through Gmail to the specified recipient. Uploads the same PDF binary file to a chosen Google Drive folder for archiving. Returns a JSON success response to the webhook caller with the recipient email and filename. Setup Install the PDFBolt community node and add your PDFBolt API key from https://app.pdfbolt.com/api-keys. Add Gmail credentials in n8n for sending emails. Add Google Drive credentials in n8n and select the target Drive and folder for archiving. Activate the workflow and copy the Production webhook URL into the app or script that will POST the HTML payload. Requirements PDFBolt account and API key Gmail a
WSend railway queue predictions with OpenAI GPT-4o-mini, Gmail, and Google Sheets
Quick overview This workflow collects train trip details via an n8n Form, predicts station crowding and queue times with a rule-based algorithm, generates a short advisory with OpenAI, then emails a color-coded HTML alert via Gmail and logs each prediction to Google Sheets. How it works Receives a submission from an n8n Form containing the traveler’s train, station, date/time, class, e-ticket status, passenger count, and email. Calculates a crowd score, alert level, queue-time breakdown (platform, ticket counter, security, walking), and an optimal station arrival time using an in-workflow rules engine. Sends the prediction context to OpenAI Chat Completions (gpt-4o-mini) to generate a plain-text, under-120-word travel advisory. Combines the advisory with the prediction results and assigns alert colors and text based on the computed alert level. Builds a color-coded HTML email summarizing the recommended arrival time and queue breakdown. Appends the prediction details to a Google Sheets tab and sends the HTML alert email to the traveler via Gmail. Setup Add an OpenAI API credential for the HTTP request to https://api.openai.com/v1/chat/completions. Connect Google Sheets OAuth2 and r
WSend AI study reports and spaced-repetition reminders via OpenAI, Sheets and Gmail
Quick overview This dual-trigger workflow logs daily study sessions from an n8n Form, analyzes them with OpenAI, stores results in Google Sheets, and emails a full coaching report via Gmail; it also runs daily at 7 AM to email each student revision reminders based on spaced-repetition dates. How it works Receives a study-session submission through an n8n Form. Validates the submitted fields and calculates spaced-repetition revision dates (Day+1, +3, +7, +14). Sends the session details to OpenAI Chat Completions and parses the returned JSON coaching analysis (score, feedback, plan, and quiz). Reads the existing Google Sheets Daily Log to find any prior sessions for the same student that are due for revision on the submitted date. Builds an HTML email combining the AI report, today’s revision-due items, and the new revision schedule, then appends the new session to Google Sheets. Sends the full daily study report to the student via Gmail. Runs every day at 7 AM, reads all Google Sheets logs, finds revision items due today per student, and emails each student a morning revision reminder via Gmail. Setup Add an OpenAI API credential and ensure the Chat Completions request is authorized
W
Process signed DocuSign contracts with Supabase, Claude, Stripe, Outlook and Gmail
Quick overview This workflow listens for DocuSign Connect envelope-completed events, looks up the related assessment in Supabase, updates contract and client records, sends a welcome email (optionally drafted with Anthropic), creates an onboarding session and invite, and for non-pilot clients creates a Stripe Checkout payment link and emails it. How it works Receives a POST webhook from DocuSign Connect and continues only when the envelope status indicates the contract is completed. Queries Supabase for the assessment record matching the DocuSign envelope ID and normalizes the returned data to a single assessment object. Updates the assessment in Supabase to mark the contract as completed, upserts a client record in Supabase, and calls an internal webhook to fetch the signed contract. Sends either a pilot welcome email or a standard welcome email via Microsoft Outlook, with the standard email body drafted by Anthropic and optionally logged to a separate cost-tracking workflow. Generates a resume token, creates an onboarding session in Supabase, waits 24 hours, then sends the onboarding questionnaire invite via Microsoft Outlook and emails an internal notification via Gmail. For non
Capture and route real estate leads with Google Sheets, Gmail, and Slack
Quick overview This workflow captures real estate property inquiries via a webhook, validates and normalizes lead details, upserts the lead into Google Sheets, sends an auto-reply through Gmail, and notifies your team in Slack, with separate handling for high-priority leads and workflow failure alerts. How it works Receives a website property inquiry via a POST webhook. Extracts the lead fields (name, email, phone, property ID, message, source, and timestamp) and rejects invalid submissions with a 400 JSON response explaining what’s missing. Normalizes the lead data by lowercasing the email address and stripping non-numeric characters from the phone number. Classifies the inquiry as high or standard priority based on keywords found in the message and property text. Appends or updates the lead in a Google Sheets CRM table, matching on email to avoid duplicates. Sends a Gmail auto-reply and posts a Slack notification, routing high-priority leads to a senior-agent message and standard leads to the general team. Returns a JSON confirmation to the webhook caller and posts a Slack alert if the workflow errors. Setup Copy the webhook URL from the trigger and configure your website form/ap
WCapture and log email trade instructions with Gmail, OpenAI, and Google Sheets
Quick overview This workflow polls Gmail for emails with the subject “Trade Instruction”, uses OpenAI Chat Completions to extract trade fields from the email body, logs valid and failed extractions to separate tabs in Google Sheets, and sends confirmation and ops alert emails via Gmail. How it works Triggers every minute by polling Gmail for new messages matching the query subject:"Trade Instruction". Extracts the email body, sender address, subject, and message/thread IDs and generates a trade reference and timestamps. Sends the email body to OpenAI (Chat Completions) to return a JSON object containing asset, ticker, action, quantity, price, client, and notes. Parses the returned JSON, validates that asset is present and quantity is greater than zero, and marks the result as valid or failed with a reason. Appends valid trade instructions to the “Valid Trades” tab in Google Sheets, or appends failures (including a snippet and error reason) to the “Failed Trades” tab. For valid trades, replies to the original email in Gmail with a receipt confirmation and emails the ops team a capture notification, and for failed trades, emails the ops team a manual-review alert with the original em
Send portfolio contact form notifications and confirmations with Gmail
Quick overview This workflow receives portfolio contact form submissions via a webhook, normalizes the fields, generates branded HTML emails, and uses Gmail to send an admin notification plus an automated confirmation to the visitor before returning a success JSON response to the website. How it works Receives a POST request from your website contact form via an n8n webhook. Normalizes the incoming payload into consistent fields (name, email, subject, message, timestamp). Builds two branded HTML emails and subjects: one for the admin notification and one for the visitor confirmation. Sends the admin notification email with the submitted details using Gmail. Sends the visitor a confirmation email using Gmail. Returns a 200 JSON response (success/message) to the website so the form can show a confirmation. Setup Connect a Gmail OAuth2 credential for the two Gmail send steps. Replace the hardcoded admin recipient address in the admin notification email step. Copy the Production Webhook URL generated by your automation platform and configure your website's contact form to send a POST request to this endpoint whenever a user submits the form. Ensure that the request includes all the req
WExtract and validate invoice PDFs with OpenAI, Google Sheets, and Gmail
Quick overview This workflow collects an invoice PDF via an n8n Form, extracts text from the PDF, uses OpenAI to convert it into structured invoice JSON, logs invoice headers and line items to Google Sheets, validates totals, and emails a formatted extraction report via Gmail. How it works Receives an invoice submission through an n8n Form that includes the uploader’s name, email address, currency, notes, and a PDF file. Extracts text content from the uploaded PDF. Sends the extracted text to OpenAI (Chat Completions) to return invoice fields and all line items as a strict JSON object. Parses and validates the returned JSON, enriching it with the form metadata and stopping the run if key fields (like invoice number or line items) are missing. Appends a single invoice “header” row to the Invoices tab in Google Sheets. Splits the extracted line items, adds per-line metadata and a unique key, and appends each line item as a row to the Line Items tab in Google Sheets. Aggregates all line items, verifies that their summed totals match the invoice total within a tolerance, builds an HTML report, and emails it to the submitter via Gmail. Setup Add an OpenAI API credential and ensure the O
Generate an FAQ MP3 library from form input with OpenAI TTS, Google Drive, Sheets and Gmail
Quick overview This workflow collects up to five FAQ questions and answers from an n8n Form, converts each entry to an MP3 using OpenAI text-to-speech, uploads the files to Google Drive, logs links in Google Sheets, and emails a summary with listen and download links via Gmail. How it works Receives an n8n Form submission containing the requester’s email, a FAQ category, and up to five question-and-answer pairs. Splits the submitted FAQ pairs into individual items, generating a TTS script and a safe MP3 filename for each valid question and answer. Calls the OpenAI Audio Speech API (tts-1) to generate an MP3 file for each FAQ script. Uploads each generated MP3 to a specified Google Drive folder. Builds Google Drive view and direct-download URLs for each uploaded file and appends the FAQ details and links to a Google Sheets tab. Aggregates all processed FAQs into a single HTML summary and sends it to the submitter via Gmail with listen and download links. Setup Add an OpenAI API credential for the HTTP request to the OpenAI Audio Speech endpoint. Create (or choose) a Google Drive folder for the audio files, connect Google Drive OAuth2, and replace YOUR_AUDIO_FOLDER_ID with the target
WSummarize unread Gmail into a daily Slack digest with Claude
Quick overview This workflow runs on a daily schedule, pulls your unread Gmail from the last 24 hours, and uses Anthropic Claude to sort and summarize it by Gmail category — then posts a clean, triage-ready digest to a Slack channel so you can scan your inbox at a glance. How it works Runs automatically on a daily schedule (default 8am). Fetches up to 50 unread emails from Gmail that arrived in the last 24 hours. A Code node combines them into a single prompt block, tagging each message with its Gmail category (Primary, Promotions, Social, Updates, Forums) and flagging multi-message threads. Anthropic Claude turns that into a concise, Slack-ready digest: active threads flagged at the top, Primary mail listed individually with a needs-reply note, and Promotions/Social condensed to a single count. A Code node extracts the summary text from Claude's API response. The digest is posted to your chosen Slack channel. Setup Connect a Gmail OAuth2 credential to the Gmail node, and adjust the search query (e.g. is:unread newer_than:1d) or 50-email limit if needed. Add your Anthropic API key as an HTTP Header Auth credential named x-api-key, used for requests to https://api.anthropic.com/v1/m
Triage chronic care vitals with Google Sheets, Gmail, Telegram and Slack
Quick overview This workflow runs daily to read chronic care vitals from Google Sheets, merge them into a per-patient record, score risk using AHA/ADA threshold rules, and notify clinicians via Telegram and Gmail when escalation is needed, while logging all results back to Google Sheets. How it works Runs every 24 hours on a schedule trigger. Reads blood pressure, glucose, activity/sleep, and patient master data from Google Sheets. Merges the sheets into a single structured record per patient for the current day. Calculates a risk score and risk level (LOW–CRITICAL) by evaluating vitals against AHA/ADA guideline thresholds and detecting anomalies. If escalation is required, generates a clinical intervention plan, sends a Telegram alert to the doctor, sends an HTML escalation email via Gmail, and appends/updates the escalated result in the Google Sheets DailyLog. If escalation is not required, writes the routine result to the Google Sheets DailyLog and sends a routine status email via Gmail. If any workflow error occurs, posts an error alert to a designated Slack channel. Setup Add Google Sheets OAuth2 credentials and update each Google Sheets node with your spreadsheet document ID
WHandle client intake, routing, and confirmations with Claude, Google Sheets, Gmail, and Twilio
Quick overview This workflow hosts an n8n intake form, checks whether the submitted state is in your service area, uses Anthropic Claude to draft confirmation messages and an internal summary, logs requests to Google Sheets, emails via Gmail, optionally sends an SMS via Twilio, and shows the customer a confirmation page. How it works Receives a new client request through an n8n-hosted form submission. Normalizes the submitted details (name, email, phone, state, request type, description, and SMS consent) and generates a timestamp and reference number. Checks whether the submitted state is included in your configured served-area list. For in-area requests, sends the intake details to Anthropic Claude and parses the returned JSON into a customer email message, customer SMS message, internal summary, category, priority, and missing-info list. Appends the request to Google Sheets, emails the intake team and the customer via Gmail, and sends an SMS confirmation via Twilio only when the customer opted in. For out-of-area requests, appends the submission to a Google Sheets waitlist and shows the customer a waitlist message. Setup Customize the n8n Form Trigger fields and text to match you
WProcess Jellyfin media requests with Google Sheets, Radarr, Sonarr, and Gmail
Quick overview This workflow monitors a Google Sheets-based media request form and automatically routes requests to Radarr (movies) or Sonarr (TV shows) via their APIs, then emails the requester through Gmail once the matching title is added for download. How it works Triggers every 5 minutes when a new row is added to a specified Google Sheets worksheet. Checks the “Request Type” field and routes the request to either the movie (Radarr) path or the TV show (Sonarr) path. Searches Radarr or Sonarr for the requested “Title of Media” using the lookup API endpoint. Filters the lookup results in JavaScript to pick the best matching title, prioritizing English originals and (for TV) allowing exact-title matches to support dubbed/anime requests. Submits the selected movie or series to Radarr or Sonarr with a defined quality profile, root folder path, and an automatic search for downloads. Sends a Gmail notification to the email address from the Google Form submission confirming the request is being downloaded. Setup Connect Google Sheets credentials and set the Spreadsheet (documentId) and worksheet (sheetName) used by your Google Form responses. Add HTTP Header Auth credentials for Rada
Send a daily RSS news digest email with Gmail
Quick overview Automatically combine any number of RSS feeds into one daily HTML email digest with deduplication and a configurable time window. How it works Runs daily on a cron schedule (default 8:00 AM). Generates a list of RSS feed URLs and digest settings (recipient email, lookback window, and max article count). Fetches the latest items from each RSS feed URL. De-duplicates articles, keeps only items published within the configured lookback window, sorts by publish date, and limits the list to the maximum article count. Stops if no articles remain after filtering to avoid sending an empty email. Builds an HTML email with the selected articles and sends it to the configured recipient using Gmail. Setup Add a Gmail OAuth2 credential and select it in the Gmail email-sending step. Update the recipient email address and RSS feed URLs in the configuration code, and optionally adjust HOURS_BACK and MAX_ARTICLES. Confirm or change the schedule cron expression to match your preferred send time, then activate the workflow. Requirements n8n Cloud or self-hosted n8n instance Gmail account with OAuth2 credentials configured in n8n Customization Add or remove RSS feed URLs in the Configure
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
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.