If you have a lot of interesting data in your JSON format. Maybe in Google Sheets, or Webflow, or an API that you want to bring to your Airtable base. You can use NoCodeAPI to do just that. Crazy Awesome !! 😃

Video Tutorial

If you love video tutorial then we also have video tutorial for you.

Step 1 : Fetch JSON from a fake API

⁃ For this tutorial we are going to fetch our fake JSON data from JSON placeholder API ⁃ As you scroll down, fake JSON placeholder offers different options to fetch this data. We are going to use /todos to fetch 10 users in JSON and create 10 rows in our Airtable spreadsheet.

fakeJSON-users

⁃ Test if the endpoint is working by pasting this URL in your browser > https://jsonplaceholder.typicode.com/todos. It should give you JSON data inside the browser (like below — I am using JSON formatter chrome extension to beautify JSON).

fakeJSON-test

Step 2 : Connect Airtable with NoCodeAPI

⁃ Sign In to NoCodeAPI dashboard by clicking here. ⁃ Go to Marketplace and Activate Airtable API

airtable-activate

⁃ Click on Make Airtable API

airtable-makeAPI

⁃ A sidebar appears where you need to update required fieilds.

airtable-sidebar

⁃ Enter Name of your choice in 1st input field ⁃ Copy your Airtable API key from your Airtable Account URL :— https://airtable.com/account

airtable-APIKey.png

⁃ Copy your Base ID at your Airtable API URL :— https://airtable.com/api

airtable-baseID.png

⁃ Paste these credentials in the required fields.

airtable-filledForm.png

⁃ Click on Create button to generate your endpoint.

airtable-newEndpoint.png

⁃ Using this endpoint we are going to import our JSON data to Airtable base.

Step 3 : Import your JSON data to Airtable

⁃ Click on 3 dots button. ⁃ Click on import data.

airtable-importData.png

⁃ An overlay opens where we are going to format our data properly for the Airtable. ⁃ Paste your JSON endpoint in the GET request input → https://jsonplaceholder.typicode.com/users ⁃ Click on Fetch Data button. ⁃ Add id, name, email and address.city to selective table headings. ⁃ Click on Next Step

airtable-fetchData.png

⁃ The drop down Input Table Name & push data header opens on itself. ⁃ Go to your Airtable base and properly format the table headings. [Airtable works like collections in database, so it is important we properly define our column headers].

airtable-editHeadings.png

⁃ Inside the black panel, change the “address.city” text to “city”. Keep remaining fields as such. ⁃ Write down the name of table inside your Airtable base. In our case it is JSON_Demo. ⁃ Click Push Data to send your JSON data to Airtable.

airtable-pushData.png

⁃ Next to Push data you should find your status bar turning green. As your data is converted to Airtable you should find it inside Airtable.

airtable-success.png

This is it

We have successfully converted our JSON data to Airtable spreadsheet. You can fetch all JSON URLs into Airtable using this method.

I hope you liked this article. Help us write better by giving your feedback on our twitter channel at @nocodeapi. Thank you for reading. Wish you Happy Coding !! ✌️