Plugin MetForm Setting – PRO Version

How to Create and Connect a MetForm Form with GSheetConnector for Elementor Pro

Important Note Before You Start

GSheetConnector for Elementor Pro works with Elementor forms. However, the Elementor Form Widget is only available in Elementor Pro.

If you are using the free version of Elementor, you will not have access to the Elementor Form Widget, and therefore you cannot create forms using Elementor’s built-in form builder.

To support Elementor Free users, GSheetConnector also provides compatibility with MetForm, allowing you to create forms and sync submissions directly with Google Sheets.

Step 1: Install and Activate the MetForm Plugin

Before creating a form, you need to install the MetForm plugin.

Follow these steps:

1. Log in to your WordPress Admin Dashboard.
2. Navigate to Plugins → Add New Plugin.
3. In the search box, type MetForm.
4. Locate the MetForm plugin from the search results.
5. Click Install Now.
6. After installation is complete, click Activate.

Once activated, MetForm will be available in your WordPress dashboard.

Step 2: Create a New Form Using MetForm

After installing the plugin, create your first form.

Steps:

1. Go to MetForm from the WordPress Admin Menu.
2. Click Add New Form.
3. Enter a suitable form name.
4. Select a blank template or any pre-built template according to your requirements.
5. Add the required form fields such as:
6. Name
7. Email
8. Phone Number
9. Message
10. Any custom fields you need
11. Save the form.

Your MetForm form is now ready to be embedded on a page.

Step 3: Add the Form to a Page

Once your form is created, you need to display it on a page.

Steps:

1. Navigate to Pages → Add New.
2. Create a new page or edit an existing page.
3. Click Edit with Elementor.
4. Search for the MetForm Widget in Elementor.
5. Drag and drop the MetForm widget onto the page.
6. Select the form you created from the dropdown list.
7. Configure the page layout if required.
8. Click Publish or Update.

Your form is now live and ready to accept submissions.

Step 4: Create a Form Feed in GSheetConnector for Elementor Pro

After creating your form, you need to connect it with GSheetConnector.

Steps:

1. Navigate to GSheetConnector for Elementor Pro from the WordPress Dashboard.
2. Open the Form Feed tab.
3. Click the Add Form Feed button.

You will now see the feed creation form.

Configure the Feed

1. Enter a name in the Feed Name field.
2. Select your MetForm Form from the form dropdown.
3. Review the selected form.
4. Click the Submit button.

Step 5: View the Feed List

After creating a feed, it will appear in the Sheet Sync Feed List Table.

The feed table helps you manage all created feeds from a single location.

Understanding Feed Actions

Inside the feed list table, you will see an Action column containing several icons.

View Feed

The Eye Icon allows you to view the feed details and check which form is connected to the feed.

Edit Feed

The Edit Icon allows you to modify the feed settings at any time.

You can update:

• Feed Name
• Form Selection
• Google Sheet Configuration
• Mapping Settings

Delete Feed

The Delete Icon permanently removes the feed from the system.

Feed Status Toggle (Very Important)

The last column in the feed table is the Status column.

This status controls whether form entries will be sent to Google Sheets.

When Status is Enabled

• Form submissions will be processed.
• Entries will be automatically sent to the connected Google Sheet.

When Status is Disabled

• Form submissions will still be received on your website.
• No data will be sent to Google Sheets.
• The feed remains connected but inactive.

Feed Table Overview

In the Feed Table, you can view all your created Feeds with the following details:

• Feed Name: Displays the name of your created Feed.
• Page Name: Shows the page where your Elementor Form is added.
• Time: Displays the Feed creation date and time.
• Feed Status: Shows whether the Feed is enabled or disabled.

Feed Actions

The Feed Table provides different action options:

View Icon (Eye Icon) –  Click on the Eye Icon to view the connected form details of your Feed.

Edit Icon –  Click on the Edit Icon to open and configure Feed Settings.

Delete Icon – Click on the Delete Icon to remove the Feed.

Feed Status

The Feed Status option controls whether your Feed Settings will work or not.

• If the Feed Status is Enabled, your Feed configuration will work and form submissions will sync with Google Sheets.
• If the Feed Status is Disabled, your Feed Settings will not work even if the configuration is completed.

Feed Detail Settings

When you open Feed Settings, you will see different configuration options.

Feed Information

At the beginning of the Feed Detail page, you will see basic Feed Information, including the connected form details.

Manual Google Sheets Configuration

The Enable Manual Google Sheets Configuration option allows you to manually enter your Google Sheet details.

Enable this option to display the required settings:

• Sheet Name
• Sheet ID
• Tab Name
• Tab ID

To get this information:

1. Open your Google Sheet.
2. Copy the required details.
3. Enter the information in the respective fields as shown in the screenshot.

Service Account Permission

If you are using the Service Account Method, your Google Sheet must be shared with the Service Account email address.

• If the Google Sheet is not shared with the Service Account email, the Service Account email will appear in red color.
• If the Google Sheet is shared with the Service Account email and Editor access is provided, the Service Account email will appear in green color.

You can verify the Service Account connection status using the email color indicator.

Automatic Google Sheet Configuration

The Automatic Google Sheet Configuration option allows you to select your Google Sheet without manually entering Sheet ID and Tab ID.

Follow these steps:

1. Select your Sheet Name.
2. Select your required Tab Name.

1. Click on the Click Here link available below the Sheet selection option.
2. The plugin will fetch all available Google Sheets from your connected Google account.
3. After fetching, your available sheets will appear in the dropdown list.

Select Field To Sync

The Select Field To Sync option allows you to choose which Elementor Form fields should be sent to Google Sheets.

Select All Fields

• Enable the Select All option to select all form fields automatically.

Select Individual Fields

• You can enable or disable individual fields using the toggle option available next to each field.

Change Field Order

• You can drag and drop fields to change their position.
• The field order will decide the column order in your Google Sheet.

Field Column Preview

• The selected field position will display the corresponding Google Sheet column where the data will be stored.

Edit Field Name

• Each field has an Edit Icon.
• Click on the Edit Icon to change the field name before syncing it with Google Sheets.

Header Setting

The Header Setting option allows you to customize the appearance of your Google Sheet.

You can customize:

Freeze Header

• Enable the Freeze Header option to keep the header row fixed while scrolling.

Header Style

Customize the header appearance:

• Font Size
• Font Color
• Font Style

Row Style

Customize the Google Sheet row appearance:

• Font Style
• Font Size
• Font Color
• Odd Row Color
• Even Row Color

After completing all settings, click on the Save Settings button to save your Feed configuration.

Google Sheet Data Sync

The Google Sheet Data Sync option allows you to sync existing form submission data with Google Sheets.

You can use this option when:

• You want to import old form entries.
• You need to perform data-wise synchronization.
• You want to sync previously submitted form data after creating a Feed.

Using this option, you can transfer existing form data to your connected Google Sheet.

Save Feed Settings and Test Form Submission

After completing all Feed Settings, click on the Save Settings button.

Once the Feed Settings are saved successfully, the plugin will automatically create the header row in your connected Google Sheet using your Elementor Form field labels.

All selected form fields will be displayed as column headers in the connected sheet.

Test Form Submission

After saving the Feed Settings, it is recommended to test the integration.

1. Open the page where your Elementor Form is published.
2. Fill out the form with sample information.
3. Click on the Submit button.

You will see the submitted form data automatically added as a new row in the sheet under the corresponding column headers.

This confirms that your Elementor Form and Google Sheet integration is working correctly.