
Closed
Posted
Paid on delivery
I need a Microsoft Power Automate flow that, once a day, reads a list of product URLs from my Google Sheet, visits each item on [login to view URL] and [login to view URL], then writes three fresh values back to the same row: the current price, the star rating, and a simple flag that shows whether any coupon or deal is live. I do not have official API access, so the solution will have to rely on reliable web-scraping or public endpoints that you discover and maintain. The update must run unattended every 24 hours, overwrite yesterday’s numbers, and leave a time-stamp so I can quickly confirm the job succeeded. Should any product page change structure or throw a block, the flow must log the error and continue with the remaining URLs rather than stopping altogether. Deliverables • A ready-to-run Power Automate cloud flow (or a hybrid Azure Function/Python script triggered by Power Automate if scraping libraries are needed) • A clean Google Sheet connector step that maps URL → price, rating, coupon/deal flag, timestamp • Setup notes that cover required gateways, browser headers, and how to add or remove products in future Acceptance criteria • Daily run completes in one pass with no manual intervention • 100 % correct capture of price, rating, and coupon/deal status for at least 20 sample SKUs on both sites • Error handling writes a clear message to a separate “Logs” tab and emails me only when a critical failure occurs • All code, credentials, and instructions are delivered so I can redeploy in another tenant if needed If this matches your skill set, please tell me how you plan to scrape without APIs and approximately how much load time per URL you expect. Alsom we need to develop a mechanism that prevents us in getting blocked or getting identified as a bot.
Project ID: 40527688
12 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average ₹8,927 INR for this job

Have over 18 years of experience in data mining/ Web scrapping/ Scraping Bots/ Chrome/Opera Extensions I have done it all. Tell us your source and we will put it in excel for you, Or we can even give you filtered results as per your requirement, In the format you want. You can also ask for data into a particular format - Excel, Json, Mysql, Databases, XMLs, you name them. Further Can help you with integrating it with ur databases, Can create json outputs. We are not only good with scraping but also with the tools that u may need after that. We can help you build you softwares round the data we have 99% Data Accuracy. We have Duplicate finder. etc., We can help with Statistics on the data We can help with creating Api's front the data We can create Softwares to manage that data We can build Sites round the data
₹7,000 INR in 1 day
6.9
6.9

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can do your automation for Amazon & Flipkart Data from your Google Sheet according to your exact requirements. Why You Need To Go With Us? And What Special you get with us. • Your vision = Our mission • Your idea + Our expertise = Winner on Web • Cutting edge web technology & design • Innovative, Cost effective & Customized service • Pragmatic Approach • Constant communication with clients • Consistent performance • On-time delivery • Maintenance of global quality standards • Your online business + Our experience = Your success Python, Data Analytics, Data Science Portfolio IoT Data Analysis for Dairy Refrigerator Temperature Monitoring Real-time Object Detection using OpenCV and YOLO Supply Chain Management System Enterprise Data Warehouse Implementation Cloud Data Lake Migration Web Application Development for Wind Turbine Performance Prediction Data Analytics Platform for Supply Chain Optimization AI Bill System AI Try Dress
₹12,500 INR in 15 days
4.4
4.4

Hello, I see you need a reliable solution for automating data extraction from Amazon and Flipkart. I am Mubashir, a Full-Stack Developer with 6+ years of experience in web scraping and automation. I'll create a Power Automate flow that meets your requirements. Deliverables: - Set up a Microsoft Power Automate flow to read product URLs from Google Sheets daily - Implement web scraping techniques using Python to extract required data from Amazon and Flipkart - Ensure error handling and unattended execution - Log errors and write results back to the Google Sheet - Include a timestamp and setup notes for future product additions or changes - Implement strategies to avoid bot detection PROCESS: - Set up Power Automate flow to read product URLs from Google Sheets - Implement Python web scraping techniques to extract data from Amazon and Flipkart - Ensure error handling and unattended execution - Log errors and write results back to the Google Sheet - Implement strategies to avoid bot detection My Portfolio: https://www.freelancer.com/u/mubashir021/Automation-Expert Mubashir Ahmed
₹9,580 INR in 10 days
0.6
0.6

India
Member since Jun 28, 2017
₹1500-12500 INR
₹600-1500 INR
$250-750 USD
$80-100 AUD
₹2000-3000 INR
$250-750 NZD
₹12500-37500 INR
$10-30 USD
₹600-1500 INR
$10000-20000 USD
₹1500-12500 INR
€10-30 EUR / hour
₹100-400 INR / hour
₹600-1500 INR
₹750-1250 INR / hour
$10-30 CAD
₹12500-37500 INR
₹1500-12500 INR
$2-8 USD / hour
$250-750 CAD
₹1250-2500 INR / hour
₹600-1500 INR