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.
I, for one, was a big fan of using Fibery to generate dashboards on top of Google Sheets and I know this is late, but I wish the option would still be there. Just today, I wanted to do some data analysis on a survey we had run on Google.
Thanks @njyo. I am even later in responding. It felt the Fibery community didn’t give a rats @$$ about my recommendations or questions so I just stopped using it. I decided to recheck it out today to see if there have been any major updates since.
My main question I’d have is what added value does this import have over simply exporting csv and reimporting csv? Maybe I’m missing something.
If it’s a read only “Sync” integration, I’d understand the use case a bit more since you don’t need to rexport and reimport every time, but from what you’re describing it sounds to me like an import to existing databases.
Probably the biggest move since your post has been the capability of AI agents to solve this problem. And Fibery has made some major updates.
I currently import a few things and you can go a few ways depending on how often your spreadsheet change structure (new columns etc). how often new data flows into the Sheet, and the size of the Sheet.
Fibery now has MCP. Just chat in your agent, point it to the CSV, and ask it to create the Fibery db and upload the data. Done.
If you need infrequent updates, do the same again in a chat ask agent to use Fibery MCP to update data in Fibery. Or ask your agent to set it up as a routine to upload it on a schedule (Claude has routines for example).
Copy the headers and a few rows of data from the Sheet and paste them into the native Fibery AI. Ask it to build you a new database.
Use an automation platform like n8n. It does have other complications but it is a powerhouse. You don’t even need to touch n8n to build the workflow, it also has an MCP so it can build the entire workflow for you from scratch.
Use the Integration Agent in Fibery to build an integration for you. It works best with public API sources but it should do well with a Google Sheet in a structured table. You may have issues with Auth to actually get access to the Sheet (I haven’t tried but know Google is a bit of a pain).
Don’t get me wrong, I still think there should be a native Google Sheets integration, it’s one of the most widely used data tools on the planet. But there are other ways to get the data into Fibery now with AI.
