Send Form Data From Google Sheets To FluentForms (Without Zapier)?
I would like Google Sheets to be able to send/submit data to a FluentForm without using Zapier. Is that possible?
I have tried to connect Integrately, Make, AutomatorWP and a few others, but none seem to be able to send from Google Sheets TO a FluentForm.
I guess I am stuck on how does one submit data to a form without entering it manually. I have FluentForms Pro.
We already have a direct integration: https://fluentforms.com/docs/how-to-integrate-google-sheets-with-fluent-forms/
Thank you Shahjahan Jewel but I want to go in the other direction, I want to send data from a spreadsheet into** a Fluent Form.
What is the purpose of this? Forms are usually used to enter data...
André Daus true. Im trying to find a way to get data from Google Sheets to create a Fluent Community course student + WordPress user, and I can't seem to get that automated. I have a form that does it, so if I could get the Google Sheet data to submit the form when there is a new row it would get the job done.
Nicolai OK, I see. That's not the way it works. If you want to send data from the Google Sheet if a row is edited, you need to add a trigger to the sheet itself (Extensions > Apps Script) and add something like UrlFetchApp.fetch() to send the data to your Wordpress. On Wordpress, you need to create a webhook that takes this data and does whatever you need. I made a video about that some time ago: https://www.youtube.com/watch?v=n624Gbc2fHg
Yes thank you André Daus I do know how use webhooks but this site doesn't have Community Pro and webhooks are a pro feature. Since the form is already working, I was just wondering if it was possible to submit to the form via an automation.
The way I will solve this is to have Google Sheets create a new Wordpress user, and then a FluentCRM automation will enroll all new users into the course. That will have the same effect.
Nicolai great you found a solution.