I would like to get a script or automation program to automate the incoming emails in a shared mailbox to be automatically categorized to employees by turn, and if in the email it is mentioned a specific user then it would be categorized to that user.
The script would have to do the following: 1. Open URL 2. Search in HTML for the word "shopify" 3. If "Shopify" is found then that means it's a shopify store The script will then have to input the data (Yes or No) in Google sheets or excel.
I want to automate repetitive weekly reporting tasks that I am running manually. I remotely connect to store SQL Server databases to generate a sales report in a specific formatted text file that I then upload to a SFTP site. Database connection credentials and SFTP credentials vary by store. Currently I have Hamachi VPN installed at each store location and I manually run connect via ODBC and run Crystal Reports to generate a formatted text file that I then manually upload to SFTP site(s). I want to automate as much of this as possible.