Turn a simple company list into a verified contact list without heavy manual work. Sales teams can find and enrich decision makers, then see weekly results in Slack.

New or updated rows in Google Sheets start the flow. Rows marked as not processed are checked for a website. If the website is missing, the system searches for it and asks a teammate in Slack to approve the result. Company details are pulled from an enrichment API, and an AI step writes a short summary of what the business does. Decision makers are found in large batches of up to 1000 domains, then each contact gets a department based on job title. A second API adds emails and phones in groups of 10. Contacts with verified emails are kept in a separate tab. A schedule runs a weekly report that posts metrics to Slack.

You need accounts for Google Sheets, Apollo.io, Slack, and OpenAI. Map your sheet to the nodes and add your API keys. Expect faster prospecting, cleaner data, and clearer reporting. This is ideal for outbound sales, partner outreach, and any team that needs accurate decision maker lists at scale.

• Google Sheets trigger on row add or update with smart status filtering to avoid duplicates
• Checks if a domain exists and uses an organization search when the website is missing
• Human in the loop website approval in Slack to confirm or correct results
• Organization enrichment pulls company details and writes a one line AI summary
• People search runs in batches of up to 1000 domains with a dynamic URL builder
• Split out results and assign a department based on job title using an AI model
• Bulk people enrichment adds emails and phone numbers in groups of 10
• Contacts are upserted into Google Sheets with a separate verified view
• Weekly schedule posts lead metrics to Slack for easy team visibility

• Reduce manual research from hours to minutes by automating company and contact lookup
• Handle up to 1000 company domains per batch and enrich 10 contacts per call for scale
• Improve data quality by only keeping contacts with verified emails
• Connect Google Sheets, Apollo.io, Slack and OpenAI in one flow
• Get a weekly Slack summary of new verified leads without extra reporting work

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Apollo.io, Slack and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create a Google Sheets credential. Double click a Google Sheets node, choose Credential to connect with, click Create new credential, and follow the prompts to allow access to your spreadsheet.
4. Create an Apollo.io API key in your Apollo.io account. In n8n, open each Apollo HTTP Request node and create a new API Key credential. Paste the key and save.
5. For Slack, open the Slack node and create a new Slack credential. Follow the on screen steps to install the app to your workspace and approve required scopes.
6. For the AI steps, open the OpenAI nodes and create a new API Key credential using your OpenAI key from the OpenAI dashboard.
7. Open the Google Sheets Trigger node and set the correct Spreadsheet and Sheet for your Companies tab. Confirm the polling interval fits your needs.
8. Open the Select Unprocessed Companies and related filter or if nodes. Ensure the Status column name matches your sheet and the values Pending and Processed are correct.
9. In the Add Contacts and Enrich Contacts nodes, confirm column mappings match your Contacts sheet headers, including fields for email status and LinkedIn profile URL.
10. Test the domain path: add a company name without a website in the Companies sheet. Approve or fix the suggested website from the Slack message, then confirm the row updates in the sheet.
11. Run a small list to test people search and enrichment. Check the Contacts sheet and the Verified tab formula to ensure only verified emails appear.
12. Open the Weekly Report Trigger node to set the day and time. Confirm the Send Weekly Report node posts to the right Slack channel.
13. If calls fail, check that API keys are valid, confirm rate limits in Apollo.io, and verify Google Sheets permissions for the connected account.