Convert URLs from Google Sheets to Drive markdown files with Gaffa
UnknownWhat this workflow does
This workflow has 10 nodes and runs on a schedule (every 6 hours). Along the way it connects Google Sheets, Google Drive and Gaffa (community).
How it runs
Trigger: On a schedule (every 6 hours).
- Read the URLs (Google Sheets): uses Google Sheets
- Only new rows (Filter): keeps only the items that match a condition
- Loop over URLs (Loop Over Items (Split in Batches)): loops over the items in batches
- Convert to markdown (Gaffa): uses Gaffa
- Converted OK? (If): checks a condition and branches into true / false
- Clean the markdown (Code): runs custom JavaScript code
- Mark row error (Google Sheets): update
- Save to Drive (Google Drive): create from text
- Mark row done (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @gaffa-dev/n8n-nodes-gaffa is verified or supports 3.0 (used in Convert to markdown).
Nodes used (8)
- Google Sheets
n8n-nodes-base.googleSheets - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gaffa
@gaffa-dev/n8n-nodes-gaffa.gaffa - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Filter
n8n-nodes-base.filter - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick Overview This chat workflow takes a URL, uses Gaffa to render the web page in a browser and convert it to clean markdown, then returns the markdown directly in the n8n chat response. How it works 1. Receives a chat message containing a URL via the n8n…