Hello,
You could use the same method as you did on send value to Google Sheet, but change the return value read from the sheet.
That's all. If you could send me your code/sketch I could do the test on my wemos mini D1.
Let me know.
Best Regards,
Khamid