Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Track Recent Startup Funding Rounds with Piloterr
On a schedule, it fetches recent Series A and Series B fundraises from Piloterr and adds the companies to Google Sheets.
What it does
# Itemlists Workflow ## Overview Automated workflow: Itemlists Workflow. This workflow integrates 9 different services: itemLists, httpRequest, stickyNote, code, scheduleTrigger. It contains 22 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 22 - Node Types: 9 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Split results: itemLists - Piloterr - Get Recent Fundraise - Serie A: httpRequest - Piloterr - Get Recent Fundraise - Serie B: httpRequest - Google Sheets: googleSheets - Piloterr - Get Recent Fundraise - Seed: httpRequest - Prepare data: set - Piloterr - Enrich company: httpRequest - Merge: merge - Sticky Note: stickyNote - Schedule Trigger - Run Workflow Every Day: scheduleTrigger - ... and 12 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Split results
- Piloterr - Get Recent Fundraise - Serie A
- Piloterr - Get Recent Fundraise - Serie B
- Google Sheets
- Piloterr - Get Recent Fundraise - Seed
- Prepare data
- Piloterr - Enrich company
- Merge
- Schedule Trigger - Run Workflow Every Day
- Prepare data before importing to Gsheets
- Get Linkedin URL from object
- Error Handler
- Stopanderror 1
- Stopanderror 2
49 steps in total.
Similar automations
Monitoring, Ops & IncidentsLog New Crunchbase Funding Rounds in Google Sheets4 stepsMonitoring, Ops & IncidentsTrack Crunchbase Funding Rounds and Log Them to Google Sheets4 stepsWeb Scraping & ResearchScrape Crunchbase Funding Rounds into Google Sheets11 stepsReports, Analytics & DashboardsCrunchbase Startup Activity Alerts with OpenAI and Gmail7 steps