Gmail to Google Drive Email Export Workflow

This n8n workflow streamlines email management by retrieving all emails from a designated sender (e.g., akhilgadiraju@gmail.com) using the Gmail node. It extracts key details like email ID, subject, message, and date, then uses a Set node to parse this data cleanly. A Code node formats the ISO 8601 timestamps into a readable format in Asia/Kolkata timezone (customizable), ensuring user-friendly output like 'Month Day, Year, Hour:Minute AM/PM'.

Next, the workflow converts the structured JSON into a CSV file via the Convert to File node, making it perfect for analysis or storage. Finally, it uploads the CSV directly to your Google Drive root folder (configurable). This end-to-end automation eliminates manual copying, reducing errors and saving hours of repetitive work.

Benefits include effortless email archiving, compliance-ready exports, and seamless integration between Gmail and Drive. It's highly useful for sales teams tracking communications, support logs, or personal email backups. Customize sender filters, timezones, or Drive folders to fit any scenario, with manual trigger for on-demand runs.

Use cases: Archiving vendor emails for audits, exporting customer inquiries for CRM import, or creating periodic reports from newsletters. Scalable for high-volume inboxes with n8n's efficiency.