Need to automate navigating a vendor portal and downloading a report

I would like to automate the downloading of a weekly report from my vendor’s website.
The general steps involved are:

  1. login to the site
  2. choose the reporting page
  3. choose the report to run
  4. update parameters for this weeks run
  5. run the report
  6. choose to download the report as a CSV file and name the downloaded file

Can anyone suggest the Make module(s) that I should be using to accomplish this task?

Apify Web Scraper + Make and a place for storage such as google drive should be able to do this.

The free tier of Apify should be enough for weekly 1 csv download, depends if the client portal has anti-scraping measures in place how hard this would be.

It is a bit of a technical solution though.

alternatively, if when you update the parameters, it also updates the URL, you could probably just pass the CSV download URL direct to make, with copied login cookies.

Additional Notes:

To do Some of this without Apify. (I Just re-confirmed this works in make)

This is an example of logging into rototgrinders.com
highlighted fields are the important ones.

Get Login Field ID’s (Keys)

Made by William Cowan with Scribe

1. Go to the sign in page and right click on the username field

Screenshot

2. Click Inspect in the Menu

3. you should go strait to the element, find its id
id="xxxxx"

Screenshot

4. Copy the fields ID

Screenshot

5. do the same for password

Screenshot

Made with Scribe

then enable share cookies with all html modules.
you should now be logged in for the duration of your run.

2 Likes

Hi @JugaadiTech,
Thanks for this example.
I’ve tried replicating this using a dummy login page
https://the-internet.herokuapp.com/login

As you can see, getting a 404 error.
Any ideas?

Thanks