I already keep a Google Sheet where I enter the product name and invoice price from each new paper invoice. What I need is an automated way to fill in everything else so the file can go straight into Shopify with zero manual chasing. Here’s the flow I have in mind: 1. I add or paste the product names (and invoice price) into the sheet. 2. Your script fires—either on-demand or via a simple trigger—and does three things for every new row: • Looks up the regular retail trading price, first on coles, woolworths, chemist warehouse if that fails, on a trusted third-party retailer site. • Flags the dietary metafields (paleo, fair_trade, organic, keto, vegetarian, gluten_free, vegan) as TRUE/FALSE in separate columns that match my Shopify bulk-import template. • Grabs a high-resolution product image, saves it to a designated Google Drive folder, and writes the shareable link back into the sheet. Everything ends up in the exact column structure Shopify expects, so I can export to CSV and bulk-upload without edits. Technical flexibility • I’m open to Python (Requests/BeautifulSoup/Selenium), Google Apps Script, or another approach as long as it handles rate limits and doesn’t break when a site tweaks its HTML. • Feel free to recommend the cleanest way to keep credentials secure and add retry logic for pages that throw CAPTCHAs or timeouts. Deliverables • Fully-commented source code. • A one-sheet setup guide so I can deploy it again if the sheet moves. • A quick demo run on five sample products to prove everything wires up correctly. If you have smarter ideas to streamline any step, let me know—efficient automation is the whole point of the project.