6. Build a full example
This workflow efficiently enriches company URLs, summarizes data in a Google Spreadsheet, and notifies users via Slack.
Build automated workflows to enrich and alert your company data
•
🔗 This advanced course video focuses on how to create a comprehensive workflow that enriches company data from URLs submitted via form triggers using the n8n platform .
•
📝 The workflow starts by setting up a form that allows users to submit a list of company URLs, which is then enriched using the People Data Lab API while also handling any errors that may occur.
•
🔍 After collecting the URLs, split them into an array so that you can process each one individually and iterate over them to augment them.
•
📊 Once the data is enriched, we filter it to only leave companies located in Europe and extract essential fields like company name, number of employees, country, and total amount raised .
•
📈 Relevant data is then added to Google Sheets, making it easy to track and manage enhanced company information.
•
📢 For your convenience , a final Slack notification will be sent summarizing the number of companies added to the Google Sheet, including a direct link to access the sheet .
•
🛠 Implement error handling throughout your process so that your workflow can handle errors appropriately without halting the entire process if an API call doesn't return a 200 status.
•
🔄 This complete workflow demonstrates how to efficiently automate data enrichment and communication, streamlining manual and time-consuming tasks.
LiveWiki, the key points from YouTube in just 10 seconds! - https://livewiki.com/ko/content/n8n-advanced-course-build-example
•
00:00 – 00:44:
◦
Introducing the sixth video of the n8n advanced course.
◦
In this video, we build a complete workflow that uses a form trigger to take a list of company URLs, augments them with information from the People Data Lab API, adds European company data to Google Sheets, and then sends a summary message to Slack.
•
00:44 – 01:28:
◦
Create an interface that allows you to input a list of URLs by adding a form trigger .
◦
Enter a list of URLs and get data through a test run.
◦
Leverage the data pinning feature to reuse this data .
•
01:28 – 02:11:
◦
Split URL : Use the Edit Fields node to split the entered URL string into individual items .
◦
Convert a list of URLs to an array and split them with commas (,) so that each URL can be treated as a separate item.
•
02:11 – 02:56:
◦
Use the Split Out node to split a list of URLs into individual items.
◦
Use the Loop Over Items node to perform operations on each URL sequentially .
•
02:56 – 03:40:
◦
Set up HTTP requests that complement each URL via the People Data Lab API.
◦
Complete the required settings for the HTTP node by referring to the examples of using SQL queries in the API documentation.
•
03:40 – 05:26:
◦
Replace the current URL with a query to retrieve data matching each URL.
◦
Use the if node to handle errors if the status code of the HTTP request is not 200.
•
05:26 – 07:08:
◦
After data supplementation is complete, use the Edit Fields node to move the required information to a higher level.
◦
Filter by the continent field using an if node to extract only companies located in Europe .
•
07:08 – 08:46:
◦
Add rows using Google Sheets nodes to add European company data to Google Sheets.
◦
Record company name, number of employees, country, funding information, etc. in Google Sheets.
•
08:46 – 10:13:
◦
Send a summary message after a workflow is completed using Slack nodes .
◦
Add more control to your Slack messages using block formatting and add buttons to jump directly to Google Sheets.
•
10:13 – 12:00:
◦
Create blocks to represent data added to a Slack message and include them in the message.
•
12:00 – End:
◦
Run the full test of the workflow.
◦
Enter a list of URLs, process the data, and then summarize the results and send them to Slack.
•
Next video preview:
◦
In the next video we'll cover how to process files in the n8n workflow.