Hi, I have need for someone to create a bot for me.
From reading through your feedback and reviewing your resume, you seem more than qualified.
Here's what I need:
NOTE: I was unable in this submission to upload the 3 sheets so you could visualize how it will look. I will try again after I send you this.
The Bot opens a sheet of product data (Master Sheet-Beginning -attached)
The only column it deals with here is column A, which is the product title. I'm thinking in order to avoid resources problems or crashing we can start with the capability to do 50 items(titles) at a time?
It then copies the title (starting at A2) and pastes it into the google adwords keyword tool under the setting "phrase."(to avoid captcha, I would need to be logged in to my adwords account I gather)
It then downloads the data into an excel file which it will then place that data in an excel file. (See attached Excel file"choose-keyword-sheet" -attached)
All the data is placed as shown in my example excel sheet.(Remove quotes from data/phrases)
The bot then opens up a browser to [url removed, login to view] and proceeds to do a search for each keyword/phrase listed in Column F. After each search it needs to read and copy the search results number (example: search on [url removed, login to view] for beaded anklets, you will see that there is 1,074 results. That is the data it will place into column M (Amazon Search Results)
Once it goes through each keyword and is finshed reporting the data for each keyword, I then need it to create check marks or some way to check off which keywords I want to use. Amazon only allows 5 keywords to be used. So it should only allow me to choose 5. If I choose more it needs to tell me I have maxed out.
So what we have is a bot that will do 100 google adword keyword tool searches It will then place all that data on a sheet, then do searches on [url removed, login to view] for each and every keyword for each and every title. This will then give me a clear picture of where I can be competitive in [url removed, login to view]'s search engine. I can then check off 5 keywords for each title.
Finally, when I have checked 5 keywords/phrases for the 100 items, it will then take that data and place it into the 3rd and final sheet that I have provided an example of to you. (Master Sheet-Completed)
The search terms are marked in blue. The first search term is the first one that I select.. The the 2nd, 3rd and so on. You can look at the choose-keyowrds-sheet to see ( I have no idea how to make check boxes appear so I just wrote in where I would have checked the box).
I wll then have my data sheet of 100 items with all their keywords. :0)
Let me know if you can do this for me and how much it will cost.