How to Connect JetFormBuilder Form to Any App with Uncanny Automator
- Uncanny Automator (Free or Pro version) installed and activated;
- JetFormBuilder plugin installed and activated with the form created and placed on a page.
Uncanny Automator is a plugin that allows you to connect plugins and apps to automize the WordPress website activity without coding. With this plugin, you can connect JetFormBuilder forms to such apps as Airtable, Google Sheets, Google Calendar, Instagram, Facebook, etc. A complete list of available integrations can be found on the Automator WordPress Plugin Integrations page.
Use cases include sending form data to Airtable and Google Sheets, registering users, setting CRM tags, and setting up notifications and email campaigns.
Uncanny Automator has such triggers for JetFormBuilder:
- Triggers for logged-in users:
- a user submits a form;
- a user submits a form with a specific value in a specific field (Uncanny Automator Pro).
- Triggers for everyone:
- a form is submitted;
- a form is submitted with a specific value in a specific field (Uncanny Automator Pro).
I will show how to connect the JetFormBuilder form to any app with the Uncanny Automator (free version) on the example of Google Sheets.
I created the “Send Letter to Seller” form by submitting which users can leave feedback about my website. To learn how to create a similar form, proceed to the Contact Form tutorial.
To store all messages in one place and be able to proceed through all of them to get users’ insight into my service, I want to connect the form to Google Sheets.
I created a new Google Sheet and added three rows that will be filled with the information from the form: user name, email, and message.
I proceeded to the WordPress website and moved to the Automator > Add new tab.
At the beginning of the recipe creation, you can select two types:
- Logged-in users. The recipe will be triggered by logged-in WordPress users;
- Everyone. The recipe will be triggered by logged-in WordPress users or logged-out visitors.
I selected the “Everyone” option, so any user will be able to leave feedback.
I named the recipe and selected the “JetFormBuilder” integration as the Trigger.
Then, I selected the needed form and clicked the “Save” button. After that, the toggle in this section changed from “Draft” to “Live.”
In the Action section, I pushed the “Add action” button and selected the “Google Sheets” integration. Be aware that you may need to connect the Google Sheets accounts if you haven’t done it before.
There are two options here:
- Create a row in a Google Sheet. Select this option if you want the action to save a form field value in a new row;
- Update a row in a Google Sheet. Select this option if you want the action to update a form field value in the row. This option is useful for the “Update post” or “Update user” forms.
I picked the “Create a row in a Google Sheet” option to save the values of every newly submitted form in the new row.
Then, I selected the needed Drive, Spreadsheet, and Worksheet and hit the “Get columns” button.
After that, all columns created in the spreadsheet appeared.
I pressed the asterisk icon in the Value field and selected the corresponding form field, the value from which will be saved in the row.
Having done this with all columns, I pushed the “Save” button. After that, the toggle in this section changed from “Draft” to “Live.”
In the Recipe section, I enabled the toggle and changed its status from “Draft” to “Live” to make the form active.
I navigated to the page where the “Send Letter to Seller” form was placed and submitted it several times.
I went to Google Sheets. As you can see, all form values have been saved in the appropriate columns.
That’s all. Now you know how to connect the JetFormBuilderform to any app with the Uncanny Automator(free version) on the example of Google Sheets.