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.
Tags
Gmail
Google SheetsRelated workflows
See all Gmail→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
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
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