DataSynclySuite
Install Extension
← Back to All Integrations

How to Connect Google Sheets to Airtable

Learn how to import and sync data from Google Sheets into Airtable without writing code. Supports automated pagination, field auto-type inference, deduplicated upserts, and scheduled syncs.

Prerequisites

  • An active Google Sheets account.
  • Credentials / API Key: None (Published CSV) or Google OAuth.
  • DataSyncly installed in your Airtable Base.

Step-by-Step Setup Guide

1. Connect & Authenticate

  1. Open the DataSyncly extension in your Airtable Base.
  2. Search for Google Sheets and select your preset.
  3. Provide your None (Published CSV) or Google OAuth and click Test Connection.

2. Field Auto-Type Inference

  • DataSyncly inspects incoming sample records and automatically detects Airtable field types (Dates, Numbers, URLs, Attachments, Checkboxes).
  • Adjust or confirm mapped columns.

3. Pagination & Upsert Configuration

  • Pagination: Handled automatically via none.
  • Write Mode: Choose Upsert (Update & Insert).
  • Unique Key: Set to row_index to prevent duplicate entries and keep records updated.

4. Run & Schedule

  • Click Run Sync to import records.
  • Optionally toggle Automated Background Sync (e.g. Every 15 mins) or copy the unique Webhook URL.