Connect to APIs with NoCode
Tags: api, nocode
Published: 2021-07-03 16:28:48

We all know that public APIs documentation is messy and don't know how to get started with any API. So, now you don't have to worry about complex documentations.

 [NoCodeAPI](https://nocodeapi.com)  makes it easy for you to connect with public APIs and give you a secure, simple, unique API endpoint with in-built features.

### Benefits of using NoCodeAPI

- ⏲️ Bypass Limits
- 👊 Hassle-Free
- 🤯 No Server Headache
- ⚡ Fast
- 🔑 Secure
- ✳️ Logs
- 📜 Mini Documentation

This website has a huge list of applications like Google Sheet, Instagram, Youtube, Airtable, Zoho Mail, AWS S3, Vimeo, WordPress, Mailgun, Webflow, Spotify, Calendly, Twitter,  Telegram, Github, and more than 50 applications in its [marketplace](https://nocodeapi.com/marketplace)

In this article, I'll show you how to connect with  [Google sheet API](https://nocodeapi.com/google-sheets-api),  [Airtable API](https://nocodeapi.com/airtable-api), &  [Webflow CMS API](https://nocodeapi.com/webflow-cms-api) 

Before getting started first, create an account at  [NoCodeAPI](https://app.nocodeapi.com/signup) and it just took 1-minute to start.

## Connect with Google Sheet

Login to NoCodeAPI, Go to the marketplace, find Google sheet API, & activate this.

![Google Sheet Setup page](https://cdn.hashnode.com/res/hashnode/image/upload/v1625201843708/McZihXcH7.png)

To make Google Sheet API you have to **Authenticate with your Google Account**. After this, get your spreadsheet id to make Sheet API.

**Sheet ID** - Your google spreadsheet ID of which you want API.

Example URL **https://docs.google.com/spreadsheets/d/1i27K4e5m1H2-TTdXgVNmfzn_V2LolgjVtpGYjZ50NX4/edit**

The **Sheet ID** is the part after **d/**, in the above link, it's **1i27K4e5m1H2-TTdXgVNmfzn_V2LolgjVtpGYjZ50NX4**

Click on the **Create Google Sheet API** button then **authenticate with your Google Account**. After authenticating you will be redirected back to the NoCodeAPI with a Modal, just follow the form and click on Create button.  🎉 Done!


![Google Sheet API endpoint](https://cdn.hashnode.com/res/hashnode/image/upload/v1625202543387/JfInDaWgO.png)

Now you can get your sheet tabs data as JSON with the endpoint showing in above picture. You can use an in-built playground to test the endpoint. Just click on **Use this API**.

![Google Sheet Playground](https://cdn.hashnode.com/res/hashnode/image/upload/v1625202789243/YBudK3wrg.png)

You can test this endpoint in your browser tab. https://v1.nocodeapi.com/coder/google_sheets/moIDovKbPEuOexXh?tabId=data

There are the following endpoints for Google Sheet API:

- Get All Records - Get all sheet data by tabId.
- Get single row - Pass row id to get single row object from sheet.
- Append new row - Push new row into your google sheet.
- Update row - Pass an object with new values with row_id.
- Delete one row - You can also delete one row or multiple rows at a time.
- Create a new Spreadsheet - You can also make a fresh new spreadsheet with POST call.
- Add Sheet Tab - You can add a new tab into your spreadsheet with this endpoint.

 ↳ [View google sheet API docs](https://nocodeapi.com/docs/google-sheets-api) 

## Connect with Airtable

Go to the marketplace, find Airtable API, & activate this.

To make Airtable you need 2 values:

- **API key** - You can get your Airtable API key from here ** [https://airtable.com/account](https://airtable.com/account) **
- **Base ID** - Go here **  [https://airtable.com/api](https://airtable.com/api)  **  and select your form base then you can find the **base ID** in URL & It begins with the **app**. 

Example: **https://airtable.com/appofMoPxdu7iQ7hf/api/docs** -> **appofMoPxdu7iQ7hf** is the **Base ID**.

Click on the **Create Airtable API** button then put the required values into the form and click on the **Create** button.  🎉 Done!


![Airtable API endpoint](https://cdn.hashnode.com/res/hashnode/image/upload/v1625203669690/CxXvfQOdq.png)

There are the following endpoints for Airtable API:

- **Get All Records** - List all records from the table of your Airtable Base.
- **Get Single Record **- Get a single record
- **Create Records** - Create multiple new records into the table.
- **Update Records** - You can update multiple records in one API call.
- **Delete Records** - You can delete multiple records in one API call.

 [View Airtable API docs](https://nocodeapi.com/docs/airtable-api) 

## Connect with Webflow CMS

Webflow is the most powerful modern NoCode web builder on the internet. Webflow has its in-build database that is Webflow CMS. 

You can get your Webflow CMS data as JSON without any backend coding and server logic.

Go to the marketplace, find Webflow API, & activate this.

To make Webflow you need only one value:

- **API Access key** - Go to **dashboard** -> Click on **three dots icon** -> **Settings** -> **Integrations** -> Generate **API Access**.

Click on the **Create Webflow API** button then put required values into the form and click on the **Create** button.  🎉 Done!


![Webflow CMS API endpoint](https://cdn.hashnode.com/res/hashnode/image/upload/v1625204427513/oUuiwxDj2.png)

There are the following endpoints for Webflow API:

- **Get All Collection Items** - Get your all items from the Webflow CMS collections.
- **Get Single Item** - Get a single Item of the CMS collection
- **Add Item** - Add new item into the collection
- **Update Records** - You can update item values into the collection.
- **Delete Item** - You can also delete an item from the collection.

 [View Webflow CMS API docs](https://nocodeapi.com/docs/webflow-cms-api) 

## Conclusion

This is all. I hope find this article useful and make your API development easy. Let me know your thought on the NoCodeAPI.

↳ Website: https://nocodeapi.com
↳ Follow me  [@mddanishyusuf](https://twitter.com/mddanishyusuf) 

The last favor is from you that share this blog post on Facebook, Twitter, LinkedIn, or with your friends. 🙏