All Workflows
Generate LinkedIn Lead Intelligence with Apify and Create Outlook Drafts to Google Sheets
This workflow helps you automate the heavy lifting of B2B lead enrichment and personalized outreach preparation. You can customize the target LinkedIn profiles, the specific value propositions in your outreach, and the criteria for lead relevance to fit your SaaS sales motion. It uses Apify to scrape detailed professional data, synthesizes company intelligence via web lookups, and saves the enriched lead data directly to Google Sheets. In this example, the workflow processes up to 10 LinkedIn URLs to generate personalized company summaries, relevance notes, and tailored email drafts. Finally, it creates ready-to-review drafts in your Outlook account, ensuring your outreach is personalized without being fully automated.
What it does
1
Parse up to 10 LinkedIn profile URLs from your provided inputs.
2
Scrape professional and company data using Apify’s LinkedIn Profile Scraper.
3
Enrich leads with company summaries, relevance notes, and personalized outreach angles.
4
Generate custom email subjects and draft bodies tailored to each prospect’s role and company context.
5
Save the structured lead intelligence to a 'LinkedIn Lead Intelligence' Google Sheet.
6
Create personalized email drafts in your Outlook folder for manual review and approval.
Connectors
LinkedInGoogle SheetsOutlookApifyHow to use
1
Use the template
Click "Use this template" to open this workflow in Kuse and start from a ready-made setup.
2
Connect your accounts
Authorise the connectors listed above. Kuse guides you through each OAuth flow in the workflow editor.
3
Customise
Adjust the search criteria, output format, or schedule to fit your specific use case. All fields are editable.
4
Activate
Turn on the schedule or trigger the workflow manually from your Workflows dashboard to run it for the first time.
