ProspectLens company research

ProspectLens company research automates the process of gathering and storing company data in Google Sheets. It filters unprocessed entries, retrieves detailed information via the ProspectLens API, and updates your spreadsheet with key metrics such as funding totals, traffic, and founding year. This workflow streamlines research efforts, ensuring you capture essential data efficiently and effectively.

7/4/2025
7 nodes
Simple
manualsimplefiltersticky notegooglesheetssplitinbatchesapiintegration
Categories:
Data Processing & AnalysisManual TriggeredSimple Workflow
Integrations:
FilterSticky NoteGoogleSheetsSplitInBatches

Target Audience

This workflow is ideal for:
- Data Analysts: Who need to gather and analyze company data efficiently.
- Business Development Teams: Looking for insights on potential leads or partners.
- Marketing Professionals: Who want to understand market trends and company performance.
- Entrepreneurs: Seeking to evaluate potential investment opportunities or competitors.
- Researchers: In need of structured data for academic or market research purposes.

Problem Solved

This workflow addresses the challenge of manually collecting and organizing company data from various sources into Google Sheets. By automating the process, it ensures:
- Time Efficiency: Reduces the time spent on data entry and collection.
- Accuracy: Minimizes human error in data handling.
- Scalability: Allows users to process multiple companies quickly and effectively.
- Data Organization: Ensures that only relevant and unprocessed data is analyzed, enhancing the quality of insights.

Workflow Steps

  • Manual Trigger: The workflow begins when the user clicks ‘Test workflow’.
    2. Get All Rows from Sheets: Fetches all company data from the specified Google Sheet.
    3. Filter: Only processes rows where the processed_at field is empty, ensuring that previously processed data is excluded.
    4. Loop Over Items: Iterates through the filtered company data to maintain low concurrency (1 thread).
    5. ProspectLens API Call: For each company, makes an API call to ProspectLens to retrieve detailed company information based on the domain.
    6. Save Company Data into Sheets: Updates the Google Sheet with the newly retrieved data, including key fields such as name, funds, domain, and processed_at timestamp.
    7. End of Workflow: The process concludes after all items have been processed and saved.

    • Customization Guide

    To customize this workflow:
    - Modify Filters: Adjust the conditions in the Filter node to include or exclude specific data points based on your needs.
    - Change API Endpoint: Update the URL in the ProspectLens API call if you want to access different endpoints or parameters.
    - Adjust Data Mapping: In the Save Company Data into Sheets node, modify the fields being saved to align with your Google Sheet's structure or additional data you wish to capture.
    - Add Additional Nodes: Incorporate more nodes for further data processing, notifications, or integrations with other platforms as required.
    - Schedule Automation: Consider using a cron job or other scheduling mechanisms to automate the workflow at regular intervals instead of manual triggers.