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