Скачать или смотреть হাজার টাকা ইনকাম হাতে টাকা স্মার্টফোন বা ল্যাপটপ দিয়ে। @ahmedeven

import smtplib
import gspread
from oauth2client.service_account import ServiceAccountCredentials
import requests

Google Sheets অ্যাক্সেস সেটআপ
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/drive"]
creds = ServiceAccountCredentials.from_json_keyfile_name("your-google-credentials.json", scope)
client = gspread.authorize(creds)

শিট ওপেন করে ডাটা পড়া
sheet = client.open("Leads Database").sheet1
leads = sheet.get_all_records()

Hunter.io API দিয়ে B2B লিড সংগ্রহ
HUNTER_API_KEY = "your-hunter-api-key"
def get_email_from_domain(domain):
    url = f"https://api.hunter.io/v2/domain-searc...{domain}&api_key={HUNTER_API_KEY}"
    response = requests.get(url).json()
    emails = response.get("data", {}).get("emails", [])
    return emails[0]["value"] if emails else None

SMTP দিয়ে অটোমেটিক ইমেইল পাঠানো
EMAIL_ADDRESS = "[email protected]"
EMAIL_PASSWORD = "your-email-password"

def send_email(to_email, subject, message):
    with smtplib.SMTP("smtp.gmail.com", 587) as server:
        server.starttls()
        server.login(EMAIL_ADDRESS, EMAIL_PASSWORD)
        email_message = f"Subject: {subject}\n\n{message}"
        server.sendmail(EMAIL_ADDRESS, to_email, email_message)

লিড প্রসেস করা এবং ইমেইল পাঠানো
for lead in leads:
    company = lead["Company"]
    domain = lead["Website"]
    email = get_email_from_domain(domain)

    if email:
        subject = f"B2B Collaboration Opportunity with {company}"
        message = f"Dear {company},\n\nWe are interested in partnering with you for {lead['Job Role']} services.\n\nBest Regards,\nYour Company"
        send_email(email, subject, message)
        print(f"Email sent to {email}")

print("All emails sent successfully!")