Though I posted this request in the original Google Sheets Integration thread, I feel like the use case from that post was different from my own so I am starting a new discussion.
I feel Google Sheets is an integral integration to have and am honestly surprised it doesn’t already exist. As a new user of Fibery, this definitely gives me pause as importing via CSV files forces me to rebuild a ton of intricacies I have in place, specifically field types (i.e. numbers, selector lists, linked fields, attachments, relations or formulas). While I realize a lot of these would probably need to be reconfigured anyway, it can make things a lot easier with just a simple settings.
Here’s how I envision the integration:
-
User clicks “Import table from Google Sheets” in Fibery
-
If this is the first time the user is connecting the two platforms, they will be prompted to login to their Google account and give Fibery permission to access Google Sheets files.
-
User then must select the table and tab they want to import from Google Sheets to Fibery
-
Once a table/tab is selected for import, a list of each header column appears, and user must either map the Google Sheets field to an existing Fibery field OR opt for a new field to be created and specify the field type.
-
After all chosen fields are mapped, the new database is built in Fibery.
I am no software developer so perhaps I am oversimplifying things, but I think it’s more than possible to achieve this type of integration. I’d love to hear from other users as well as the Fibery team on this.