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