【業務自動化革命】Playwright+Selenium二段階アプローチ！安定ブラウザ自動操作の5つの実践技法

1. 実際のブラウザでページを開く
2. 複数のセレクタパターンを試行
3. 最も安定したセレクタを発見
4. 動作タイミングを確認

# 自動生成される堅牢なスクリプト例
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC
import logging
import time

class BusinessAutomation:
    def __init__(self):
        self.setup_logging()
        self.driver = self.setup_driver()

    def setup_logging(self):
        logging.basicConfig(level=logging.INFO)
        self.logger = logging.getLogger(__name__)

    def safe_click(self, selector, timeout=10, retry=3):
        """安全なクリック処理（リトライ付き）"""
        for attempt in range(retry):
            try:
                element = WebDriverWait(self.driver, timeout).until(
                    EC.element_to_be_clickable((By.CSS_SELECTOR, selector))
                )
                element.click()
                self.logger.info(f"Successfully clicked: {selector}")
                return True
            except Exception as e:
                self.logger.warning(f"Click attempt {attempt + 1} failed: {e}")
                time.sleep(2)
        return False

1. 経費精算システムにログイン
2. 「新規登録」ボタンの最適セレクタを特定
3. 各入力フィールドの識別方法を確認
4. 保存処理のタイミングを測定

def process_expenses(self, csv_file_path):
    """CSVファイルから経費データを読み込み、自動入力"""
    expenses = pd.read_csv(csv_file_path)

    for index, expense in expenses.iterrows():
        try:
            # 新規登録画面を開く
            self.safe_click("button[data-action='new-expense']")

            # 日付入力（カレンダー対応）
            self.input_date("input[name='expense-date']", expense['date'])

            # 金額入力（バリデーション待機）
            self.input_amount("input[name='amount']", expense['amount'])

            # 説明入力
            self.safe_input("textarea[name='description']", expense['description'])

            # 添付ファイル（非同期アップロード）
            if expense['receipt_path']:
                self.upload_receipt(expense['receipt_path'])

            # 保存処理
            if self.save_expense():
                self.logger.info(f"Expense {index + 1} processed successfully")
            else:
                self.logger.error(f"Failed to save expense {index + 1}")

        except Exception as e:
            self.logger.error(f"Error processing expense {index + 1}: {e}")
            self.capture_screenshot(f"error_expense_{index + 1}.png")

class CompetitorPriceMonitor:
    def __init__(self):
        self.results = []
        self.setup_driver_with_stealth()

    def monitor_all_competitors(self):
        competitors = [
            {'name': 'CompanyA', 'url': 'https://...', 'method': self.scrape_company_a},
            {'name': 'CompanyB', 'url': 'https://...', 'method': self.scrape_company_b},
            {'name': 'CompanyC', 'url': 'https://...', 'method': self.scrape_company_c},
        ]

        for competitor in competitors:
            try:
                prices = competitor['method'](competitor['url'])
                self.results.append({
                    'company': competitor['name'],
                    'prices': prices,
                    'timestamp': datetime.now()
                })
            except Exception as e:
                self.send_alert(f"Failed to scrape {competitor['name']}: {e}")

    def scrape_company_a(self, url):
        """JavaScript動的価格に対応"""
        self.driver.get(url)

        # 動的コンテンツの読み込み待機
        WebDriverWait(self.driver, 10).until(
            EC.presence_of_element_located((By.CLASS_NAME, "price-loaded"))
        )

        prices = []
        price_elements = self.driver.find_elements(By.CSS_SELECTOR, ".product-price")
        for element in price_elements:
            prices.append({
                'product': element.get_attribute('data-product'),
                'price': element.text
            })
        return prices

def download_monthly_reports(self, target_month):
    """月次レポートの一括ダウンロード"""
    reports = [
        {'name': 'sales', 'selector': '#sales-report-btn'},
        {'name': 'inventory', 'selector': '#inventory-report-btn'},
        {'name': 'customer', 'selector': '#customer-report-btn'},
    ]

    for report in reports:
        try:
            # 日付範囲設定
            self.set_date_range(target_month)

            # レポート生成
            self.safe_click(report['selector'])

            # 生成完了待機（進行状況バー監視）
            self.wait_for_report_generation()

            # ダウンロード実行
            download_path = self.download_report(report['name'], target_month)

            # ファイル整理
            self.organize_downloaded_file(download_path, report['name'])

        except Exception as e:
            self.logger.error(f"Failed to download {report['name']}: {e}")

import os
from cryptography.fernet import Fernet

class SecureCredentials:
    def __init__(self):
        self.cipher = Fernet(os.environ['AUTOMATION_KEY'])

    def get_credentials(self, service_name):
        encrypted_data = os.environ[f'{service_name}_CREDENTIALS']
        return self.cipher.decrypt(encrypted_data.encode()).decode()

def send_alert(self, message, severity='WARNING'):
    """業務チームへのアラート通知"""
    if severity == 'CRITICAL':
        # Slack/Teams通知
        self.send_slack_notification(message)
        # メール通知
        self.send_email_alert(message)
    else:
        # ログ記録のみ
        self.logger.warning(message)

# automation_config.yaml
selectors:
  login_button: "button[data-testid='login']"
  amount_field: "input[name='amount']"
  save_button: ".save-action"

timeouts:
  page_load: 10
  element_wait: 5
  download_wait: 30

retry_counts:
  click_retry: 3
  input_retry: 2