> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon.md).

# Airtable

Connect Airtable bases to Google Sheets with Coupler.io. Automate data syncs, combine tables for reporting, and eliminate manual copying from your database.

Airtable is a flexible database platform that combines the simplicity of a spreadsheet with the power of a relational database. With Coupler.io, you can automatically import your Airtable data into Google Sheets for custom analysis, reporting, and visualization.

## Why connect Airtable to Coupler.io?

* **Automate your workflows** — Schedule automatic data refreshes so your Google Sheets stay in sync with your Airtable base without manual copying.
* **Enhanced reporting** — Combine Airtable data with other sources in Google Sheets for comprehensive analysis and dashboards.
* **No data loss** — Use shareable links to import data securely without exposing your entire base.
* **Support for password-protected views** — Import from restricted Airtable views by providing the view password.

## Prerequisites

Before you start, you'll need:

* An active Airtable account with at least one base and view
* Access to Google Sheets (Coupler.io works as a Google Sheets add-on)
* A shareable link to the Airtable view you want to import

## Quick start

{% hint style="success" %}
The fastest way to get started: open the Airtable view you want to export, create a shareable grid view link, and paste it into Coupler.io during setup.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Create a new data flow** and select Airtable as your data source.
{% endstep %}

{% step %}
**Generate a shareable link from your Airtable view.** Open the Airtable base and navigate to the view you want to export. Click the **Share view** button, select **Create a shareable grid view link**, and copy the URL.
{% endstep %}

{% step %}
**Paste the link into Coupler.io.** In the data flow setup, paste your Airtable shareable link into the Shared URL field.
{% endstep %}

{% step %}
**Setup destination**. Select where you want your Airtable data to land.
{% endstep %}

{% step %}
**Run your first data flow.** Click **Run** to verify the connection works.
{% endstep %}
{% endstepper %}

## What gets imported?

Coupler.io imports all visible columns and rows from your Airtable view, including:

