Connecting Data Source: Google Sheets/Supabase
Last updated
Was this helpful?
Last updated
Was this helpful?
Click 'Connections' icon from the left navigation bar in the studio.
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.
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.
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.
