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:
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.
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.
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.
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.
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?
