Airtable

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

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.

How to connect

1

Create a new data flow and select Airtable as your data source.

2

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.

3

Paste the link into Coupler.io. In the data flow setup, paste your Airtable shareable link into the Shared URL field.

4

Setup destination. Select where you want your Airtable data to land.

5

Run your first data flow. Click Run to verify the connection works.

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

Note: The import is read-only. Changes to your Google Sheet won't affect your Airtable base.

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

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.

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.

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.

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.

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

"Cannot read property '1' of null" error

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.

Data won't load after connecting the link

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.

"SheetAPI error" or "Invalid values" message

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.

Missing data

Only some rows or columns are importing

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.

Zeros and empty values show as blank

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.

Multi-select or linked record fields show strange delimiters

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.

Permission errors

"Access denied" when trying to connect to Airtable view

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.

Password-protected view won't import

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.

Data discrepancies

Dates show different times than in Airtable

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.

Note: Custom formula fields in Airtable will preserve their custom-calculated times.

Large data imports cause timeout errors

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.

Entire sheet gets overwritten on each refresh

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.

Rate limits

Getting rate-limited or throttled during large imports

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.

"Timeout" or "ddb3" errors on automatic refreshes

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.

Airtable FAQ

Do I need an API key to connect Airtable to Coupler.io?

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.

Can I import data from a password-protected Airtable view?

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.

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

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.

Can I filter which columns are imported?

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.

Does Coupler.io preserve Airtable formulas?

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.

What delimiter should I choose for multi-select fields?

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.

Why do my dates look different in Google Sheets than in Airtable?

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.

Can I import an entire Airtable base or just a single view?

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.

What happens if I delete rows or columns from my Google Sheet?

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.

How often can I refresh my data?

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.

Will Coupler.io import hidden or filtered rows from Airtable?

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.

Can I use Coupler.io to export Google Sheets back to Airtable?

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.

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

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.

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

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.

Can I edit data in my destination and have it update Airtable?

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

Why are zeros and empty values showing as blanks?

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.

For more information about data types and formatting, see the Data Overview. For connection troubleshooting, check Common Issues. For setup recommendations, visit Best Practices.