Python Forum

I recently started a new role in data analytics.

One of my daily tasks is as follows:
1. Log in to www.SalesRabbit.com
2. Navigate to a new page within the site using a sidebar
3. Manually copy-paste sales data from a table to Excel file.

I have no background in Python but saw information regarding Web Scraping and getting past a log-in page.

My question is: Is it possible to automate a process using Python that will go to the website, navigate to the new page, and pull the required data to an output file?

Yeah, you can do all that. The process is a bit longer than you think though. I'll try to break it down.

1. Use Selenium to Log in.
2. Use the Beautiful Soup library to parse the data.
3. openpyxl library to write the data to excel.

there is an API, so it's definitely worth checking if the information is available via API
https://developers.salesrabbit.com/v1/ge...troduction