Sheets Visualizer

About

This powerful component suite connects your Framer projects directly to Google Sheets, allowing you to display sheet data as formatted text, interactive tables, line charts, or bar charts without any backend coding or API subscriptions. The data updates in real-time when your Google Sheet changes, making it perfect for dynamic content displays. Ideal for creating dashboards, data visualizations, personal trackers, and analytics displays in Framer without complex backend integration.

This component a part of the 400+ components, layouts, templates, UI Kits and code overrides from SegmentUI PRO. Click here to see the full library

Instructions

1. Remix the sample file

2. Make your Google Sheet public by going to File → Share → Publish to web in Google Sheets.

3. Copy the URL of your published Google Sheet.

4. Paste the URL into the "Sheet URL" field in the component properties.

5. Configure which columns to display using column letters (e.g., A, B, C).

6. Customize the appearance using the provided property controls (colors, borders, spacing, etc.).

7. For charts, specify which columns contain labels (X-axis) and values (Y-axis).

8. The component will automatically fetch and display your data in the selected format.

9. Ensure that the numbers are not formatted (No commas, prefixes or suffixes) in the column data

Remember that your Google Sheet must be published to the web and publicly accessible for the component to work correctly.

For the current example, we used this sheet

How It Works

The implementation includes four components: single cell display, full table view, line chart, and bar chart. Each requires a shared/public Google Sheet URL and simple configuration of which data to display. You can customize colors, fonts, borders, tooltips, and other visual elements to match your design system.

Support

For any queries and help setting up the component, please contact hello@segmentui.com