Google Sheets Import Framer plugin

The Google Sheets Import plugin streamlines content creation by allowing you to import data directly from Google Sheets into your Framer CMS Collections. Say goodbye to manual copy-pasting and potential errors.

This plugin intelligently maps columns from your spreadsheet to corresponding fields in your Framer CMS, using name matching (case-insensitive and snake_case normalization). It supports a wide range of Framer field types:

• 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: Automatic detection and mapping of columns to fields.
• Safe Importing: New items are created as drafts, preventing accidental overwrites.
• Comprehensive Validation: Values are converted and validated based on the field type.
• Draft Control: Use an optional :draft column to control the initial publish status of imported items.
• Detailed Reporting: Provides a summary of added items, conflicts, and any validation warnings.

How to Use:

1. Prepare your Google Sheet: Organize your data in a Google Sheet with column headers matching your Framer CMS Collection field names. Include a slug column for unique identifiers, or designate a field for automatic slug generation.
2. Share Your Sheet: Set the sharing permission to "Anyone with the link can view" and copy the URL.
3. Import within Framer:
   • Open your target Collection in Framer.
   • Launch the plugin.
   • Paste the Google Sheet URL and click "Load".
   • Review and adjust the automatically mapped columns as needed.
   • Click "Import".
4. Review Results: The imported items will appear as drafts in your Framer CMS Collection. Review the summary for warnings, and publish the approved items.

The plugin remembers the sheet URL and mapping for each collection, simplifying future imports. Existing items are not updated during import; delete and re-import if necessary.

Supported Data Types Details:

• Dates: Accepts ISO strings, common date formats, and Google serial numbers.
• Images: Use the image URL in the primary column and an optional fieldName:alt column for alt text.
• References: Use existing Collection item slugs for single references.
• Multi-references: Use comma-separated slugs for multiple references.
• Enums: Values must match existing option labels or IDs.

Privacy & Security:

• Data is only sent to Google APIs.
• Auth tokens are stored only for the session.
• Optional mapping persistence (with permission).
• No analytics or tracking are used.