Airtable logo
OpenWeather
Import and sync data in Airtable

Connect Airtable and OpenWeather

Look up the weather forecast for a location using a simple no-code API integration. Sync data from OpenWeather and thousands of other apps into Airtable automatically with Data Fetcher.

Trusted by leading Airtable teams

IBM Logo
Amazon Logo
Warner Records Logo
Harvard Logo
Stanford Logo
NBA Logo
Time Logo
DraftKings Logo

The no-code solution for connecting OpenWeather to Airtable

It takes just 4 simple steps to get up and running with Data Fetcher’s no-code imports into Airtable

Step 1

Add the Data Fetcher extension

Get started with OpenWeather in Airtable by adding the Data Fetcher extension from the Airtable Marketplace. Create your free account directly within the extension after installation.

Add the Data Fetcher extension
Step 2

Connect to OpenWeather

Select the pre-built OpenWeather integration from our library. Data Fetcher handles all the technical API details, so you can connect without writing a single line of code.

Connect to OpenWeather
Step 3

Map the fields

Select which OpenWeather data fields you want to import and map them to your existing Airtable fields. Choose how new data should merge with existing records in your base.

Map the fields
Step 4

Automate your OpenWeather data sync

Keep your Airtable data fresh by scheduling automatic updates at any interval. You can also trigger syncs from OpenWeather when records change in your Airtable base.

Automate your OpenWeather data sync

About the tools

OpenWeather logo

OpenWeather

OpenWeather is a comprehensive weather data service providing current conditions, forecasts, and historical weather information for locations worldwide. It offers access to meteorological data including temperature, precipitation, wind, cloud coverage, and atmospheric pressure through straightforward API endpoints. The platform provides multiple forecast options ranging from hourly predictions to 16-day outlooks with specialized data for agriculture, energy, and logistics sectors.

Airtable logo

Airtable

Airtable blends spreadsheets and databases, enabling organized, collaborative workflows. It features customizable templates, multiple viewing options like grid, calendar, and kanban boards, plus powerful data types. With integration capabilities, automation tools, and team collaboration features, Airtable helps businesses of all sizes manage projects, content planning, and data without technical expertise.

Data Fetcher logo

Data Fetcher

Data Fetcher is an Airtable extension that connects your bases with external data sources and APIs. Users can pull data from REST APIs and external systems without writing code. With support for automic syncs, data transformation and mapping, Data Fetcher helps businesses make Airtable their source of truth for all their third-party data. It acts as the missing connection between OpenWeather and Airtable.

How to Connect OpenWeather to Airtable

In this guide, we'll learn how to look up the weather forecast by latitude and longitude in Airtable. We'll use the Data Fetcher Airtable extension to connect Airtable to the OpenWeather API and import weather data such as temperature, humidity and wind speed.

We'll also schedule this so that we look up the weather forecast in Airtable automatically.

Install Data Fetcher

Install Data Fetcher from the Airtable marketplace. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'. If you already have a Data Fetcher account, sign in using the 'Have an account?' button at the bottom left of the box.

Data Fetcher Sign Up

Look Up The Weather Forecast in Airtable

On the home screen of the Data Fetcher extension, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.

Create your first request

On the create request screen in Data Fetcher, for Application, select 'OpenWeather'.

OpenWeather add to Airtable

OpenWeather is an online service that provides global weather data. Either sign up for a free OpenWeather account or sign into your existing one. Your API Key can be found here.

OpenWeather API Key

Enter this API key into the API Key input in Data Fetcher.

clearbit-authorization-api-key.png

For Endpoint, select 'Current weather & forecast for location(s)'.

OpenWeather-Endpoint.png

Enter a Name for your request, e.g. 'Import Weather Forecast'. Then click 'Save & Continue'.

Import OpenWeather Data into Airtable

Enter the Latitude and Longitude for your location. For this example, we are using 51.503399 and -0.119519 which are the latitude and longitude of the London Eye. Latitude and longitude will always be numerical values (no letters).

If you do not know your location's latitude and longitude, you can first follow this tutorial to look up latitude and longitude for addresses.

OpenWeather Airtable Latitude Longitude

For Forecast choose either 'Hourly Forecast for 24hrs' or 'Daily Forecast for 7 Days'.

OpenWeather Forecast

Temperature Units are set as Celcius by default, or you can choose either Farenhight or Kelvin.

OpenWeather Temperature Units

You can set the Language for your weather forecast description. Or leave it blank to use English.

Select the Output Table & View in Airtable where you want to create your weather forecast. Click 'Save & Run'.

OutputTable.png

The request will run and the Response field mapping modal will open. This is where you set which fields to import from OpenWeather and how they should map to the fields in the output table.

You can easily find the fields you want to import using the 'Find field' search bar.

We are going to import the 'Hour', 'Temperature', 'Humidity', 'Wind speed' and 'Description' fields from OpenWeather into Airtable.

You can choose whether to add these to existing Airtable fields or to create new ones. You can also choose the type of any new field.

Click 'Save & Run'.

OpenWeather Data Fetcher Field Mapping

Data Fetcher will create any new fields that need to be created in the output table, then run the request again and import the weather forecast data from OpenWeather to Airtable. You can now view the output table in Airtable.

OpenWeather-Output-Table.jpg

Look Up the Weather Forecast Automatically

We can also use Data Fetcher's scheduled requests feature to automatically update the weather data in Airtable every 15 minutes/ hour/ day etc. To do this, you'll need a paid Data Fetcher account.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

Group 1(8).png

A new tab will open where you can select a plan and enter your payment details to upgrade.

data fetcher upgrade pricing plans.png

Return to the Data Fetcher extension and click 'I've done this'.

Group 1(9).png

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

A window will open for you to authorize the Airtable bases you need Data Fetcher to access.

By selecting 'All current and future bases in all current and future workspaces', you'll avoid any issues with authorization in the future.

Click 'Grant access'.

schedule-authorize-bases.jpg

In Data Fetcher, Schedule this request will now be toggled on.

Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save'. The request will now run on the schedule and update our weather forecast automatically.

Group 11(2).png

Ready to connect OpenWeather to Airtable?

Start syncing your data sources with Airtable today.