This workflow follows the Gmail → Google Sheets 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 →
{
"nodes": [
{
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
560,
700
],
"parameters": {
"url": "https://randomuser.me/api/",
"options": {}
},
"typeVersion": 2
},
{
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
960,
560
],
"parameters": {
"range": "A:C",
"options": {
"usePathForKeyRow": true
},
"sheetId": "qwertz",
"operation": "append",
"authentication": "oAuth2"
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "Set",
"type": "n8n-nodes-base.set",
"position": [
760,
700
],
"parameters": {
"values": {
"string": [
{
"name": "name",
"value": "={{$json[\"results\"][0][\"name\"][\"first\"]}} {{$json[\"results\"][0][\"name\"][\"last\"]}}"
},
{
"name": "country",
"value": "={{$json[\"results\"][0][\"location\"][\"country\"]}}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"name": "Spreadsheet File",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
960,
840
],
"parameters": {
"options": {
"fileName": "users_spreadsheet"
},
"operation": "toFile",
"fileFormat": "csv"
},
"typeVersion": 1
},
{
"name": "Spreadsheet File1",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
960,
1200
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"name": "Write Binary File",
"type": "n8n-nodes-base.writeBinaryFile",
"position": [
1360,
1200
],
"parameters": {
"fileName": "randomusers.json"
},
"typeVersion": 1
},
{
"name": "Move Binary Data1",
"type": "n8n-nodes-base.moveBinaryData",
"position": [
1160,
1200
],
"parameters": {
"mode": "jsonToBinary",
"options": {}
},
"typeVersion": 1
},
{
"name": "Gmail1",
"type": "n8n-nodes-base.gmail",
"position": [
1360,
1420
],
"parameters": {
"message": "Hello, attached is a JSON file with random user information.",
"subject": "JSON file with users",
"additionalFields": {
"attachmentsUi": {
"attachmentsBinary": [
{
"property": "data"
}
]
}
}
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"notes": "Append data to sheet",
"position": [
1760,
1420
],
"parameters": {
"range": "A:C",
"options": {
"usePathForKeyRow": true
},
"sheetId": "qwertz",
"operation": "append",
"authentication": "oAuth2"
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"name": "Move Binary Data2",
"type": "n8n-nodes-base.moveBinaryData",
"position": [
1560,
1420
],
"parameters": {
"options": {},
"sourceKey": "attachment_0"
},
"typeVersion": 1
},
{
"name": "Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
560
],
"parameters": {
"width": 320,
"height": 80,
"content": "## JSON > Google Sheets"
},
"typeVersion": 1
},
{
"name": "Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
860
],
"parameters": {
"width": 320,
"height": 80,
"content": "## JSON > CSV"
},
"typeVersion": 1
},
{
"name": "Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
580,
1220
],
"parameters": {
"width": 320,
"height": 80,
"content": "## CSV > JSON file"
},
"typeVersion": 1
},
{
"name": "Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
1460
],
"parameters": {
"width": 320,
"height": 80,
"content": "## JSON file > Google Sheets"
},
"typeVersion": 1
}
],
"connections": {
"Set": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
},
{
"node": "Spreadsheet File",
"type": "main",
"index": 0
}
]
]
},
"Gmail1": {
"main": [
[
{
"node": "Move Binary Data2",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Set",
"type": "main",
"index": 0
}
]
]
},
"Spreadsheet File": {
"main": [
[
{
"node": "Spreadsheet File1",
"type": "main",
"index": 0
}
]
]
},
"Move Binary Data1": {
"main": [
[
{
"node": "Write Binary File",
"type": "main",
"index": 0
}
]
]
},
"Move Binary Data2": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"Spreadsheet File1": {
"main": [
[
{
"node": "Move Binary Data1",
"type": "main",
"index": 0
}
]
]
},
"Write Binary File": {
"main": [
[
{
"node": "Gmail1",
"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.
gmailOAuth2googleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Easily transfer data between JSON formats and spreadsheets to streamline your data management without manual copying or reformatting errors. This workflow suits teams handling customer data, reports, or inventories who need quick conversions between web APIs and tools like Google Sheets. The key step involves fetching JSON via HTTP Request, parsing it into spreadsheet structure, and exporting to Google Sheets for seamless editing and sharing.
Use this when pulling API data into collaborative spreadsheets for analysis or exporting sheet data to JSON for app integration, especially in small-scale automations. Avoid it for real-time processing or massive datasets over thousands of rows, as it relies on manual triggers and may slow down. Common variations include adding Gmail notifications for completion alerts or chaining to other storage nodes for backups.
About this workflow
Move Data Between Json And Spreadsheets. Uses httpRequest, googleSheets, spreadsheetFile, writeBinaryFile. Manual trigger; 14 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Automate WhatsApp communication for recruitment agencies with an interactive, structured customer experience. This workflow handles pricing inquiries, request submissions, tracking, complaints, and hu
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 t
This workflow ingests proof-of-delivery and completion documents from Gmail or a webhook, extracts key fields with an OpenRouter vision model, reconciles them against Google Sheets dispatch data, arch
Advanced AI Powered Document Parsing & Text Extraction with Llama Parse. Uses gmail, gmailTrigger, httpRequest, googleSheets. Webhook trigger; 54 nodes.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.