🏗️
Flezr Docs
  • Flezr
  • Create Website
    • Getting Started
      • Dashboard
      • Studio
  • Building your App
    • Starting a project from a Built-in Template
    • Building Blocks
    • Connecting Data Source: Google Sheets/Supabase
    • Creating Static Pages
    • Customising the Sections and Page Elements
    • Making Responsive Design
    • Creating and Customizing Dynamic Cards
      • Configure data source
      • Customizing the Dynamic Card section
        • Configuring & customizing card headings
        • Customizing the Number of Cards per Row and Style
      • Customizing the Design of an Individual Card
      • Adding and Customizing Dynamic Card Elements
      • Adding Prefix/Suffix Dynamically to the Card Data
      • Adding Tags and Filters
    • Concept of Dynamic Pages and Variables In Flezr
      • Creating the Template for a Dynamic Page
      • Adding Variables to Page Elements
  • Site Settings
    • External JavaScript & External CSS
    • SEO
  • Integrations
    • Adding password protected content/membership
    • Email Integrations
  • Publishing your Website
  • How To
    • Add Custom Domain
    • Set Ids for Sections and link on the same page
    • Enable Search for Cards
    • Unpublish a page - Set Page Visibility
    • Move Sections Up/Down in the same page
    • Enable ‘Search as you type’ for Cards
    • Enable HTML content in Cards
    • Preserve White-spaces and Line breaks from Google Sheets to display in Cards
    • Configure Page Title, Description, FavIcon for each page
    • Use other fonts from Google Fonts
    • Add Opacity and Background Color for Header Section
    • Add Javascript to Individual Pages
    • Configure Number of Cards to Display
    • Change the display order of card elements based on device type
    • Embed Pages and Sections on External Websites
    • Set the link to an entire card instead of individual elements
    • Duplicate projects
    • Copy sections between pages
    • Create a Sitemap file for your website
    • Use Google Drive images for cards
    • Build Websites with Supabase Data
    • Add Robots.txt
    • Add Head Tags
    • Use Custom Fonts
    • Add Manifest file
    • Add Ads.txt file
    • Add Service Worker
    • Password protect the website
  • FAQ
    • Do you cache content/data?
    • Is there a white-label option for Flezr?
    • Is Flezr a tool for Programmatic SEO?
    • Can I add membership to the site using tools like Memberspace, Outseta etc?
    • Where do I host and deploy my app?
    • Are the sites built with Flezr responsive for mobiles and tablets?
    • What are the supported data sources to build webapps?
    • Can I embed an external script on the site?
  • ADVANCED TOPICS
    • Assign color codes from Google Sheets to Card Elements
  • Legal
    • Brand Assets
    • Privacy Policy
Powered by GitBook
On this page
  • Connecting Google Spreadsheet
  • Connecting Supabase DB

Was this helpful?

  1. Building your App

Connecting Data Source: Google Sheets/Supabase

PreviousBuilding BlocksNextCreating Static Pages

Last updated 2 years ago

Was this helpful?

  1. Click 'Connections' icon from the left navigation bar in the studio.

  1. Select 'Add New Connection' as shown below:

3. A new dialog box will appear as below:

4. Select 'Google Spreadsheet' or 'Supabase DB' from the 'Connection Type'.

5. Enter any name for your datasource in the 'Sheet Display Name' field.

Connecting Google Spreadsheet

If Goggle spreadsheet was selected as the connection type above, then add the 'Sheet ID'.

To get your Goggle Sheet ID, open your sheet in the Goggle Sheets app.

From inside Google Sheets: 'Share' -> 'Anyone with the Link' -> 'Copy Link'.

Next paste this link in the 'Sheet ID' field as shown above. Press 'Add Connection'

A success notification appears when the Google Sheet is added to Flezr successfully. You can verify also by clicking 'connections' from the left navigation bar.

Press the 'Save' button in the top main menu in the Studio to save your changes.

Connecting Supabase DB

If Supabase was selected as the connection type in step 4 above, the following screen will appear:

From inside Supabase, disable Row Level Security (RLS) from the table editor.

Get 'Anon Key' and 'API URL' from Supabase:

In Supabase: 'Project Settings' -> 'API Setting'.

Enter these along with the 'Table Name' of your database and click 'Fetch Columns'. Then 'Add Connection'.

Press the 'Save' button in the top main menu in the Studio to save your changes.