PrideVel This workflow corresponds to n8n.io template #10725 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request 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": [
{
"id": "6db177f3-d001-4f14-b1eb-cb61a78acf0b",
"name": "Start Workflow Manually",
"type": "n8n-nodes-base.manualTrigger",
"position": [
48,
672
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bd75fa5c-cdbc-41e6-bb85-16f7e677f8f8",
"name": "Fetch User Data from API",
"type": "n8n-nodes-base.httpRequest",
"position": [
272,
672
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f193bb20-baa5-482a-aab3-bb37f884d1aa",
"name": "Verify API Response Success",
"type": "n8n-nodes-base.if",
"position": [
496,
672
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b9d06596-07ff-4214-a446-30522c516372",
"name": "Transform API Data to Name and Country",
"type": "n8n-nodes-base.function",
"position": [
752,
672
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0ad2fa3d-3280-490f-95de-cee3ea18acc7",
"name": "Append Data to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
976,
672
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6d41aadd-d40b-4575-b336-853027a82669",
"name": "Create CSV Backup File",
"type": "n8n-nodes-base.spreadsheetFile",
"position": [
1200,
672
],
"parameters": {},
"typeVersion": 1
},
{
"id": "61f16acf-e6ac-4883-8dbe-f23d1c8d6b9e",
"name": "Workflow Documentation",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "69e49ede-d0fe-4a70-9320-36c8e17e3018",
"name": "Stop on API Failure",
"type": "n8n-nodes-base.stopAndError",
"position": [
752,
848
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2d01307d-a506-4e03-a364-22cbaeb05e3a",
"name": "Step 1 - Trigger",
"type": "n8n-nodes-base.stickyNote",
"position": [
256,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0a1daf1e-68a7-47fa-9281-07c74703dafa",
"name": "Step 2 - API Request",
"type": "n8n-nodes-base.stickyNote",
"position": [
512,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c85e3f8a-0e99-48a8-98ad-428675dcddab",
"name": "Step 3 - Validation",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8a2d226c-f612-4dbe-baf5-b7ffbeef7fb7",
"name": "Step 4 - Transform",
"type": "n8n-nodes-base.stickyNote",
"position": [
1024,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8759aba8-51d3-4168-9e1a-d38fa1a4f651",
"name": "Step 5 - Google Sheets",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ac87e4f5-0cf3-44f3-bbbb-023cd408cacd",
"name": "Step 6 - CSV Backup",
"type": "n8n-nodes-base.stickyNote",
"position": [
1536,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"Start Workflow Manually": {
"main": [
[
{
"node": "Fetch User Data from API",
"type": "main",
"index": 0
}
]
]
},
"Fetch User Data from API": {
"main": [
[
{
"node": "Verify API Response Success",
"type": "main",
"index": 0
}
]
]
},
"Verify API Response Success": {
"main": [
[
{
"node": "Transform API Data to Name and Country",
"type": "main",
"index": 0
}
],
[
{
"node": "Stop on API Failure",
"type": "main",
"index": 0
}
]
]
},
"Append Data to Google Sheets": {
"main": [
[
{
"node": "Create CSV Backup File",
"type": "main",
"index": 0
}
]
]
},
"Transform API Data to Name and Country": {
"main": [
[
{
"node": "Append Data to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}
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 fetching user data from an API, verifying its validity, transforming the response, and then saving it to Google Sheets for team collaboration. Additionally, it generates a CSV backup file of the same data for offline access or external…
Source: https://n8n.io/workflows/10725/ — 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.
Batch_Call. Uses googleDrive, httpRequest, stopAndError, googleSheets. Event-driven trigger; 28 nodes.
Shopify Csv Import. Uses formTrigger, moveBinaryData, spreadsheetFile, googleSheets. Event-driven trigger; 12 nodes.
Import Csv From Url To Google Sheets. Uses manualTrigger, googleSheets, spreadsheetFile, httpRequest. Event-driven trigger; 7 nodes.
Import CSV from URL to GoogleSheet. Uses manualTrigger, googleSheets, spreadsheetFile, httpRequest. Event-driven trigger; 7 nodes.
This workflow automatically imports data from a CSV file located at a specific URL and then updates the Google Sheets document with the provided data.