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

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.

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.

Last updated

Was this helpful?