This project aimed to automate the process of enriching a list of professionals and their locations from a Google Sheets document by fetching search engine results (SERPs) for their LinkedIn profiles and email addresses, verifying the data, and storing the enriched results in a Notion database. The entire workflow was automated using N8N, allowing the client to save time and ensure that their CRM or contact lists were accurate and up-to-date.
The client maintained a list of professionals, including their names and locations, in Google Sheets. They needed to:
• Automate the search for LinkedIn profiles and email addresses using the data from Google Sheets.
• Verify the results to ensure that the LinkedIn URLs and email addresses were accurate.
• Enrich the data by adding these new details back into Google Sheets and syncing the enriched information to a Notion database for further use.
The automation had to be capable of handling large datasets, ensuring that the client could rely on the enriched information for outreach and business purposes.
• SERP Data Scraping: Extracting relevant LinkedIn URLs and other profile information from search engine results.
• Email Extraction & Validation: Finding and validating email addresses for each professional.
• Data Accuracy: Ensuring that the LinkedIn profiles and emails matched the professionals listed in the Google Sheets document.
• Seamless Integration: Automating the entire workflow between Google Sheets, SERP scraping, LinkedIn profile enrichment, email validation, and Notion database updates.
1. Retrieving Data from Google Sheets:
• The first step was setting up N8N to fetch all rows from the Google Sheets document that contained the names of professionals and their locations.
• Each row contained fields like “Professional Name” and “Location” that served as the input for further enrichment steps.
2. SERP Scraping for LinkedIn Profiles:
• Using SERP API in N8N, a search query was dynamically generated for each professional in the format “Professional Name + Location + LinkedIn”.
• The results from the search engine provided potential LinkedIn profile URLs, which were then filtered and extracted.
3. Email Discovery and Verification:
• N8N integrated with an email finder API (like Hunter.io or Clearbit) to discover the professional’s email address based on their name, domain (if available), and other profile information.
• The found emails were then verified using an email verification service to ensure deliverability and accuracy, avoiding invalid or spam addresses.
4. Updating Google Sheets with Enriched Data:
• After LinkedIn profiles and verified emails were found, the workflow added this enriched information back into the respective rows in Google Sheets.
• The sheet was updated with new columns like “LinkedIn URL” and “Verified Email.”
5. Syncing Data with Notion Database:
• Using N8N’s Notion integration, the enriched data (name, location, LinkedIn URL, and email) was automatically added to the relevant database in Notion.
• Each professional was either added as a new entry or updated in the existing database, depending on whether their information had already been stored previously.
6. Testing and Refinement:
• The automation was thoroughly tested with a sample set of professionals to ensure the system could handle large volumes of data while maintaining accuracy.
• Adjustments were made to improve the filtering process for LinkedIn URLs and ensure that only valid, relevant profiles were retrieved and saved.
The automated workflow provided the following key benefits:
• Time Savings: The client no longer had to manually search for LinkedIn profiles or emails, saving hours of work.
• Accurate Data Enrichment: The workflow ensured that the information in the Google Sheets was enriched with verified LinkedIn URLs and email addresses.
• Improved CRM Management: With the enriched data automatically synced to Notion, the client could manage their professional contacts and leads more efficiently.
• Scalability: The system was built to handle large datasets, making it easy to scale as the client’s list of professionals grows.
This solution enabled the client to efficiently manage and enrich their professional contact list, providing up-to-date information for outreach and networking efforts.
Fill out the form and one of our consultants will reach out to you within a day! Or just drop an email at... contact@cloudifybiz.com
