My wife and I are planning on moving this year. We have several criteria that we would like a city to have, so instead of doing the research manually and having to visit several websites to copy/paste data, I built a scenario that does the bulk of it for me. All I do is enter the zip code and city/state in variables and the scenario does the rest!
Hopefully you guys will appreciate what went into this. My wife said it was “neat” ![]()
All of the collected data goes into a nicely formatted Google Doc for printing or sharing.
It outputs the following:
- Names the Google Doc: “Report for city/state”
- A brief summary and history about the city. (OpenAI)
- Current weather (weather app, Math app to convert Celsius to Fahrenheit)
- Weather forecast for the next 2 weeks (weather app, Math app to convert Celsius to Fahrenheit)
- Cost of Living (OpenAI)
- Demographics (OpenAI)
Lists 10 of each:
- Hospitals (Google Maps)
- Restaurants (Google Maps)
- Grocery stores (Google Maps)
- Coffee shops (Google Maps)
- Parks (Google Maps)
- Bars & Clubs (Google Maps)
- Museums and Art Galleries (Google Maps)
Creating a new branch is as easy as copying the last one and replacing the search term I want. For example, if I wanted to add dog parks or bike trails, I select the whole branch and then copy/paste the apps into a new branch and edit for those keywords.
To avoid Google Maps limits and errors (I think my API only allows so many results per time period.), I added 1 minute delays for each branch running Google Maps.
Overall, it was fun to put together, but it drains my operations quickly and it takes about 15 minutes to complete. I think my next phase may be to create an online form to enter the zip/city/state and then email a URL to the Google Doc…we’ll see.

