I need a script built that does the following once per day:
1) Visits [login to view URL]
2) Logs in (using our login credentials)
3) Goes to a URL that displays some data in a table ([login to view URL]!/app/reports/media)
4) Change some drop-down parameters (e.g. to show yesterday's data only AND select the option to display the tracking code)
5) Extracts the data displayed in the table and paste it into a Google Sheet. This must be outputted in the Google Sheet as shown below (one value per cell) so that we can run formulas on it. I.e. you CANNOT just take a screenshot of the data - it needs to be actually in the cells in Google Sheets.
This script needs to automatically do this once per day.
The login details need to be stored securely in the script.
You can use Zapier to post the data into the spreadsheet if easier than authenticating with Google Sheets (i.e. you could just post the table data to a webhook). But it's up to you how you want to do it.
24 freelancere byder i gennemsnit £161 på dette job
Hello sir, i will build a script to login on the site by your user ID and pass then it will get the data from the site as you showed in the attached files to update on google drive .
*** I have checked your description and website. I can build the app with your points. I have a question. Do you need desktop app or web app? I want to discuss with you this project.
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA, google scripts. I can do this task. Please come on chat for more details. Awaiting your response. Thank you.
Hi this can be done by web automation. I can create a Python script for this and it will take me max of 3 days to develop and test it. Please message me to discuss and work on it.