Send specific data of your forms to Google Drive with 123FormBuilder

When you integrate with Google Drive all the data is imported in the form’s spreadsheet. Sometimes you need only certain information about your users. In this article, you will learn how to send specific data to Google Drive.

For this to work you will need to create a Zapier account and enable the Webhooks integration.

How does it work?

To summarize the whole process, you will create a zap between WebHooks and Google Drive and use the Webhook link on your form.

Webhooks are automated ways for different apps to send messages to each other.

Webhooks are triggered by specific events and in our case, it will be a form submission. When you create the zap, a Webhook link is provided by Zapier. That link will be placed on your 123FormBuilder form.

Let’s jump right into it to have a better understanding.

Setting up the connection

Open up your Zapier account and click on Make a zap.

make zap

Next, search for Webhooks.

webhooks zapier

At Choose Trigger Event select Catch a Hook. Click Continue.

webhooks google drive

Copy the Custom Webhook URL.

webhooks google drive

Go to your form’s Integrations section. Search for Webhooks integration and paste the Webhooks link copied earlier.

Webhooks 123FormBuilder integration

Now, form submissions are the trigger. You could add Google Drive as well.

Make a test submission on your form to help Zapier find the data. Complete the form with relevant data, you need to identify it later in this guide.

Go back to your zap settings. Below Find Data click on Test & Continue.

webhooks shopify

In the second part of the zap, search and add Google Drive.

At Choose Action Event select Create Spreadsheet row.

webhooks google drive

Next, connect your Google Drive account and select the form’s spreadsheet.

webhooks google drive

Open up the Google spreadsheet created by your form. Insert a new blank sheet (a new tab) into the existing Google Spreadsheet. Type the title for each column into the blank cells at the top of the table.
The column name doesn’t need to be exactly as your field label.

In your zap’s settings at Worksheet click on the new sheet created.

The columns from the new sheet are listed below. Click the Insert a field icon and associate it with the corresponding form field.

webhooks google drive

In the dropdown are first displayed the labels (control name) and not the field’s input value. Continue to scroll down until you see the data entered in your test submission (control value IDs). Map each field with its proper value.

Click Continue and Test & Continue. Toggle On the zap in the top-right corner and you’re done setting up the zap.

Make another test submission and check your new sheet. Only the selected columns will be populated.

Every time you receive an entry both sheets will be populated. The original one can not be deleted.

Additional Note! If you have an order form with payments enabled you can send the data in the last sheet only when the payment is completed.

To do so, go to Integrations and at Webhook enable the option called Trigger Webhooks only after payment is completed.

webhooks google drive

Leave a Reply

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

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form for more information. in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?