What if you could pull the contact details of every business in your target market without visiting a single website manually? That is exactly what I built on Day 8. And it worked better than I expected. Remember Day 2 when I tried to build a web scraper and hit a wall of errors? I pivoted to a weather workflow that day and kept moving. I told myself I would come back to it better prepared. Day 8 was that moment. I built a contact information scraper on n8n that takes a list of business websites from Google Maps, digs through the HTML and pulls out the email addresses and phone numbers directly into a Google Sheet. No copying. No manual searching. Day 8 of my 30-Day Automation Challenge (Tools: n8n, Google Maps, Google Sheets) I tested it on dental clinics in Lagos and here is exactly what the workflow does: 🧫A manual trigger kicks off the workflow on demand. 🫴Get Rows node reads the list of target websites directly from Google Sheets. 🌐 HTTP Request node visits each website URL and fetches the raw page content. 🌐 HTML node extracts the relevant content from the page structure. ✅ Extract Email and Phone node isolates the contact details from the HTML. ➕ Append Row node logs the website link, email address and phone number back into the sheet automatically. Three dental clinic websites went in. Three rows of clean contact data came out. Emails and phone numbers all sit neatly in a spreadsheet, ready to use. Think about what this means practically: For anyone doing outreach, lead generation or market research, that is hours of work compressed into seconds. Sales teams building prospect lists. Recruiters researching company contacts. Marketers compiling industry directories. Any task that currently involves someone opening websites one by one and copying contact details into a spreadsheet is a task this workflow can handle in a fraction of the time. The data is already on those websites. You just need a system that collects it for you. 8 days in and this one feels personal. Day 2 left unfinished business, and today I closed it. Coming back to a challenge you walked away from and actually cracking it is a different kind of satisfaction from building something new. It reminded me that nothing is abandoned in this challenge. Some things are just parked until you are ready. 22 days still to go, and I am documenting every single one: what works, what breaks, and what shifts the way I think about work. Is there a task in your work that basically involves collecting information from multiple websites manually? I would genuinely love to know because there is probably a workflow for it. #WorkflowAutomation #n8n #30DayChallenge #WebScraping #Productivity #BuildInPublic
