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 →
{
"name": "Daily Digital Products Automation",
"nodes": [
{
"parameters": {},
"name": "Trigger Manually",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"functionCode": "const niches = [\"Fitness\", \"Cooking\", \"Finance\", \"Education\", \"Mindfulness\", \"Productivity\", \"Travel\", \"Parenting\", \"DIY\", \"Pets\", \"Fashion\", \"Gaming\", \"Health\", \"Marketing\", \"Technology\", \"Art\", \"Photography\", \"Language Learning\", \"Self-Improvement\", \"Motivation\"];\nreturn niches.map(niche => ({ json: { niche } }));"
},
"name": "Generate Niches",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
500,
300
]
},
{
"parameters": {
"batchSize": 1
},
"name": "Split In Batches",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 1,
"position": [
750,
300
]
},
{
"parameters": {
"url": "https://api.openai.com/v1/chat/completions",
"method": "POST",
"jsonParameters": true,
"options": {},
"bodyParametersJson": "{\n \"model\": \"gpt-3.5-turbo\",\n \"messages\": [\n {\"role\": \"system\", \"content\": \"You are a helpful assistant that generates digital product ideas.\"},\n {\"role\": \"user\", \"content\": \"Generate a digital product in the niche {{$json.niche}}. Include title, short description, and price in USD. Return in JSON format like {\\\"title\\\":\\\"...\\\",\\\"description\\\":\\\"...\\\",\\\"price_usd\\\":...}.\"}\n ]\n}"
},
"name": "OpenAI Generate Product",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
1000,
300
],
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"name": "HTML to PDF",
"type": "n8n-nodes-base.htmlPdf",
"typeVersion": 1,
"position": [
1250,
300
]
},
{
"parameters": {
"url": "https://api.openai.com/v1/images/generations",
"method": "POST",
"jsonParameters": true,
"bodyParametersJson": "{\n \"prompt\": \"Cover image for {{$json.title}}, niche: {{$json.niche}}, professional digital product style\",\n \"size\": \"512x512\",\n \"n\":1\n}"
},
"name": "OpenAI Cover Image",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
1500,
300
],
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "https://api.gumroad.com/v2/products",
"method": "POST",
"jsonParameters": false,
"bodyParametersJson": "{\n \"product[name]\": \"{{$json.title}}\",\n \"product[description]\": \"{{$json.description}}\",\n \"product[price]\": \"{{$json.price_usd}}\",\n \"files[]\": \"{{$binary.data}}\",\n \"cover\": \"{{$binary.cover}}\"\n}"
},
"name": "Gumroad Upload",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
1750,
300
],
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "append",
"sheetId": "YOUR_GOOGLE_SHEET_ID",
"range": "Sheet1",
"columns": [
{
"column": "A",
"value": "={{$json.niche}}"
},
{
"column": "B",
"value": "={{$json.title}}"
},
{
"column": "C",
"value": "={{$json.price_usd}}"
},
{
"column": "D",
"value": "={{$json.product_permalink}}"
},
{
"column": "E",
"value": ""
},
{
"column": "F",
"value": "={{$now.toISOString()}}"
}
]
},
"name": "Google Sheets Log",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
2000,
300
],
"credentials": {
"googleSheetsOAuth2Api": "<your credential>"
}
}
],
"connections": {
"Trigger Manually": {
"main": [
[
{
"node": "Generate Niches",
"type": "main",
"index": 0
}
]
]
},
"Generate Niches": {
"main": [
[
{
"node": "Split In Batches",
"type": "main",
"index": 0
}
]
]
},
"Split In Batches": {
"main": [
[
{
"node": "OpenAI Generate Product",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Generate Product": {
"main": [
[
{
"node": "HTML to PDF",
"type": "main",
"index": 0
}
]
]
},
"HTML to PDF": {
"main": [
[
{
"node": "OpenAI Cover Image",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Cover Image": {
"main": [
[
{
"node": "Gumroad Upload",
"type": "main",
"index": 0
}
]
]
},
"Gumroad Upload": {
"main": [
[
{
"node": "Google Sheets Log",
"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.
googleSheetsOAuth2ApihttpBasicAuthhttpHeaderAuth
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Daily Digital Products Automation. Uses httpRequest, htmlPdf, googleSheets. Event-driven trigger; 8 nodes.
Source: https://gist.github.com/aminehalimi979-ops/f66acd56a056d5aa7a61699e7c76eb71 — 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.
Transform your event registration process with this comprehensive automation that eliminates manual certificate creation and ensures only verified attendees receive credentials.
Telegram URL to Google Sheets with Validation. Uses telegramTrigger, httpRequest, htmlExtract, googleSheets. Event-driven trigger; 7 nodes.
This workflow automates SEO analysis by comparing your website with a competitor’s site. It reads input URLs from Google Sheets, scrapes structured SEO data from both sites, and expands into important
This template can be used to find the content gaps in your competitors' discourse: identifying the topics they are not yet connecting and giving you an opportunity to fill in this gap with your conten
Googletasks Http. Uses splitInBatches, httpRequest, stickyNote, html. Event-driven trigger; 17 nodes.