> 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/data-overview.md).

# Data Overview

## 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.


---

# 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 dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.