Seeking Help: Automating Company List Extraction to Google Sheets

Certainly! Here’s a concise and professional Slack message for your request:


Hey everyone! :wave:

I’m looking for some help developing an automation that can:
:one: Take any URL input (e.g., a VC website)
:two: Extract the list of companies from the page
:three: Write the extracted companies to a Google Sheet each in a new row

I have built it and it sort of works but it does not extract full companies eg test on https://www.blackbird.vc, https://www.airtree.vc or Our Companies | OIF Ventures

And when it extracts, it adds all the companies into one cell even though I said to add as a single row. Ideally I want it to show like this as per image

Has anyone built something similar or have recommendations on tools/libraries that can handle this efficiently? I would appreciate any insights, if you can record a loom video that would be amazing!!

https://www.gumloop.com/pipeline?run_id=eFGPEM3zT38iGL82QEnQqA

Thanks in advance! :raised_hands:

Try this, worked for me

2 Likes

Thank you Donna!

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.