Automated Social Media Profile Collection from Google Sheets

This n8n workflow automates the process of retrieving social media profile links for contacts listed in a Google Sheet. It is designed to run on a schedule, processing one contact at a time. The workflow begins by fetching all contacts, filtering out those already analyzed, and limiting the process to one contact per run for efficiency. It then invokes a subworkflow that uses AI-powered tools to search for social media profiles across 18+ platforms, prioritizing verified or official accounts. The results are validated and structured according to a predefined schema, ensuring all platforms are accounted for with valid URLs or null values. Finally, the workflow updates the original Google Sheet with these links and marks the contact as ‘Analyzed,’ making it a valuable tool for personal branding, lead enrichment, or influencer research. This automated process saves time, enhances data accuracy, and helps maintain comprehensive social media profiles for contacts stored in spreadsheets.