How to Connect JetFormBuilder Form to Any App with Uncanny Automator

Requirements:

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.

send letter to seller form

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.

google spreadsheet

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.
Automator recipe type

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.

select an integration

Then, I selected the needed form and clicked the “Save” button. After that, the toggle in this section changed from “Draft” to “Live.”

select a form

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.

select an integration as the action

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.
create or update a row in a google sheet

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.

create a row in a google sheet

After that, all columns created in the spreadsheet appeared.

search tokens

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.

values from the form fields

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.

live toggle on for the recipe

I navigated to the page where the “Send Letter to Seller” form was placed and submitted it several times. 

form successfully submitted

I went to Google Sheets. As you can see, all form values have been saved in the appropriate columns.

saved form values in the google sheet

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.