I am using Google Sheets to generate image URLs on a list of things by using ImportXML function.
Example:
Cell A1 = Flower
Cell B1 ="https://www.google.com/search?q="&A1&"&source=lnms&tbm=isch"
Cell C1 =transpose(importxml(B1,"//img/@src"))
Really cool! This is what happens:
No comments:
Post a Comment