Get companies from database
Configured with Agent, Aggregate, Filter, Html, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Subworkflow
- AI & models
- Transform
- Trigger
- Data store
- Routing
- Web / API
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| Text | Subworkflow | Tool Workflow | See node parameters |
| URLs | Subworkflow | Tool Workflow | See node parameters |
| OpenAI Chat Model | AI & models | OpenAI Chat Model | See node parameters |
| JSON Parser | Transform | Output Parser Structured | See node parameters |
| Map company name and website | Transform | Edit Fields | See node parameters |
| Execute workflow | Trigger | Manual Trigger | See node parameters |
| Get companies | Data store | Supabase | getAll |
| Select company name and website | Transform | Edit Fields | See node parameters |
| Set social media array | Transform | Edit Fields | See node parameters |
| Merge all data | Transform | Merge | See node parameters |
| Insert new row | Data store | Supabase | See node parameters |
| Convert HTML to Markdown | Transform | Markdown | See node parameters |
| Retrieve URLs | Transform | Html | extractHtmlContent |
| Split out URLs | Transform | Split Out | See node parameters |
| Remove duplicated | Transform | Remove Duplicates | See node parameters |
| Set domain to path | Transform | Edit Fields | See node parameters |
| Filter out invalid URLs | Routing | Filter | See node parameters |
| Aggregate URLs | Transform | Aggregate | See node parameters |
| Filter out empty hrefs | Routing | Filter | See node parameters |
| Set domain (text) | Transform | Edit Fields | See node parameters |
| Add protocool to domain (text) | Transform | Edit Fields | See node parameters |
| Get website (text) | Web / API | HTTP Request | See node parameters |
| Set response (text) | Transform | Edit Fields | See node parameters |
| Set domain (URL) | Transform | Edit Fields | See node parameters |
| Get website (URL) | Web / API | HTTP Request | See node parameters |
| Set response (URL) | Transform | Edit Fields | See node parameters |
| Add protocool to domain (URL) | Transform | Edit Fields | See node parameters |
| Crawl website | AI & models | Agent | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
openAiApisupabaseApi
Workflow notes
Text scraper tool
Text scraper tool
This tool is designed to return all text from the given webpage.
💡 Consider adding proxy for better crawling accuracy.
URL scraper tool
URL scraper tool
This tool is designed to return all links (URLs) from the given webpage.
💡 Consider adding proxy for better crawling accuracy.
Get companies from database
Get companies from database
Retrieve names and websites of companies from Supabase table to process crawling.
💡 You can replace Supabase with other database of your choice.
Set parameters for execution
Set parameters for execution
Pass only name and website values from database.
⚠️ If you use other field namings, update this node.
Crawling agent (retrieve social media profile links)
Crawling agent (retrieve social media profile links)
Crawl website to extract social media profile links and return them in unified JSON format.
💡 You can change type of retrieved data by editing prompt and parser schema.
Insert data to database
Insert data to database
Add new rows in database table with extracted data.
💡 You can replace Supabase with other database of your choice.
⚠️ Note
⚠️ Note
- Complete video guide for this workflow is available on my YouTube.
- Remember to add your credentials and configure nodes.
- If you like this workflow, please subscribe to my YouTube channel and/or my newsletter.
Thank you for your support!
Autonomous AI crawler
Autonomous AI crawler
This workflow autonomously navigates through given websites and retrieves social media profile links.
💡 You can modify this workflow to retrieve other type of data (e.g. contact details or company profile summary).
Get companies from database
Get companies from database
Purpose and structure
This folder contains the Get companies from database workflow. Its executable nodes use agent, aggregate, filter, html, httpRequest, lmChatOpenAi, manualTrigger, markdown, merge, outputParserStructured, removeDuplicates, set, splitOut, supabase, toolWorkflow. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
Execute workflow
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/0520_Splitout_Filter_Create_Webhook.json MIT; preserve source notices.