Andy Tran

Connect Gravity Forms with Smartsheet

by | Sep 4, 2020 | Wordpress

Connect-Smartsheet-with-Gravity-Form-980x653

Gravity Forms:

WordPress forms are very easy to implement with Gravity Forms, the very most trusted WordPress plugin.

Smartsheet:

Smartsheet is a software as a service application for collaboration and work management that is developed and marketed by Smartsheet Inc.

It is easy to connect Gravity Forms with Smartsheet and it doesn’t need any coding knowledge.

Before getting started, you need the following requirements:

  1. Installed Gravity Forms plugin in your WordPress.
  2. Gravity Forms Zapier add-on should be installed in WordPress. It allows form submission to be sent to configured zaps.
  3. An account in Zapier https://zapier.com/.
  4. An account in Smartsheet https://app.smartsheet.com/.

Adding a new row in the Smartsheet when a form is submitted in Gravity forms.

Form creation in WordPress Gravity Forms:

The first step in integration with Zapier is creating the form you would prefer to use to integrate with Zapier. It is very easy to integrate with Zapier if you have already existed form. So when you integrate that form with Zapier the list of fields related to that form is up to date when you are configuring your Zapier settings in your Zapier account.

Login to the WordPress admin account, go to the Forms, under Forms click on New Form as shown below.

Gravity Forms

Enter the Form Title and Form Description to create a new form.

Add New form

Choose fields from the right side and then drag or select fields. Selected fields will appear on the left side of the page. Can change or edit the field properties by clicking on the particular field.

select fields

Once done with adding all fields, you can check the form using the preview option.

To display the confirmation message when submitted the form, need to set the Confirmation settings. To edit the confirmation message go to settings and click on confirmations. Edit the text and set message that you want to display after submitting the form.

success message

Create a New Form in Smartsheet

Open the Smartsheet application and login to your account.

Smart Sheet login

After login into your account, create a new form by clicking the Form as shown below.

Select Smart Sheet form templateEnter your form name and click on the OK to continue to create the form.

set Form name

It will display the following form.

Form template

Create new fields by clicking on the symbol. Edit field names and data types by clicking on the Edit option as shown in the image.

Edit Smart Sheet fields

Once done with creating all fields click on the Save button to save the form. Click on the “Open Form” option to view the form as shown below.

View Smart Sheet form

Clicking on Open Form, will display the form.

Smart Sheet form

Once you submits the form the details will store in the following Smartsheet.

Set up your Zap action:

Once the form is ready, login to the Zapier account with your credentials.

After logging in to your account, you can see the Zapier dashboard page as shown below. Click on the Zaps or click on MAKE A ZAP as shown below to create a new Zap.

Zap: A Zap is an automated workflow that connects your apps and services easily. Every Zap consists of a trigger step that is when this happens… and one or more Do this… action steps.

To select Gravity forms, search for Gravity forms and click on the Gravity Forms icon.

Once we select the Gravity Forms, Trigger Event will automatically select New Form Submission. Click on continue.

It will display the webhook URL, copy this URL in Gravity Forms.

Login to the WordPress admin account, go to Forms and select the form which form data you are going to copy into the smartsheet.
Go to the settings, under settings there will be the Zapier option, click on that.

After entering into Zapier, it will display the Zapier setting configurations. Zap name and Webhook URL (get this URL In Zapier) as shown below.
Once all details have been entered, update the Zapier Feed.

Once done with Updating Zapier Feed, to test your trigger click on Test trigger.

Here is an example request that will test the trigger. If the request is sent successfully, then it will display the message We found a request as shown below.

Setup Action App

Next, set up your action by choosing your action app Smartsheet.

Select or connect the Smartsheet app account to use in the Zap action.

Next, the Choose App field will automatically popup once you select the app and set up an action event Add Row to the Sheet. This will be the event that the Zap performs in the selected Smartsheet application when it is triggered.

Customize the data that you want to send over to your Smartsheet application.

Data to be sent to Smart Sheet

Choose A Sheet field to send the data and add Add Row To Top Or Bottom field value based on your requirement.

select sheet

Once done with Select A Sheet, map all Smartsheet fields with Gravity Form fields.

Mapping Smart Sheet fields

Send Test Data

Once done with all your mapping set up successfully, click on TEST  then a text message will appear that is Test was successful at the top of the page as shown below.

Field Mapping test confirmation

The test data will be sent to your Smartsheet.

Once you are able to send the test data, you’re ready to turn on the Zap. In the upper right, click to the toggle to switch ON the Zap. Once your Zap is turned on, Zapier will run your action steps each time your trigger event occurs. You can view a log of all your Zap activity, including all your Zap steps, in your Task History.

Log of Zap activities

Once done with all setup, go to the WordPress form page and fill in the form.

Wordpress Gravity Form

Wordpress Gravity Form

The confirmation message will display once you Submit the form and the data will go to the Smartsheet as shown below.

Receiving data into Smart Sheet

Check this link to know more about WordPress – WordPress blogs

 

2 Comments

  1. XMC.pl

    Id wish to thank you for that efforts youve got produced in writing this post. Im hoping the exact same very best get the job done from you in the long term too. Actually your inventive writing skills has inspired me to begin my personal BlogEngine weblog now.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.