@britagrace
Ok, awesome! So, depending on your comfort level, there might be an 'easier' way. In quotes because it may seem scary for a non-coder (not sure where you are on that spectrum), but will require much less clean-up after bringing the data in. Anytime you are looking for bulk data, try looking for an API from a site you trust that may have the info you need.
Another thing to consider is if this is going to be a regular occurrence or a one-time thing. If it's a one-shot deal, then an import vs. Flow might be a more prudent path.
A search for "Precipitation data API" found a bunch of sources, but I think I like the NOAA best because of the data availability.
Take a look at this article to get started on API's and custom connectors. The example I used was for Yelp, but there is a standard for exchanging the information which makes it applicable to most other sites, as well. The exciting part is once you've got the basics worked out, a bunch of information becomes available and you can 'level-up' your automation.
Keep at it, and let us know how it progresses.
-Ed-
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
