Free API Connector for Google Sheets & Airtable to Import JSON Data
WINDOWS How to Wordpress tools How to

Free API Connector for Google Sheets & Airtable to Import JSON Data

AliDropship is the best solution for drop shipping

Editor Scores:

Consumer Scores:

[Total: 0   Average: 0/5]

NOCodeAPI is a free on-line companies that acts as an API connector for Google Sheets, Airtable, and lots of different servcies. Right here it permits you to import JSON information in all of the supported servcies with none server concerned. All it’s important to do is join your spreadsheet with it after which merely begin importing information from exterior APIs. Earlier than pushing information to sheets, you’ll be able to map it to a selected desk within the sheet. Not solely this, however you’ll be able to selectively bind the variables in JSON to subject names within the desk in a number of clicks. The free plan of NoCodeAPI gives 900 calls per thirty days which is nice for particular person programmers.

Should you typically have must import information immediately from REST APIs then NoCodeAPI gives of probably the most highly effective connectors on the market. Not solely this however this device can even turn Google Sheet into an API so you’ll be able to entry its information on an endpoint in JSON format. If you wish to do with some devoted connector then you need to use the add-on mentioned here. However in case you use a number of spreadsheets and need to import information from a unified interface, the NoCodeAPI is one of the best choices. Other than Google Sheets and Airtable API, it has assist for Algolia, S3, Mailgun, Google Analytics, Cloudinary, Gumroad, and lots of others.

API Connector for Google Sheets Airtable to Import JSON Data

Free API Connector for Google Sheets & Airtable to Import JSON Information

To start out utilizing NoCodeAPI platform, you solely need to sign up for a free account. After that, you simply choose the Airtable and Google Sheets APIs. Additionally, there are different APIs too within the market that you could be discover helpful. For this publish, I might be utilizing the Google Sheets API connector. However the course of may be very comparable for Airtable as properly.

NoCodeAPI Sign up and Marketplace

After creating an account and setting the username, you simply go to {the marketplace} and seek for Google Sheets. Subsequent, you simply choose this API and allow it.

Now, it’s time to configure it and to try this, you solely have to authenticate it along with your Google account. trustworthy permit it to learn and write Google Sheets in your account after which proceed additional.

NoCodeAPI authenticate via Google

After profitable authentication, it’s important to specify the ultimate sheet during which you’ll import the information. Give your sheet a reputation right here and specify the ultimate sheet’s ID. You possibly can copy the ID of the sheet from its URL; it’s between “/d” and “/edit” as you’ll be able to see within the screenshot beneath.

NoCodeAPI Specify Google Sheet ID

Now, you will have the sheet added to the NoCodeAPI dashboard. It’ll generate a NoCodeAPI endpoint URL for it that you need to use to entry the sheet information on JSON format. However that you’ll do later once you add some information to the sheet. To import information within the sheet from an API, simply use the Import choice from the drop-down.

NoCodeAPI endpoint URL and import data

Enter the API URL from which it’s important to import the JSON information into the sheet. Subsequent, it’ll import the information and subsequent factor it’s important to do is choose JSON variables to import within the sheet.

NoCodeAPI pull data from API

Lastly, it’ll present you ways the information will appear to be. You possibly can edit the fields names for the sheet after which see the preview. Choose the sheet of a Google Spreadsheet by title during which you need to import the information.

NoCodeAPI bind pulled API data to Sheet

Now, after it’s carried out, you’ll be able to see the ultimate information within the Google Sheet. And now you utilize the NoCodeAPI URL that it generated earlier to entry this information as JSON from a devoted endpoint.

Data imported from API NoCodeAPI

So, this was the entire course of for Google Sheets. However the course of may be very a lot the identical for Airtable. As an alternative of account authentication, you’ll have to specify the Airtable API keys to configure the import. There’s a helpful tutorial fore that on its homepage in a video and also you would possibly prefer it. The free plan is beneficiant sufficient to supply 900 requests a month however in case you want extra then you’ll be able to at all times change to any premium plan.

Closing ideas:

Importing information from APIs in Google Sheet or different common on-line spreadsheets resembling Airtable could be tough. However thanks for the API connector provided by NoCodeAPI, that’s not a headache anymore. You simply configure your connector after which import information in a number of clicks. The very best half is that you would be able to import information from any API and ain any vacation spot from a single unified interface.