Automated Email Attachment Organizer Automatically process labeled emails with attachments into organized Google Drive folders Who Is This For? Teams or Individuals** needing to: Automatically sort invoices, receipts, and files. Organize client documents by date. Verify sender emails against a whitelist. Timestamp files to avoid duplicate names. What Does This Workflow Solve? 🕒 Manual Email Sorting: Saves time by automating the organization of email attachments. 📂 Disorganized Cloud Storage: Ensures attachments are neatly stored in Google Drive folders. 📧 Unverified Sender Issues: Filters and validates emails using a whitelist. 🔄 Duplicate Filenames: Uses timestamps to ensure every file name is unique. Setup Guide 1. Pre-Requisites Whitelist Sheet**: Make a copy of the Example Whitelist Sheet Gmail Filter**: Create a filter in Gmail to label emails with attachments. To Create a Gmail Filter: Open your Gmail Inbox. Click the search bar and select "Show search options". Enter your criteria (e.g., type has:attachment). Click "Create filter". Choose "Apply the label: Custom_Label" and save. 2.
Tags
Gmail
Google Drive
Google SheetsRelated workflows
See all Gmail→WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
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
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