![]() Hover over the author’s byline and right-click to bring up the menu and click "Inspect Element" as shown in the following screenshot: New York Times inspect element selection But first we need to see how the New York Times labels the author on the webpage, so we can then create a formula to use going forward. Note – I know what you’re thinking, wasn’t this supposed to be automated?!? Yes, and it is. ![]() Navigate to the website, in this example the New York Times: New York Times screenshot Let’s take a random New York Times article and copy the URL into our spreadsheet, in cell A1: Example New York Times URL ![]() ![]() Grab the solution file for this tutorial:įor the purposes of this post, I’m going to demonstrate the technique using posts from the New York Times. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |