---
title: "Google Sheets Import — Free Framer plugin · Best of Framer"
description: "Free Framer plugin · by Lucian Holtwiesche · CMS. Google Sheets Import lets you prepare content in Google Sheets and import it directly into existing Framer CMS Collections with zero…"
canonical: "https://framer.elliotli.dev/plugin/google-sheets-import-bro0pb4vc2lrb4012vale2qhf"
---

[Home](/)/[Plugins](/plugins)/[CMS](/plugins/category/cms)/Google Sheets Import

# Google Sheets Import

Google Sheets Import

[View on Framer](https://framer.com/marketplace/plugins/google-sheets-import-bro0pb4vc2lrb4012vale2qhf/?via=elliot-li)

![Google Sheets Import preview image 1](https://framer.elliotli.dev/og/plugin/google-sheets-import-bro0pb4vc2lrb4012vale2qhf/c94f66910a8c984b/1600x1200.jpg)

## Summary

Google Sheets Import lets you prepare content in Google Sheets and import it directly into existing Framer CMS Collections with zero copy-paste errors.

## Description

**Google Sheets Import** lets you prepare content in Google Sheets and import it directly into existing Framer CMS Collections with zero copy-paste errors.

The plugin intelligently maps your spreadsheet columns to Collection fields using exact name matching, case-insensitive matching, and snake\_case normalization. It supports all Framer field types including:

-   **Basic types**: string, formattedText, number, boolean, date
    
-   **Special types**: enum, color, link, file, image (with alt text support)
    
-   **References**: collectionReference, multiCollectionReference
    

**Key Features**

-   **Smart Column Mapping**: Automatically detects and maps columns to fields
    
-   **Safe Importing**: Creates new items as drafts, skips existing slugs (no overwrites)
    
-   **Comprehensive Validation**: Converts and validates values per field type
    
-   **Draft Control**: Optional :draft column to control publish status
    
-   **Detailed Reporting**: Summary of added items, conflicts, and validation warnings
    

**How to Use**

1.  **Prepare Your Sheet**: Create a Google Sheet with columns matching your Collection field names. Include a "slug" column or set a field to generate slugs.
    
2.  **Share Your Sheet**: Make it public ("Anyone with the link can view") and paste the link.
    
3.  **Import Process**:
    
    -   Open your target Collection in Framer
        
    -   Launch the plugin
        
    -   Paste your sheet URL and click Load
        
    -   Review/adjust the automatic column mappings
        
    -   Click Import
        
4.  **Review Results**: New items appear as drafts. Check the summary for any warnings, then publish approved items.
    

The plugin will remember the sheet url and mapping per collection, making recurring imports an ease. Existing items will not be updated. You can delete items and re-import if needed.

**Supported Data Types**

-   **Dates**: ISO strings, common formats, and Google serial numbers
    
-   **Images**: URL in main column, optional fieldName:alt column for alt text
    
-   **References**: Existing Collection item slugs
    
-   **Multi-references**: Comma-separated slugs
    
-   **Enums**: Must match existing option labels or IDs
    

**Privacy & Security**

-   No data sent anywhere except Google APIs
    
-   Auth tokens only stored for session
    
-   Optional mapping persistence (with permission)
    
-   No analytics or tracking
    

## Rank history [How rankings work →](/terms#rankings)

-   All · #673

## Details

- **Author**: Lucian Holtwiesche
- **Published**: 2025-09-02
- **Updated**: 2025-09-01
- **Added**: 2025-09-01
- **Categories**: CMS

## More across types

-   [Bend Video Carousel](/component/bend-video-carousel) — Axis Supply · $15 — Bend Video Carousel is an interactive video carousel for Framer that combines smooth movement with a curved, dimensional layout.
-   [CMS Archway Video](/component/cms-archway-video) — Axis Supply · Free — CMS Archway Video is a cinematic video carousel for Framer that combines continuously moving video cards with a distinctive arched shape.
-   [Reveal Nav CMS](/component/reveal-nav-cms) — TOC Studio · Free — CMS-connected hover nav menu

## More like this

-   [Savepoint](/plugin/savepoint) — Syauqizaidan Khairan Khalaf · Free — Undo for your Framer CMS
-   [Store Locator](/plugin/store-locator) — Framefic · Free — Interactive Maps, Nearby Stores
-   [FlowSlider Pro](/plugin/flowslider-pro) — Junseo Ham · Free — CMS Slider & Carousel Engine
-   [CMS Video Downloader](/plugin/cms-video-downloader) — Builders Hub · Free — Download CMS Videos