Google Sheets Import helps you import data prepared in spreadsheets directly into an existing Framer CMS collection. It automatically maps columns without copying/pasting, and all imported content is saved as drafts so you can review before publishing. This plugin is ideal for users wanting to quickly update their CMS with pre-prepared content.

Main Features

Automatic Column Mapping

It automatically compares column names from sheets with CMS fields and maps them. It detects both snake case (_) and is not case sensitive.

Secure Import Method

New entries are created in draft (draft) status, and existing slugs (slug) are skipped. Since it doesn’t overwrite existing data, you can use it confidently.

Supports Various Field Types

In addition to basic fields like strings, numbers, and dates, it supports all Framer field types, including images, links, files, enums, and collection references.

:draft Column for State Control

You can specify draft status for each item in the sheet, which is useful when a review stage is needed before publishing.

Import Result Summary

It provides a detailed summary of import results, including the number of imported items, duplicate slugs, and format errors.

Thorough Security Design

With a thoroughly designed security system, user data is not sent outside of the Google API, and authentication information is only maintained during the session.

Additional Information

Since the plugin remembers mapped sheet URLs and collection settings, it can be efficiently used for repetitive tasks. Existing items aren't modified, and if needed, you can delete the items below and reload them.

• Date: Supports ISO format, common date formats, and Google serial numbers

• Image: Manages image URLs and alt text in separate fields

• Reference Field: Uses the slug of the collection to connect

• Multiple References: Use comma-separated slugs

• Enum: Mapped by label or ID value