1. Home
  2. Docs
  3. Avada Forms Google Sheet ...
  4. Forms Connecting with Google Sheet

Forms Connecting with Google Sheet

This guide makes it easy to Configuration of Avada Forms and the Avada Forms Google Sheet Connector Plugin.

Integration of Avada Forms with Google Sheet:

Avada Forms Feeds Setting :

In Google Sheet – Feeds Tab :-

In WordPress Dashboard :

  • Navigate to Avada > Google Sheet > Google Sheet – Feeds.

Fetch Sheets :

  • If you haven’t fetched sheets from the integration tab, click on “Fetch sheets.”

Add Feed :

  • In the Google Sheet – Feeds tab, click on “Add Feed.”

Forms Connecting with Google Sheet

Name The Feed:

  • Provide a name for the feed.
  • Select the page.
  • Click “Submit.”

94nMm7amtKrduGZIz7SrdtrRvDZ 3ASt4Q Forms Connecting with Google Sheet

Edit the Feed:

  • Once the feed is successfully added, edit the feed.

FL Forms Connecting with Google Sheet

Fetch Fields & Save Form Fields:

  • Click on “Fetch Fields” to retrieve form fields.
  • Save the form fields.

Forms Connecting with Google Sheet

Google Sheet Setting:

Integration:

  • Ensure the integration is complete as per the instructions.

Fetch Sheets:

  • Click on “Click here” to fetch sheets.

Select Google Spreadsheet:

  • Choose the existing Google Spreadsheet or create a new sheet.

Save or Submit Data:

  • Select Google Sheet and Tab Name.
  • Save or submit data.

Enable Manually Adding of Sheet Name and Tab Name:

  • Optionally enable this checkbox to manually add the sheet name and tab name.

X81KqERVBpKA63i8ntPJApuQEk2T WYZ0w Forms Connecting with Google Sheet

Manually Adding Sheet Name & Tab Name:

  • Manual Method:

    • Manually add Google Sheet Name, Google Sheet ID, Google Sheet Tab Name, and Google Sheet Tab ID.
    • Save and submit data.

qdcwu9cM1p4kn1U9tgaPj1hrclsI1mUeYg Forms Connecting with Google Sheet

Field List Setting:

Fetch Fields:

  • Click on “Fetch Fields.”

Enable Fields:

  • Enable the fields you wish to view in your Google Sheet.

Sort Fields & Rename:

  • Optionally, sort and rename fields.

Forms Connecting with Google Sheet

Header Management & Synchronization:

Header Management:

  • Freeze Header: Enable to stick the header to the top.
  • Header Color: Set the background color for the header.
  • Odd Color: Set the background color for odd rows.
  • Even Color: Set the background color for even rows.

Submit Data for Save:

  • Save the configuration.

Synchronization:

  • Click on the image to sync Avada form entries to Google Sheets.

QpuTbyGanUczZapyZV EMoqzIOhWRJLpRw Forms Connecting with Google Sheet

How can we help?