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

Sync Airtable, BigQuery, JSON API with Google Sheets Free:

AliDropship is the best solution for drop shipping

Editor Rankings:

Person Rankings:

[Total: 0   Average: 0/5] is a free on-line device that allows you to sync numerous knowledge sources with Google Sheets. All it’s important to do is configure a workflow after which merely run it manually or on a schedule. Your knowledge will likely be in sync at all times and you may choose to sync the brand new knowledge over the prevailing knowledge or simply append it. This is so simple as that.

All knowledge sync duties on Coupler is known as Importers. You may create a number of importers and run them anytime you need. Or, merely schedule the info importing on autopilot. With this helpful device, you may maintain knowledge in a number of sources in a number of Google Sheets in sync at all times. Nonetheless, the free plan solely means that you can sync 50000 rows a month. So, you’ll have to create your importers by conserving that restrict in thoughts.

Coupler helps many knowledge sources to import knowledge from. You may import data from JSON API, Airtable, CSV, HubSpot, BigQuery, Shopify, WordPress, Pipedrive, Clockify, Jira, and lots of different sources. neutral create an importer for every knowledge supply with the right configuration and select a separate GSheet for every process.

Sync Airtable, BigQuery, JSON API with Google Sheets Free Coupler io

Sync Airtable, BigQuery, JSON API with Google Sheets Free:

To make use of, you solely have to enroll utilizing your Google account totally free. Go its homepage to try this after which merely begin creating the importer. The principle empty dashboard seems like this.

Coupler Main Dashboard

Now, you create your first importer. It makes use of a step-by-step course of to create an importer. So, to start with, you merely begin by specifying a knowledge supply from which you wish to fetch knowledge.

Coupler io input data sources

Within the subsequent step, you specify the parameters for the info supply you selected. For instance, I selected JSON API, so for that, I’ve to specify the endpoint and request technique. For APIs, it helps all the search strategies.

Data fetching Advanced settings

Subsequent, you proceed additional to configure the vacation spot. Right here you will have to authorize your Google account as soon as once more to pick the goal Google Sheet. After authentication, it should checklist all of the Sheets out of your account and also you simply choose the one you wish to save the imported knowledge.

Coupler select table

Lastly, in the long run, you specify by which sheet of the chosen spreadsheet, you wish to save the info. Save the adjustments and if you wish to refresh knowledge robotically after which allow the scheduling choice. It’ll maintain your knowledge in sync by refreshing it each hour.

Seelct sheet and sceduling

Now you can the importer you’ve crated to import the info manually. Or, you simply let it run robotically. The information will likely be displayed within the Google Sheet and you may check that.

Coupler Data import in action

These the important thing steps to create an importer in to sync knowledge between Google Sheets and different knowledge sources. You observe these steps to create a number of importers and fetch knowledge like a professional. Additionally, in case you create a number of non-scheduled importers then you may run them in a single go from the dashboard.

Closing ideas:

Should you use Google Sheets to maintain knowledge then you’ll like this device right here. You solely need to configure the importers as soon as after which they’ll maintain operating on their very own. I appreciated that they’ve included some actually helpful knowledge sources to import knowledge from and will probably be a rally useful device for advertising and marketing professionals and programmers/builders.