Categories

Google Leads Generation using LeadsFynder

✅ TASK: Lead Generation from LeadsFynder AI to Google Sheets

???? PART 1: Generate Leads on LeadsFynder AI

Step 1: Log In

  1. Go to https://leadsfynder.com

  2. Log in with the provided credentials.

Step 2: Open Google Leads Tool

  1. From the left-hand menu, click "Find Leads" > "Google Leads".

Step 3: Enter Search Details

  1. Open the spreadsheet titled “LeadsFynder VA Task Sheet” (provided by Max).

  2. For each row in the sheet:

    • Copy and paste the Keyword into the Keyword field.

    • Copy and paste the Location into the Location field.

    • Select 10 km (or the listed Search Area) from the “Area” dropdown.

  3. Click the Search button.

Step 4: Export Leads

  1. Once results load, scroll to the bottom or locate the “Export” or “Download CSV” button.

  2. Download the file and save it using this naming format:
    Keyword_Location.csv
    (e.g., barber_shop_Atlanta_GA.csv)

  3. Repeat for each combination in the task sheet.

???? PART 2: Upload to Google Sheets

Step 5: Organize Your Files

  1. Create a new folder in your Google Drive:
    “LeadsFynder CSVs”

  2. Upload all downloaded CSV files into this folder.

Step 6: Create a Master Google Sheet

  1. In Google Drive, click “New > Google Sheets”

  2. Name it: "Leads Master Sheet - [Date]"

  3. In the first tab, name it: All Leads Combined

Step 7: Combine CSVs into Master Sheet

  1. For each CSV file:

    • Open it

    • Select all data (Ctrl + A)

    • Copy and paste it into the All Leads Combined tab under the existing data.

    • Leave a column to indicate the Keyword and Location the leads came from.

    ✅ Example columns to add:

    • Search Keyword

    • Search Location

    • Date Pulled

???? Final Review and Delivery

Step 8: Clean Up & Format

  1. Make sure all columns are aligned correctly (Business Name, Phone, Website, etc.)

  2. Remove duplicates if any.

Step 9: Share with the Team

  1. Click Share in the top right of the Google Sheet.

  2. Share access with IT Teams Gmail: innovativeglobalentitiesitteam@gmail.com

  3. Notify via Teams chat: Max, Emmanuel, and Kasim
    “The Leads Master Sheet for [Date] is complete and shared with you.”