Project description:

I need someone (who is an expert in using UBot) to create a bot that will monitor the following Google Sheet.

I also need a high degree of confidence that the final product will be robust and reliable. 

START

When a text string variable Author #1 is entered into cell A2 of the “Instances” sheet (Google Sheet), the bot will do the following…

Step 1 – Search Google for Author #1 and return all the results from the “People also search for” link on the Google search page.

Step 2 – The results from “People also search for” are populated in fields B2 through Y2 (Google Sheet).

Sample – William Shakespeare

Step 3 – Repeat so that cells B(x) through Y(x) are populated based on all variables in column A (Google Sheet). 

Next, we switch to the “Instances” sheet, and the bot will do the following…

Step 4 – Search Google for Author #1 Quotes and return all the results. There will be ten (10) or less. These need to populate into cells B2 through Y2 (Google Sheet).

As an example, William Shakespeare returns the following quotes…

populated in Cell B2: Be not afraid of greatness: some are born great, some achieve greatness, and some have greatness thrust upon them.

populated in Cell C2: To thine own self be true, and it must follow, as the night the day, thou canst not then be false to any man.

populated in Cell D2: The course of true love never did run smooth.

populated in Cell E2: There is nothing either good or bad, but thinking makes it so.

populated in Cell F2: Love looks not with the eyes, but with the mind; and therefore is winged Cupid painted blind.

populated in Cell G2: Cowards die many times before their deaths; the valiant never taste of death but once.

populated in Cell H2: If music be the food of love, play on.

populated in Cell I2: Love all, trust a few, do wrong to none.

populated in Cell J2: Life … is a tale Told by an idiot, full of sound and fury, Signifying nothing.

populated in Cell K2: Men at some time are the masters of their fates: The fault, dear Brutus, is not in our stars, but in ourselves, that we are underlings.

Step 5 – Repeat so that cells B(x) through Y(x) are populated based on all variables in column A (Google Sheet). 

END of project.