Automate Excel with Retail Website Data
Budget: $250 – $750 USD
I'm seeking an Excel expert to help me automate fetching data from a retail website into Excel.
Key Requirements:
- Connect Excel to the internet for data fetching
- Automate the process of data collection
- Use of AI tools or Excel.AI for task automation
Data to be Collected:
- Product listings and prices
- Customer reviews and ratings
- Sales and promotions
- As much data as possible including pictures, links to the site, ASIN
- Gather details on shipping options and delivery times
- Include real-time stock availability and inventory counts
- Capture detailed product specifications and features
- Fetch competitor prices for similar products
Ideal Skills and Experience:
- Proficiency in Excel
- Experience with task automation in Excel
- Familiarity with data extraction from retail websites
- Knowledge of AI tools and Excel.AI
Please note, I want this process to be as automated as possible. The final goal is to have a seamless and efficient data collection system set up in Excel.
Set up updates for the data in Excel on a daily basis. If there are other preferred methods for data extraction, please specify: not techy and easy to use options. Update the data in Excel on a daily basis. Ensure the data updates once daily, ideally during off-peak hours. The data should be updated once daily, ideally during off-peak hours. Create interactive dashboards within Excel to visualize the collected data. Create highly interactive dashboards with advanced features such as drill-downs and dynamic charts. Use web scraping tools for data extraction. Please present the final data in a neatly organized table format in Excel. Preferably, use API integration methods for data extraction.
Key Requirements:
- Connect Excel to the internet for data fetching
- Automate the process of data collection
- Use of AI tools or Excel.AI for task automation
Data to be Collected:
- Product listings and prices
- Customer reviews and ratings
- Sales and promotions
- As much data as possible including pictures, links to the site, ASIN
- Gather details on shipping options and delivery times
- Include real-time stock availability and inventory counts
- Capture detailed product specifications and features
- Fetch competitor prices for similar products
Ideal Skills and Experience:
- Proficiency in Excel
- Experience with task automation in Excel
- Familiarity with data extraction from retail websites
- Knowledge of AI tools and Excel.AI
Please note, I want this process to be as automated as possible. The final goal is to have a seamless and efficient data collection system set up in Excel.
Set up updates for the data in Excel on a daily basis. If there are other preferred methods for data extraction, please specify: not techy and easy to use options. Update the data in Excel on a daily basis. Ensure the data updates once daily, ideally during off-peak hours. The data should be updated once daily, ideally during off-peak hours. Create interactive dashboards within Excel to visualize the collected data. Create highly interactive dashboards with advanced features such as drill-downs and dynamic charts. Use web scraping tools for data extraction. Please present the final data in a neatly organized table format in Excel. Preferably, use API integration methods for data extraction.