* Text and number fields
* Dates and times (adjusted to your Google Sheet's timezone)
* Multi-select and linked record fields (separated by your chosen delimiter)
* Formula fields (as their calculated values)
* Checkboxes and other field types

{% hint style="info" %}
**Note**: The import is read-only. Changes to your Google Sheet won't affect your Airtable base.
{% endhint %}

## What data can you import?

Coupler.io imports the full structure of your Airtable view – every column and row visible in that view. The data you get depends entirely on what you include in your Airtable view.

## Supported field types

Airtable includes many field types. Here's how they appear in Google Sheets:

| Field Type       | How It Imports          | Notes                                                     |
| ---------------- | ----------------------- | --------------------------------------------------------- |
| Single line text | Text                    | Imported as plain text                                    |
| Long text        | Text                    | Preserves all content                                     |
| Number           | Number                  | May display as 0 if empty in source                       |
| Checkbox         | True/False              | Displays as TRUE or FALSE                                 |
| Single select    | Text                    | Displays the selected option                              |
| Multi select     | Text                    | Separated by your chosen delimiter                        |
| Date             | Date                    | Adjusted to your destination's timezone if any            |
| DateTime         | Date + Time             | Includes time based on your destination's timezone if any |
| Linked records   | Text                    | Row IDs separated by delimiter                            |
| Lookup           | Depends on linked field | Inherits format from source                               |
| Formula          | Calculated value        | Imports the result, not the formula                       |
| Attachment       | Link                    | Displays as file name or URL                              |
| Rating           | Number                  | 1-5 scale imported as numbers                             |
| Duration         | Number                  | Imported as seconds                                       |

## Common import scenarios

* **Customer contact lists** — Import name, email, phone, and company fields for CRM analysis.
* **Project tracking** — Pull task status, assignee, due date, and progress fields to build Google Sheets dashboards.
* **Inventory management** — Sync product names, SKUs, quantities, and cost data for real-time reporting.
* **Event registration** — Combine attendee names, email addresses, registration dates, and ticket types.
* **Sales pipeline** — Import deal names, stages, amounts, and close dates to track opportunities.

## Use cases by role

{% tabs %}
{% tab title="Marketers" %}
Import campaign data, lead lists, and event registrations from Airtable to Google Sheets for analysis. Build custom dashboards that track campaign performance, segmentation, and conversion metrics without manual data entry.
{% endtab %}

{% tab title="Operations & Admin" %}
Sync inventory, project tasks, and team schedules from Airtable to create master tracking sheets. Automate recurring reports and keep stakeholders updated with real-time data from your source of truth.
{% endtab %}

{% tab title="Finance teams" %}
Pull expense reports, invoices, and budget tracking data from Airtable into Google Sheets for consolidated financial analysis. Use automatic refreshes to keep P\&L statements and cost tracking current without manual updates.
{% endtab %}

{% tab title="Product & UX" %}
Import user feedback, feature request logs, and bug reports from Airtable to analyze trends and prioritize work. Create pivot tables and custom visualizations to identify patterns and inform product decisions.
{% endtab %}
{% endtabs %}

## Important notes about Airtable data

* **Shareable links are required** — You cannot use API keys with Coupler.io. You must create a shareable grid view link from your Airtable base.
* **View-based imports** — Coupler.io imports only what's visible in your selected view. Hidden columns and filtered rows won't be included.
* **Password protection** — Password-protected views are supported. Store the password securely in Coupler.io (it's encrypted).
* **Delimiter matters** — Multi-value fields (linked records, multi-select) are separated by your chosen delimiter. Pick one that won't appear in your data.
* **Timezone handling** — Date and time fields are adjusted to match your destination's timezone, not Airtable's.
* **Formula fields** — Imported as calculated values, not formulas. Changes to Airtable formulas won't update your destination retroactively.
* **Read-only import** — Your destination receives data only from Airtable. Editing data in the destination won't change your Airtable base.

## Airtable common issues

### Connection issues

<details>

<summary>"Cannot read property '1' of null" error</summary>

This error typically appears when you're trying to import from a shared base link instead of a shareable grid view link. Coupler.io requires a view-level link, not a base-level link.

**Fix:**

1. Go back to Airtable.
2. Open the specific view (table/grid) you want to import.
3. Click **Share view.**
4. Select **Create a shareable grid view link**, and copy that URL instead.
5. Update your data flow with the correct link.

</details>

<details>

<summary>Data won't load after connecting the link</summary>

If you've pasted the correct shareable link but no data appears after running the data flow, the link may have expired or the view may have restrictions.

**Fix:**

1. Verify the shareable link still works by opening it in a new browser tab.
2. If the view is password-protected, make sure you've entered the password in the "Protected view password" field.
3. Try creating a new shareable link from Airtable and update your data flow.
4. Run a manual test import to confirm the connection.

</details>

<details>

<summary>"SheetAPI error" or "Invalid values" message</summary>

This error can occur if your Airtable view contains fields with special characters, errors, or unsupported content (like embedded objects).

**Fix:**

1. Check your Airtable view for any cells displaying #ERROR! or \[object Object].
2. Delete or fix those problematic cells in Airtable.
3. Run the data flow again after cleaning up the data.
4. If the issue persists, try exporting just a few columns at a time to isolate which field is causing the problem.

</details>

### Missing data

<details>

<summary>Only some rows or columns are importing</summary>

Coupler.io imports only the data visible in your selected Airtable view. If rows or columns are missing, they may be hidden or filtered out in Airtable.

**Fix:**

1. Go to your Airtable view and remove any active filters.
2. Unhide any hidden columns or records.
3. Make sure the view shows all the data you want to import.
4. Run your data flow again after updating the view.

</details>

<details>

<summary>Zeros and empty values show as blank</summary>

Some Airtable field types (like numbers or checkboxes) may import as blank instead of displaying 0 or FALSE. This is a formatting difference between Airtable and some destinations like Google Sheets.

**Fix:**

1. This is expected behavior for certain field types.
2. In Google Sheets, you can format these cells or use a formula like `=IF(ISBLANK(A1),0,A1)` to replace blanks with 0.
3. If the data is critical, verify directly in Airtable that the value actually exists.

</details>

<details>

<summary>Multi-select or linked record fields show strange delimiters</summary>

If you choose a delimiter that appears in your actual data, the values may split incorrectly or appear concatenated.

**Fix:**

1. Edit your data flow settings and choose a different delimiter (use a character that doesn't appear in your data, like a pipe `|` or semicolon `;`).
2. Run the data flow again to refresh the data with the new delimiter.

</details>

### Permission errors

<details>

<summary>"Access denied" when trying to connect to Airtable view</summary>

This error means Coupler.io cannot access your Airtable view link, usually because the link has expired or the view has been deleted.

**Fix:**

1. Verify the Airtable view still exists in your base.
2. Create a new shareable link (the old one may have expired).
3. Update your data flow with the fresh link.
4. Test the new link by opening it in an incognito browser tab to confirm it's public.

</details>

<details>

<summary>Password-protected view won't import</summary>

If you have the password but the import still fails, the password may be incorrect, or there may be a compatibility issue.

**Fix:**

1. Double-check the password in Airtable.
2. Make sure there are no leading or trailing spaces in the password field.
3. If the password contains special characters, ensure they're entered exactly as set in Airtable.
4. Test by trying to manually access the view with the same password to confirm it works.

</details>

### Data discrepancies

<details>

<summary>Dates show different times than in Airtable</summary>

Coupler.io imports dates based on your destination's time zone setting (if any), not Airtable's. If your destination and Airtable are in different time zones, times will appear shifted.

**Fix:**

1. Go to your destination and check time zone settings.
2. Change it to match your intended time zone (or the time zone you want the data displayed in).
3. Run the data flow again to refresh the dates.

{% hint style="info" %}
**Note**: Custom formula fields in Airtable will preserve their custom-calculated times.
{% endhint %}

</details>

<details>

<summary>Large data imports cause timeout errors</summary>

If you're importing very large Airtable views (many rows and columns), the import may time out and fail.

**Fix:**

1. Break your data flows into smaller views – create separate Airtable views with filtered data and import them as separate importers.
2. Reduce the number of columns by hiding unnecessary ones in your Airtable view before importing.
3. Contact support if your data flow consistently times out; there may be server-side optimizations available.

</details>

<details>

<summary>Entire sheet gets overwritten on each refresh</summary>

Coupler.io fully rewrites your destination sheet with fresh data from Airtable on every import. This is by design to keep data in sync, but it means any manual edits or additional columns in your Sheet will be lost.

**Fix:**

1. Create a separate sheet for imported Airtable data and keep your custom analysis in another sheet.
2. Use formulas like `=VLOOKUP()` or `=INDEX/MATCH()` to reference the import sheet from your analysis sheet.
3. Set up your import sheet with no manual edits—treat it as a temporary data layer.

</details>

### Rate limits

<details>

<summary>Getting rate-limited or throttled during large imports</summary>

If you're importing very large Airtable views with thousands of rows, you may hit rate limits from either Airtable or your destination.

**Fix:**

1. Schedule large imports during off-peak hours (early morning or late evening).
2. Split your import into multiple smaller views or tables.
3. Reduce the frequency of automatic refreshes if you're running many data flows simultaneously.
4. Contact Coupler.io support if you're consistently hitting limits—they may be able to optimize your setup.

</details>

<details>

<summary>"Timeout" or "ddb3" errors on automatic refreshes</summary>

Occasional timeout errors can happen when your Airtable view is very large.

**Fix:**

1. These errors are usually temporary. Try running the data flow again manually after a few minutes.
2. If you see this error frequently, consider scheduling automatic refreshes during quieter times.
3. Contact support if the timeouts persist across multiple refreshes.

</details>

## Airtable FAQ

<details>

<summary>Do I need an API key to connect Airtable to Coupler.io?</summary>

No. Coupler.io uses shareable view links instead of API keys. Create a shareable grid view link in Airtable and paste it into Coupler.io during setup. This is actually more secure because you're not exposing your full base or API credentials.

</details>

<details>

<summary>Can I import data from a password-protected Airtable view?</summary>

Yes. If your Airtable view is password-protected, enter the password in the "Protected view password" field during importer setup. Coupler.io stores it securely and uses it only to access your view.

</details>

<details>

<summary>What happens if I change my Airtable data—does it automatically update in the destination?</summary>

No, not automatically. Your destination will only update when Coupler.io runs the data flow according to your refresh schedule (manual, hourly, daily, or weekly). Changes to Airtable won't appear in your destination until the next refresh.

</details>

<details>

<summary>Can I filter which columns are imported?</summary>

You can't selectively import columns through Coupler.io itself, but you can create a filtered view in Airtable with only the columns you need, then import that view. This gives you control over what gets pulled into your destination.

</details>

<details>

<summary>Does Coupler.io preserve Airtable formulas?</summary>

No. Formula fields are imported as their calculated values, not as formulas. If you update the formula in Airtable, the new value won't be calculated retroactively in your destination—it will only reflect the new calculation after your next import refresh.

</details>

<details>

<summary>What delimiter should I choose for multi-select fields?</summary>

Pick a character that doesn't appear in your actual data. Common choices are: - Comma \`,\` (if no commas in values) - Semicolon \`;\` (if no semicolons in values) - Pipe \`|\` (rarely used in data) - Tab character (if supported)

If you pick a delimiter that appears in your data, values will split unexpectedly. You can always change it later and re-import.

</details>

<details>

<summary>Why do my dates look different in Google Sheets than in Airtable?</summary>

Coupler.io imports dates based on your Google Sheet's time zone setting, not Airtable's. If the timezones differ, times will appear shifted. Custom formula fields in Airtable will preserve their custom-calculated times. Change your Sheet's time zone setting if you need a different time zone displayed.

</details>

<details>

<summary>Can I import an entire Airtable base or just a single view?</summary>

You must import individual views, not entire bases. This is a safety feature—you control exactly what data is shared. If you need multiple tables, create a separate shareable view for each table and set up multiple data flows.

</details>

<details>

<summary>What happens if I delete rows or columns from my Google Sheet?</summary>

On the next data refresh, Coupler.io will completely overwrite your Google Sheet with fresh data from Airtable. Any deleted or custom columns will be recreated with the current Airtable data. This is why it's best to keep your import sheet separate from your analysis sheets.

</details>

<details>

<summary>How often can I refresh my data?</summary>

Coupler.io supports manual refreshes anytime and automatic refreshes at intervals you choose (hourly, daily, weekly). The actual frequency depends on your plan and the size of your import. Large imports may take longer, so schedule them during off-peak hours to avoid timeouts.

</details>

<details>

<summary>Will Coupler.io import hidden or filtered rows from Airtable?</summary>

No. Coupler.io imports only rows and columns visible in your selected Airtable view. If you've hidden rows or applied filters in Airtable, they won't be imported. Unhide or remove filters before importing if you want that data included.

</details>

<details>

<summary>Can I use Coupler.io to export Google Sheets back to Airtable?</summary>

No. Coupler.io is one-way: Airtable → Google Sheets. If you need to sync data bidirectionally or export from Google Sheets to Airtable, you'll need a different tool or a manual process.

</details>

<details>

<summary>What should I do if I see "Cannot read property '1' of null" error?</summary>

This error means you've shared a base link instead of a view link. Go back to Airtable, open the specific table/view you want, click Share view, select Create a shareable grid view link, and copy that URL. Update your data flow with the correct view link.

</details>

<details>

<summary>Why is my import timing out or failing with error codes like "ddb3-3047"?</summary>

Timeout errors usually happen with very large Airtable views or during high-traffic periods. Try breaking your data flow into smaller pieces by creating filtered views in Airtable. You can also schedule data flows to run during quieter times of day. If timeouts persist, contact Coupler.io support.

</details>

<details>

<summary>Can I edit data in my destination and have it update Airtable?</summary>

No. Imports are read-only. Changes to your destination won't affect your Airtable base.

</details>

<details>

<summary>Why are zeros and empty values showing as blanks?</summary>

Some Airtable field types (numbers, checkboxes) may display differently in Google Sheets. This is a formatting difference. You can use a Google Sheets formula like `` `=IF(ISBLANK(A1),0,A1)` `` to replace blanks with 0 if needed. Verify the actual value exists in Airtable first.

</details>

{% hint style="info" %}
For more information about data types and formatting, see the [Data Overview](#what-data-can-you-import). For connection troubleshooting, check [Common Issues](#airtable-common-issues). For setup recommendations, visit [Best Practices](https://docs.coupler.io/sources/category/files-and-tables/airtable-addon/best-practices.md).
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.coupler.io/sources/category/files-and-tables/airtable-addon.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
