Quick overview
This workflow runs every 6 hours to scrape Naver Place business listings via the UnitBytes Apify actor, deduplicate results, log all leads to Google Sheets and a CSV export, and use OpenAI to enrich high-priority leads before posting an alert to Slack and creating a bilingual Gmail draft.
How it works
- Runs every 6 hours and sets the Naver Place search queries, scoring threshold, and Google Sheets tab name.
- Calls the UnitBytes Apify “naver-place-scraper” actor to fetch Naver Place/Naver Map business listing details.
- Deduplicates the scraped results across executions using the place ID (or fallback identifiers) to skip previously seen businesses.
- Cleans and normalizes key fields and calculates a 0–100 priority score to flag high-priority leads.
- Appends all scraped leads to Google Sheets and also generates a CSV dataset export as a backup.
- Sends only high-priority leads to OpenAI (gpt-4o-mini) to produce an English headline, tier verdict, short analysis, and a bilingual outreach message.
- Posts the enriched lead and outreach draft to Slack and creates a matching outreach email draft in Gmail.
Setup
- Add an Apify API token as an HTTP Header Auth credential (Authorization: Bearer <YOUR_APIFY_TOKEN>) for the Apify HTTP request.
- Connect credentials for OpenAI, Google Sheets, Slack, and Gmail.
- Set the Apify actor input (queries/maxItems/reviews), the target Google Sheets document ID and tab name, and adjust the minimum lead score threshold used to filter high-priority items.
- Select the Slack channel to post alerts to and confirm the Gmail account used for draft creation.
Requirements
Customization
- Change queries, mode (places or menu), and maxItems in Set Search Parameters
- Adjust minLeadScore or priorityKeyword to control which Korean business leads are sent to OpenAI
- Customize the bilingual Korean/English SDR prompt in AI Lead Translator and SDR
Additional info
Full input parameters and sample output schema for the UnitBytes Naver Place & Map Scraper actor: https://unitbytes.com/actors/naver-place-scraper/