I have attached an Excel spreadsheet that more clearly explains what I need done.
Essentially, I would like a custom function created that queries Google for a defined keyword and returns a list of results based on a few parameters.
At the top of the spreadsheet I would like to input the following:
1. Keyword: this will be the query to search on Google
2. Domain: this will be the Google domain extension I want searched. (i.e.: .com, .ca, [login to view URL], etc)
3. Pages: this will be the limit of how many pages to search through. For example, 10 would search through the first 100 results.
4. Subfolders: THIS IS THE MOST IMPORTANT PART OF THE ENTIRE FUNCTION. I would like to limit how many subfolders a result is allowed to have. For example, 1 would mean only the top level domain (i.e. [login to view URL]). 2 would mean only one slash (i.e.:[login to view URL]). 3 would mean two slashes ([login to view URL]). And so on…
The function would then output the following:
1. URL: The URL of the result found
2. Rank: The URL’s rank on Google for the inputted search term
3. Page Title: The title of the website contained between the website's <Title> </Title> tags.
Please take a look at the attached spreadsheet, as I would like for it to work as I have layed it out in the .xlsx file.
Thank you.
I am expert on excel/PHP/VB/Software Architecure etc. Please check me. You also give me amount on work completion with 5 stars.
Thanks.
Regards,
Fakhar Naqvi