Get data from Google Sheet

By: Mo Adam | Asked: 09/06/2022
ForumsCategory: How-toGet data from Google Sheet
Mo Adam asked 2 years ago
Hello All, I hope there is a code snippet to FF team to add it as feature to get data to drop down menu from google sheet. This is will allow massive Integration between application. Fluent Forms post this code on their website as an advantage they provide with their plugin. I hope someone can support me on this request. I need it this option URGENTLY. Thanks a lot
2 Answers
Victor Font answered 2 years ago
I've looked at the Fluent Forms Google Sheets add-on and it apparently is a one-way feed from Fluent Forms to the target Google Sheet. It does not allow you to pull data from the sheet to use in your form. In other words, it can only populate your google sheet from form data, not the other way around. You can accomplish the same exact thing with Formidable using the Zapier add-on. If you want to use a Google sheet as the source of a drop down, you have to export the Google sheet content as a csv or xml file and import it into a lookup form in Formidable.
Mo Adam replied 2 years ago

Thanks Victor for your reply.
I am already using the code they post to get data from google sheet (Dynamic Source). The import option will not work for my request. As this google sheet is very dynamic. So to populate the dropdown from google sheet is very smart solution provided by Fluent forms Team

Please check below link it has the code

https://fluentforms.com/docs/populate-dropdown-field-options-from-google-sheet/

Victor Font replied 2 years ago

You can do this exact same thing with Formidable using the https://formidableforms.com/knowledgebase/frm_setup_new_fields_vars/ and https://formidableforms.com/knowledgebase/frm_setup_edit_fields_vars/ hooks.

How you actually process the data depends on your server setup and PHP version.

Mo Adam replied 2 years ago

I can't develop such a code. Its very generic and can support a lot of people.
I hope Formidable team suggest us same example as snippet code that will open a lot of potential. If someone from this community Techy like you Victor could post a code, Like what you post on your website, it will help a lot.

Victor Font replied 2 years ago

Writing custom code like this is time consuming and beyond the scope of what I can provide as a community volunteer. If I get a paid project in the future that has a requirement to build a dropdown from a Google sheet, I'll be happy to post it. If you need to hire a developer, please visit the Formidable Masterminds Developers Directory at https://formidable-masterminds.com/developers-directory/. Good luck.

Mo Adam replied 2 years ago

<p>Hello Victor, Can I know around cost for such custom code</p>

Russell Guilfoile replied 2 years ago

Was there ever a solution developed for this? I am also looking for the same. Feel free to contact me at [email protected]

Mo Adam replied 2 years ago

@Russell, I hope I can find a solution or a low cost solution.

Victor Font replied 2 years ago

@Mo Adam: I can't give you a ballpark estimate because I've never had this requirement to code before. Developer price ranges vary due to a number of variables such as skill, knowledge, geographic area, etc. I safe bet is to estimate 10hrs of effort. At today's current market prices in the US, a project like this could cost from $500USD to $2,000USD depending on who does the work.

@Russell Guilfoile: I'm not aware of any solutions that have been posted in the community forum.

Mo Adam answered 10 months ago
Just bring the topic again to attention, If anyone manage to find way to populate the fields from google sheet
Victor Font replied 9 months ago

You can certainly do this, but you're still looking at a custom code solution. You can use the Googlesheets API to read cell values. https://developers.google.com/sheets/api/guides/values

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right