u/prdcrman

Last week I had a simple workflow that made Comet valuable. Extract data from a browser-based database, and insert the information into a google Sheet, with all data going into appropriate fields. Worked great. Today the agent browser won't do it. Anybody recommend an agentic browser that can still do this work? Step 1: ### PHASE 1: Extract ALL Records from XYXYXYXYXYXY browser Tab Click the pencil icon for each visible record in the grid and extract these fields:

1. Ship Date (from the "Ship Date" column in MM/DD/YYYY format)
2. Invoice Number (format: TA000XXXX)
3. Purchaser's Full Name
4. Complete Shipping Address (full address with city, state, ZIP)
5. Total Quantity of Bottles (# of line items)
6. Grand Total (the final price including tax and shipping)
7. Sales Tax (breakdown amount)
8. Shipping Cost (breakdown amount)
9. UPS Tracking Number Step 2: ### PHASE 2: Populate Google Sheets Tab Navigate to the "Testing XYXYXYXYXY Shippers Report, part two" tab and fill in ALL extracted records at once. One piece of data for each field based on the column mapping below. There should be one row for each record.

Column Mapping:

• Column A: Date Shipped (MM/DD/YYYY from Ship Date)
• Column B: Invoice # (from DATABASE NAME Invoice Number)
• Column C: Name (Purchaser's Full Name)
• Column D: Address, City, State & Zip (Complete Shipping Address)
• Column E: Type W/C (enter "W" for all records - Wine)
• Column F: # of Bottles (Total Quantity)
• Column G: Size in Liters (enter "750ml" for all records)
• Column H: Total Liters (calculate: # of Bottles × 0.75)
• Column I: Brand Name (OUR BRAND NAME)
• Column J: Total Price (Grand Total)
• Column K: Common Carrier # (UPS Tracking Number)