Google Sheets Add-On for Submission Forms
September 27, 2016 13:53
Pipeliner CRM Google Sheets Add-On for Submission Forms is built to quickly capture lead, opportunity, contact and account from Google Form attached to your website or email into Pipeliner CRM Desktop app.
PLAN AVAILABILITY | × Personal × Personal Plus ✓ Starter ✓ Business ✓ Enterprise
About Pipeliner CRM Google Sheets Add-On for Submission Forms
Pipeliner CRM Google Sheets Add-On for Submission Forms enables you to use your Google forms attached to your website as a record capturing tool for Pipeliner CRM.
How does it work?
With Google Forms you can create beautiful online web forms attached to your website, for example "contact us" or lead forms. With Pipeliner Google Add-On you can capture those forms' submissions directly to Pipeliner CRM. The Pipeliner Google Add-On allows you to add leads, opportunities, accounts or contacts to Pipeliner, directly from your company's Google form. Pipeliner CRM Google Add-On enables you to create new:
The precision of this integration means you can map your Google form data exactly to where it belongs in Pipeliner. Then, when a website visitor fills in the Google form and submits the data, Pipeliner Google Add-On auto-creates the new lead, opportunity, account or contact right in Pipeliner CRM.
What are the system requirements?
- Google Account - You need to have a Google account, from which you can access Google Sheets and Google Forms.
- Pipeliner Account - You need to have Pipeliner Account. If you do not have one yet, do not hesitate to sign up for Pipeliner CRM.
What skills are required?
- You need to have a common understanding of how Google Forms works. However, we have prepared a some useful help resources for you, to get you started in a couple of minutes. Just follow this step by step guide to learn how to set up Pipeliner CRM Google Add-On. We believe you can do it ;)
Step by Step Guide for Pipeliner Google Add-On If you prefer to watch the step-by-step video guide, just watch it below. To review all the steps in writing, jump directly below the video.
Introducing Pipeliner CRM Google Add-On (Lead Capture Example)
The guide below describe the step-by-step guide to configure Pipeliner Google Add-on for the Lead Capture Process. However, you can use it to also capture contacts, accounts or opportunities directly to Pipeliner CRM.
Screencast: Play in a new window.
#1: Install Pipeliner Google Add-On
During this process you will activate Pipeliner Google Add-on within your Google Sheets account.
Once you have activated it, you can access a simple guide that guides you through the process of setting up Pipeliner Google Add-on. You can now find the Pipeliner Google Add-on under "Add-ons".
#2: Connect the Pipeliner CRM API Key
During this process you will connect Pipeliner to the Google Sheet.
After successful configuration of the API Key, you can now connect your Google Form with the Pipeliner Form.
#3: Connect the Google Form to Pipeliner Form
In order to start your lead capture process, you need to map the Google Form fields with Pipeliner Lead form fields. Quick Tip: We have prepared three templates you can use. These templates map the default fields from Pipeliner CRM and consists of pre-defined Google Form fields accordingly. You do not need to perform any mapping.
Now, you can start to use your Google Form in order to capture records to Pipeliner CRM.
#4: Fill in the Google Form Questions
In order to access your Google Form and submit it's first submission follow these steps:
This lead capture process will create a new record in your Google Spreadsheet as a one dedicated row and one new lead in Pipeliner CRM.
Note: If you do not want to use Pipeliner Templates, you can easily create your own Google Form Questions and map them with the fields of the corresponding Pipeliner form.
#5: Review the submission in Pipeliner CRM
After your web visitor fills in the web form and clicks "submit," the new lead will be created in Pipeliner CRM in couple of seconds.
Now you can start capturing records with Pipeliner Google Sheets Add-on in seconds.