Enrich company domains with business data using Perplexity AI and Google Sheets

Description

This workflow automatically enriches company domain lists with comprehensive business information using Perplexity AI's research capabilities and organizes the data in Google Sheets for easy analysis and use.

Who's it for
Sales teams** building prospect databases with accurate contact information
Marketing professionals** researching target companies for campaigns
Business development teams** gathering competitive intelligence
Data analysts** enriching existing company datasets
Researchers** collecting business information for market analysis

How it works
The workflow reads unprocessed company domains from a Google Sheets document, processes them in batches of 10 using Perplexity AI to research detailed business information, then saves the enriched data back to the spreadsheet. It focuses on German addresses but can be customized for any region.

What it does
Fetches unprocessed domains - Reads company domains from Google Sheets that haven't been processed yet
Batches for efficiency - Groups domains into batches of 10 to optimize API costs and performance
AI-powered research - Uses Perplexity AI to find comprehensive business data for each company
Parses structured data - Converts AI responses into clean, structured JSON format
Updates spreadsheet - Saves enriched data and marks domains as processed to prevent duplicates

Requirements
Perplexity AI API key** (Get one here)
Google Sheets API access** (OAuth2 credentials)
Google Sheets template** - Make a copy of this template

How to set up
Make a copy of the template Google Sheet and update the document ID in both Google Sheets nodes
Configure Perplexity AI credentials in the HTTP Request node
Set up Google Sheets OAuth2 authentication
Add your company domains to the "domain" column in the Data tab
Leave the "processed" column empty for new domains
Run the workflow using the manual trigger

How to customize the workflow
Change target region**: Modify the AI prompt to research addresses in different countries
Adjust batch size**: Change the batch size in the "Batch Process Domains" node (smaller batches = lower costs)
Add custom fields**: Extend the AI prompt and Google Sheets mapping to include additional data points
Automate execution**: Replace Manual Trigger with Schedule Trigger for regular processing
Filter criteria**: Modify the Google Sheets filter to process specific subsets of domains

Output data includes
Complete company address (street, city, state, postal code, country)
International phone number format
Latest employee count and annual revenue (USD)
Industry classification
LinkedIn company URL
Reliable source URL for verification
Processing status tracking