# Airtable

## **Why syncing my Airtable to** [**Whaly**](https://whaly.io)**?**

Syncing your Airtable can be useful for various cases

* Make complex data viz on top of airtable
* Combine airtable data with your Product / CRM data
* ....

## Which Airtable data is synced by [Whaly](https://whaly.io)?

We will replicate all tables present in your airtable base, so the schema will be dynamic based on your Airtable base schema.

We will create new tables for relationships and for select / multiselect fields.

## **Overview**

In order to connect your airtable to Whaly, you will need the following:

1. Base Id
2. Base sharing link
3. User Api Token

### 1. Getting your Base ID

Open you base and click on the **help** button

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-Me0RK_XquA8FCLpu1yT%2F-Me0RRBFm7R56wsjaPR5%2FCapture%20d%E2%80%99e%CC%81cran%202021-07-07%20a%CC%80%2016.47.07.png?alt=media\&token=adc97dab-e270-434c-bb14-972f2f8414b7)

Then click on **API documentation**.

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-MduqDG72h1EpdPtOApb%2F-MdurlZyzBL7bqCxfnql%2FScreen%20Shot%202021-07-06%20at%2010.10.40.png?alt=media\&token=8d900ebd-40a8-4ea8-b96b-44618d88e622)

You will find your **Base ID** at the top of the page 🎯

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-Me0D3eu3_Sj0WhhRMns%2F-Me0EIMfGQIBVgRYUGUH%2Fimage%20\(9\).png?alt=media\&token=6a48808a-c8db-4f2a-95f8-70116081b62d)

### 2. Get your Base Sharing Link

In order to get your base sharing link, please open your airtable base. Then click on the **share** button.

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-MduqDG72h1EpdPtOApb%2F-MdusUTS-1VfxG7wTgj-%2Fimage.png?alt=media\&token=cb64c827-bc08-48d3-9046-b7ba57665fe1)

Then click on the **base button**

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-Me0D3eu3_Sj0WhhRMns%2F-Me0FBaArMLQkss9zoe0%2FCapture%20d%E2%80%99e%CC%81cran%202021-07-07%20a%CC%80%2015.53.55.png?alt=media\&token=8ed4629a-4785-4823-93cb-71b4853d8cf8)

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-MduqDG72h1EpdPtOApb%2F-MdutMQe03BbQsUxHc9O%2Fimage.png?alt=media\&token=3352d9dc-07ee-4695-958a-d096c350c3ee)

Please copy the sharing link as shown above.

### **3.** Getting your API Key (final step! 🏁)

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-Mdutj8ynHnhf0DKsLoT%2F-MdutkCvh7dM_5QX9Ve2%2Fimage.png?alt=media\&token=54f22cc7-658f-4f7e-92b8-be7ff9d44281)

Click on account and **copy your API token**

![](https://34758050-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MC1g4I2_CgXd0qAq1P7%2F-Mdutj8ynHnhf0DKsLoT%2F-Mdutu65DqyR-u4tAjYq%2Fimage.png?alt=media\&token=8483d929-8387-4a3f-8ac7-bc7fb9fb5f68)