Overshot — find the TikToks breaking out, and what they're selling

Loading video…

Building Menu Macros Part 3: Scraping Data

@ceosano

9.7K followers · usually 9.9K views a post

Views

160.0K

Likes

5.0K

Comments

157

167

Selling · Other Product

Menu Macros Restaurant Fetching https://docs.google.com/spreadsheets/d/1xXL4Wqtb-cnKOFxmcY7Zgqdhw/edit#gid=0 ↗

Why it worked

The video demonstrates a practical application of data scraping and AI analysis, solving a common problem for those interested in restaurant data. The use of a custom macro and ChatGPT makes the process seem accessible and efficient.

Summary

The creator demonstrates a process of scraping restaurant names from Yellow Pages Toronto into an Excel sheet using a custom macro. They then use ChatGPT to identify which of these restaurants are likely chain restaurants with online nutritional data.

Structure

1Scraping restaurant names from Yellow Pages
2Saving data to an Excel sheet
3Using ChatGPT to identify chain restaurants
4Reviewing the results from ChatGPT

Product placement

The video shows a Google Sheet with restaurant names being populated by a script, and then the creator pastes this data into ChatGPT to analyze it.

On-screen text

Building Menu Macros Part 3: Scraping Data Untitled project - Project B: Menu Macros Restaurant Fetching Menus Untitled project - Project B: How can I help you today? Improve my essay writing ask me to outline my thoughts Help me debug a linked list problem Write a text message asking a friend to be my plus-one at a wedding Brainstorm incentives for a customer loyalty program in a small bookstore what are the chain restaurants that likely have nutritional menus online in the following text: Paste ChatGPT Here's a list of the chain restaurants from your text that likely have nutritional data posted online due to their nature as chains: 1. A&W 2. Ajisen Ramen 3. Ali Baba's Middle Eastern Cuisine 4. Alice Fazoolis's Italian Grill 5. Amaya Express 6. Applebee's 7. Arby's 8. Aroma Espresso Bar 9. Arthur Treacher's 10. Asian Legend 46. Dunkin' Donuts 47. Earl's Kitchen + Bar 48. East Side Mario's 49. Eggsmart 50. Extreme Pita 51. Fat Bastard Burrito 52. Five Guys 53. Freshii 54. Fuzzy Peach Frozen Yogurt 55. Golden Griddle 56. Goodlife Pizza 57. Harvey's 58. Hero Certified Burgers 59. Hooters 60. IKEA Restaurant 61. Jack Astor's Bar & Grill 62. Jollibee 63. JOEY Restaurant 64. Kelsey's 65. KFC 66. Little Caesars 67. Mamma's Pizza 68. Manchu Wok 69. McDonald's 70. Menchie's Frozen Yogurt 71. Milestones 72. Montana's BBQ & Bar 73. Mr. Greek 74. Mr. Sub 75. Mucho Burrito 76. Nando's 77. New York Fries 78. Olive Garden 79. Osmow's 80. Panda Express 81. Panera Bread 82. Papa John's Pizza 83. Paramount Fine Foods 84. Perkins Restaurant & Bakery 85. Philly's 86. Pita Pit 87. Pizza Hut 88. Popeyes Louisiana Kitchen 89. Quesada Burritos & Tacos 90. Quimos 91. Red Lobster 92. Richtree Natural Market Restaurants 93. Ruby Tuesday 94. Sbarro 95. Second Cup 96. Shakey's Pizza 97. Smoke's Poutinerie 98. Starbucks 99. Subway 100. Swiss Chalet 101. Taco Bell 102. Tandoori Flame 103. Teriyaki Experience 104. Thai Express 105. The Cheesecake Factory 106. The Keg Steakhouse & Bar 107. Tim Hortons 108. Turtle Jack's 109. Wendy's 110. Wild Wing 111. Williams Fresh Cafe 112. Wing Machine 113. Yogen Früz 114. Zoup! This list focuses on well-known chain restaurants that typically operate in multiple locations and are more likely to have standardized nutritional information available online. Nice! It made it to the end