Shaban Forms to Sheets

By sitebyshaban

0+ active installationsVersion 1.0.0

Send form submissions from Elementor Pro, Contact Form 7, WPForms and more to Google Sheets, with a setup guide, retry queue and logs.

Description

Shaban Forms to Sheets sends the answers from your website forms to a Google Sheet that you own. You do not need Zapier or any paid service.

You deploy a small Google Apps Script once in your own Google account. The plugin then sends each submission to that script, which creates one sheet per form and adds a new row for every submission. Columns are created automatically from your field names.

Features

  • Works with Elementor Pro Forms, Contact Form 7, WPForms, Gravity Forms, Fluent Forms, Forminator, MetForm and Formidable Forms.
  • A dashboard with a step-by-step guide, where to find each form name, and fixes for common problems.
  • Connect one form, several forms, or all forms of a form plugin.
  • Use one Google account for everything, or a different account for each site or form.
  • Background sending, so visitors are not kept waiting, with automatic retries if Google is busy.
  • A log of every send with clear error messages, and a Retry button for failed sends.
  • Optional email alert when a send fails (at most one per hour, never contains form answers).
  • Combined fields, such as a Name with first and last name or an Address, are split into one column per part.
  • Rename columns, leave out fields, or send to a sheet you already have.
  • Your normal redirect to a thank-you page keeps working, so you do not need the Elementor Webhook action.
  • Password and card-number fields are never sent.

Supported form plugins

Elementor Pro (Forms), Contact Form 7, WPForms, Gravity Forms, Fluent Forms, Forminator, MetForm and Formidable Forms. The form plugin itself must be installed and active. Elementor forms require Elementor Pro.

This plugin is not affiliated with or endorsed by Google, Elementor or any of the form plugins listed above. All names are trademarks of their owners.

External services

This plugin sends form submissions to a Google Apps Script web app that you create and deploy in your own Google account. The web app address (Web App URL) is entered by you in the plugin settings, and nothing is sent until you add one.

  • Service: Google Apps Script (Google LLC), used to receive submissions and write them to a Google Sheet.
  • Data sent: the submitted form field labels and values, the form or sheet name you chose, and the secret you set. Sent each time a connected form is submitted, and when you click “Send test” (which sends sample text only). Fields named like passwords or card numbers are not sent.
  • Terms of Service: https://policies.google.com/terms
  • Privacy Policy: https://policies.google.com/privacy

Installation

  1. Upload the plugin folder to /wp-content/plugins/ or install it from the Plugins screen, then activate it.
  2. Open Forms to Sheets in the admin menu.
  3. Follow the Getting started tab: copy the script from the Google script tab, deploy it in your Google account, then add a connection in the Connections tab with the Web app URL and secret.
  4. Click Send test on the connection, then submit one of your forms.

FAQ

Do I need a paid service?

No. The plugin sends data to a Google Apps Script that you create in your own free Google account.

Where is my data stored?

In a Google Sheet in your own Google Drive. The plugin keeps form answers on your site only while a send is waiting or has failed, so it can be retried. They are removed after a successful send.

Can I use a different Google account for each site?

Yes. Deploy the script once in each Google account and add a connection with that account’s Web app URL and secret.

Do I need the Webhook action in Elementor?

No. Remove it if you added one. The plugin works directly with the form, and your redirect to the thank-you page keeps working.

Nothing arrives in my sheet.

Open the Logs tab. It shows what Google answered. The most common causes are a wrong secret, “Who has access” not set to Anyone, or a form name that does not match.

Does it work with other form plugins?

The plugins listed above are supported. Others are not supported yet.

Changelog

1.0.0

  • First release.