Import OpenWeatherMap Data to Google Sheets

Import OpenWeatherMap Data to Google Sheets


  1. Hello, thanks for this useful article !
    How do you manage to only pull certain info like I would only want the weather >> main and main >> temp ?


  2. Cool, glad it was useful! The response will include all the data returned by OpenWeatherMap. If you’re only interested in certain fields, I suggest making another tab in Google Sheets that uses spreadsheet formulas to get what you’re looking for. For example, you could use this formula to pull in just columns C and N from a sheet named LondonWeather:

    =QUERY(LondonWeather!A:Z, “select C, N”)

    Let me know if that works for you!

Leave a Reply

Your email address will not be published.