Step 2: Connect Google Sheets

Pull prospects from a Google Sheet and enable updates for found and missing emails.

1. Open Retrieve Prospect List and set Document to Find Email by Company and Sheet to Foglio1.
2. In Retrieve Prospect List, keep the filter on PROCESSING (lookup column), matching your sheet’s processing logic.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Prospect List.
4. Open Update Found Email and set Operation to Update, Document to Find Email by Company, and Sheet to Foglio1.
5. Map columns in Update Found Email to:
   • EMAIL → {{JSON.stringify( $json.emails) }}
   • PROCESSING → x
   • row_number → {{ $('Iterate Records').item.json.row_number }}
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Found Email.
7. Open Update Missing Email and set Operation to Update, Document to Find Email by Company, and Sheet to Foglio1.
8. Map columns in Update Missing Email to:
   • EMAIL → =
   • PROCESSING → x
   • row_number → {{ $('Iterate Records').item.json.row_number }}
9. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Missing Email.

Step 3: Set Up the Processing and Lookup Logic

Split the incoming list, call the email discovery API, and route results based on status.

1. Keep Retrieve Prospect List connected to Iterate Records to process one row at a time.
2. In Company Email Lookup, set URL to https://api.anymailfinder.com/v5.1/find-email/company and Method to POST.
3. In Company Email Lookup, enable Send Body and add body parameters:
   • domain → {{ $json["WEBSITE"] }}
   • company_name → {{ $json["COMPANY NAME"] }}
4. Set Authentication in Company Email Lookup to genericCredentialType with Generic Auth Type httpHeaderAuth.
5. Credential Required: Connect your httpHeaderAuth credentials in Company Email Lookup.
6. In Route by Status, keep the rules using {{ $json.email_status }} for outputs valid, risky, and not found.

Step 4: Configure Output and Notifications

Update the sheet based on routing and alert via Telegram when no email is found.

1. Ensure Route by Status outputs to Update Found Email for valid and risky statuses, and to Update Missing Email for not found.
2. In Notify via Telegram, set Text to Alert! Email not found and Chat ID to [YOUR_ID].
3. Credential Required: Connect your telegramApi credentials in Notify via Telegram.
4. Keep the loop connections so Update Found Email → Iterate Records and Notify via Telegram → Iterate Records to continue processing all rows.

Step 5: Test and Activate Your Workflow

Run a manual test, confirm updates in the sheet, and then activate the workflow for production use.

1. Click Execute Workflow from Manual Execution Start to run a test.
2. Verify that rows with found emails are updated by Update Found Email and missing emails are updated by Update Missing Email.
3. Confirm that Notify via Telegram sends a message when email_status is not found.
4. Once results look correct, toggle the workflow to Active to enable production use.