AutomationFlowsEmail & Gmail › Gmail to Google Drive Email Export Workflow

Gmail to Google Drive Email Export Workflow

ByAkhil Varma Gadiraju @akhilv7 on n8n.io

This n8n workflow automates the process of: Retrieving all emails from a specific sender using Gmail. Extracting essential fields like subject, message, and date. Formatting the email date to the desired time zone (e.g., IST). Exporting the parsed data as a CSV file. Uploading…

Event trigger★★★★☆ complexity13 nodesGmailGoogle Drive
Email & Gmail Trigger: Event Nodes: 13 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #4236 — we link there as the canonical source.

This workflow follows the Gmail → Google Drive recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "00de0985-997a-4c97-9a4a-d28fae9a9641",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        380,
        0
      ],
      "parameters": {
        "simple": false,
        "filters": {
          "sender": "user@example.com"
        },
        "options": {},
        "operation": "getAll",
        "returnAll": true
      },
      "credentials": {
        "gmailOAuth2": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "7b167ae9-5a1d-4bd3-b18e-c1cd8da06559",
      "name": "Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1260,
        0
      ],
      "parameters": {
        "name": "={{ $now + \"_n8n_export.csv\" }}",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "root",
          "cachedResultName": "/ (Root folder)"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "522a4ece-e0dc-4639-81d3-2f4a1b9f459e",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1040,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "f2e29c64-91c7-48b4-8416-eaf98b014596",
      "name": "Parse Data",
      "type": "n8n-nodes-base.set",
      "position": [
        600,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "2b446be8-1d0c-4a61-8896-f0a90f5100ea",
              "name": "id",
              "type": "string",
              "value": "={{ $json.id }}"
            },
            {
              "id": "8263ed23-ae85-4bdc-8c24-fe5fc3f12601",
              "name": "subject",
              "type": "string",
              "value": "={{ $json.subject }}"
            },
            {
              "id": "09ceff74-3064-4103-aa06-f56693d02765",
              "name": "message",
              "type": "string",
              "value": "={{ $json.text }}"
            },
            {
              "id": "6df559f5-d6b4-4fa4-8f7e-7e63a3c27994",
              "name": "time",
              "type": "string",
              "value": "={{ $json.date }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "399c6f2c-b59a-4e44-aba7-b0a65eb61423",
      "name": "Start Workflow",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        160,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4d245499-f824-4887-85f0-5cd199c2e648",
      "name": "End Workflow",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1480,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d76bc543-75d6-4c9c-ac84-4b05be377e06",
      "name": "Convert Time Field",
      "type": "n8n-nodes-base.code",
      "position": [
        820,
        0
      ],
      "parameters": {
        "jsCode": "return $input.all().map(item => {\n  const isoTime = item.json.time;\n\n  const date = new Date(isoTime).toLocaleString('en-US', {\n    timeZone: 'Asia/Kolkata',  // \ud83d\udd01 Change this to your UAT timezone\n    year: 'numeric',\n    month: 'long',\n    day: 'numeric',\n    hour: 'numeric',\n    minute: '2-digit',\n    hour12: true\n  });\n\n  return {\n    json: {\n      ...item.json,\n      time: date\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "93d5dfcf-c902-4471-9a04-6e7473417bd0",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        -120
      ],
      "parameters": {
        "width": 280,
        "height": 100,
        "content": "### Change Sender Email\nUpdate the `sender` field in the Gmail node."
      },
      "typeVersion": 1
    },
    {
      "id": "97f660ed-281b-4ba9-9656-777b9aea2ef0",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        520,
        160
      ],
      "parameters": {
        "width": 280,
        "height": 100,
        "content": "### Add More Email Fields\t\nModify the Set node to include more fields."
      },
      "typeVersion": 1
    },
    {
      "id": "825055a9-8e4f-4e39-ae2f-729c103568d6",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        740,
        -100
      ],
      "parameters": {
        "height": 80,
        "content": "### Change Time Zone\nEdit timeZone in the Code node."
      },
      "typeVersion": 1
    },
    {
      "id": "3f78a5a8-5cd4-40a0-be5f-d984e952d975",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        920,
        160
      ],
      "parameters": {
        "width": 300,
        "height": 100,
        "content": "### Change File Format\nUse a different format in the Convert to File node."
      },
      "typeVersion": 1
    },
    {
      "id": "ffbf9a23-dc2c-4ebe-986e-2aff8a170b51",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1160,
        -220
      ],
      "parameters": {
        "width": 280,
        "height": 200,
        "content": "### Rename Output File \nAdjust the name in the Google Drive nod\n\n### Change Upload Folder\nSet a different folderId in the Google Drive node."
      },
      "typeVersion": 1
    },
    {
      "id": "93836b97-81d9-47d4-b8dc-3d856e78090a",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        -580
      ],
      "parameters": {
        "width": 580,
        "height": 200,
        "content": "## \ud83d\ude80 Use Cases\n\n- **Personal Email Archiving**: Back up or export emails from a specific sender (e.g., invoices, reports).\n- **Audit Logs**: Save conversations for compliance.\n- **Team Reports**: Aggregate project emails into a central file store. "
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Gmail": {
      "main": [
        [
          {
            "node": "Parse Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Data": {
      "main": [
        [
          {
            "node": "Convert Time Field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive": {
      "main": [
        [
          {
            "node": "End Workflow",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start Workflow": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert Time Field": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This n8n workflow automates the process of: Retrieving all emails from a specific sender using Gmail. Extracting essential fields like subject, message, and date. Formatting the email date to the desired time zone (e.g., IST). Exporting the parsed data as a CSV file. Uploading…

Source: https://n8n.io/workflows/4236/ — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

This template is built to be customized for your specific needs. This template has the core logic and n8n node specific references sorted to work with dynamic file names throughout the workflow. Store

Gmail, Slack, Gmail Trigger +3
Email & Gmail

This is an elite enterprise-grade solution for Talent Acquisition and HR Ops teams. It automates the high-volume task of resume screening by transforming unstructured PDF applications into structured

N8N Nodes Htmlcsstopdf, Postgres, HubSpot +4
Email & Gmail

📩🤖 This workflow automatically processes emails received in Gmail, extracts their attachments, and organizes them into specific folders in Google Drive based on the sender's email address.

Gmail Trigger, Google Drive, Execute Workflow Trigger +1
Email & Gmail

Teams that receive documents via email (invoices, receipts, contracts) and want structured data automatically extracted and added to a spreadsheet - without manual data entry.

Gmail Trigger, Gmail, N8N Nodes Docupipe +2
Email & Gmail

Freelancers, finance teams, and small businesses that receive invoice PDFs by email and want them automatically saved to Google Drive and logged in Google Sheets—without manual downloading or copy-pas

Gmail Trigger, Google Drive, Google Sheets +1