Best Automation Platform for Automating Fluent Stuff?
I want to create a Wordpress user and add the new user to a FluentCommunity course when I add their name and email to a Google Sheet.
It seems like a really simple task but with each thing I try I keep getting stumped.
I have tried native Fluent integrations, automatorWp, Flowmattic, Pabbly, and I was about to try Integrately, Make, BitFlows, and a few others but rather than keep stumbling my way through those and getting stuck I thought I'd ask here. (I don't want to use Zapier)
I do it manually with a FluentForm right now, and it works perfectly, but I need to automate it from my Google Sheet.
I'm sure I am overcomplicating this and there must be some super simple solution that I am missing. Any ideas?
FluentCRM is what I use for automation. Just curious, why do you add the name and email to a Google Sheet? You may not need to do that if you use FluentCRM. Fluent Forms integrates with Google Sheets, so I'm not sure what part you have to do manually. You could create a small app script in Google Sheets so FluentCRM could push the data with a webhook.
FluentCRM can create a WordPress user and add them to a FluentCommunity course. You likely would not need the Google Sheet at all.
FluentCRM is much cheaper annually than even the Basic plan for Uncanny Automator, and it offers much more capability if you use it to manage your accounts and send email.
The students come in from about 6 or 7 different sources William Beem and the only thing all the sources have in common is that they can all write to a Google sheet, so that sheet is currently the only place that every student exists (and I could add new sources to it in the future if necessary)
Nicolai I don't know how you have everything set up, but I think that is your problem. It's better to fix it with an architectural choice rather than slapping in another plugin to plug the gaps.
If all the sources can write to Google Sheets, can you change them to use Fluent Forms? If so, Fluent Forms will communicate natively with FluentCRM. If that's not possible, then you likely have issues I don't understand with your sources.
Just a suggestion if you can make it work. Lower cost, better results.
William Beem for example, there are a few different payment platforms and 2 other online shops that send students into the course. They all already record all the students into a Google Sheet via api or automation. There are also people who sign students up manually.
It's very easy to get almost any source into a Google Sheet.
It should be much easier to create a student from that sheet than to have to go to each of those sources and integrate their intake process into my Fluentcommunity.
Cost is not really an issue as I have licences or active accounts for about 10 different automation platforms.
We use FlowMattic and have been happy with it. Based on recent Facebook posts, they have a new version coming out very soon that has some awesome new features (creating PDFs, etc.). Nitin Yawalkar might provide more info.
Thomas Oates good to know. I do have a Flowmattic license, and I did try it but something didn't work for me. I forget what, since I've tried so many in the last day.
I've been using Bitflows, and it works perfectly with all the Fluent plugins. It comes with a ton of actions and triggers. It's slightly cheaper than the other options out there, but definitely a solid choice.
Shanto Asif thank you. I will try it. I have a license for Bitflows but I don't think I've tried it yetn for this. Sounds promising.
I'm thinking that maybe I should just focus on getting the Google Sheet to WordPress user automated, most automators can do that.
This way I don't need an automation that can hook into fluent products, almost any automation platform can create a WordPress user when a new row is added to Sheets.
Then I can do the rest in a FCRM automation that signs every new WordPress user up as a community member and gives them access to the course.
Hi Nicolai ,
I understand your use case. Yes, you can achieve this use case using Bit Flows.
Google Sheets is available as a trigger in Bit Flows. Kindly follow these steps:
- Choose Google Sheets and select the "On Row Added" event.
- Use WordPress as the action and select the "Create New User" event.
- Lastly, use FluentCommunity as the action and select "Add User To Course."
Here is the flow JSON file:https://drive.google.com/file/d/1CXSGO7stTzaTzNdyLo8HO385hZbxnHgt/view?usp=sharing .
You can download and import it. The flow will be ready. If you need any assistance please let me know.
Thank you.
Perfect Tanvir Chowdhury ! Thank you.
Like Shanto, I also think BitFlows is a good Zapier alternative which is Wordpress native. But these days you could always just forward the email to an AI that's programmed to add a row to a Google Sheets?
We use Flowmattic extensively with Fluent Suite. From automatic FluentCommunity post creation, moderation and administration, to interconnecting Fluent Suite tools to SMS messages, emails, PDFs, image generation, social media posting, VOIP services and everything else. It's so powerful, we've essentially saved thousands on Zapier zaps, and curtailed the N8N mess we had, and fully automated several law firms from intake to deliverable generation.
Nicolai, you have two options.
-
Use an intermediary layer that connects Google Sheets with FluentCRM, and do everything from there. It could be Uncanny, BitFlow, FlowMattic, any of them, but this involves an additional license cost if you don't already have it, and dealing with a whole host of configurations.
-
FluentCRM has an inbound webhook option. You can create a small script so that every time a new row is inserted into your Google Sheets, the information is sent directly to FluentCRM, and from there you do everything in FluentCRM. Fast, no additional costs, no intermediary layers.
If you still haven't solved it, leave your question here and we'll help you.
Best regards and much success!
Like this?
That's it @virtualawyer. Thanks. For some reason (can't remember the details anymore) I had trouble connecting Sheets to Flowmattic.
Nicolai The Flowmattic GSheet integration is a bit iffy at first b/c the API and OAuth provisioning is not straightforward, but once you get it to work, it syncs beautifully. We use GSheets to colllate and merge date from multiple sources, too.
Good to know, thanks Christian Frank I'll be more diligent with it next time I tackle it.