Apptivo has developed an integration with Google Forms so that users can easily create forms, embed them on their website, and have the submissions captured in their Apptivo CRM. This works by creating a Google Form like normal, but then we perform some additional configuration to that form so it creates a new sales lead in the Leads App when submitted.

This example simply creates a new lead in Apptivo, but could be modified for many other scenarios (Creating new help desk tickets, appending information to projects/deals in progress, capturing contact details, etc).

Google Forms Overview

Google Forms is an application available for free with Gmail accounts, as well as being a part of G Suite. It’s a simple tool that allows you to create a form with any questions desired (text fields, dropdowns, etc). This form can either be shared directly with people via email, or you can embed an HTML snippet onto your website and display the form there.

This guide will cover the creation of a basic form, and then we’ll provide some on how to embed that form on your website below.


To perform this integration you’ll need a few things:

  • Have a Google account (G Suite or Gmail both work)
  • Have an Apptvo premium, ultimate, or enterprise account
  • Have Super User access in your Apptivo account
  • Configure all of your fields in the Leads App exactly how you want them

Note for developers: it is possible to modify this integration to change field names, values, and submit hidden fields with code.

Setup Instructions

Before we get started, we need to think about what our form is for. In many scenarios, your website will have a simple contact form, and you just want that form to be submitted directly into your CRM. You might already have an existing form created, in which case you can skip the first section down below.

Here are the high-level steps we’ll follow:

  • Create the Google Form with all fields
  • Ensure our fields match our Apptivo account
  • Integrate the form with Apptivo by inserting some special code
  • Run a test to make sure things are working
  • Embed the form in your website
  • Create Your Google Form

    This step doesn’t include anything specific to Apptivo, so feel free to explore other guides on customizing your Google Form from across the web. The only key requirement you must consider is that the fields inside of your Google Form must match the fields configured inside of Apptivo exactly.

    For example let’s say you want to create a dropdown menu called “Type of Business”, with options of “IT, Manufacturing, Government, Education, and Other”. You should first go into Apptivo, and configure it with that label and values, then just create everything exactly the same in Google. So long as the text matches up, the integration will automatically place data into any of your custom fields.

    Start by logging into your Google account then..

    1. Select “Google apps Grid” Icon, Click on “Get more apps”, Click “Forms”
      Forms Navigation
    2. Click on “Blank” (Start a new form) form
      Create New Form
    3. Configure all desired form fields
      1. If you have any required fields in Apptivo, make sure to mark them as required here
      2. Common fields include First Name, Last Name, Company, Phone, Email, Description
        Edit First Name
        Edit Email
        Edit Description
      3. Give your form a name, and make any other desired adjustments
    Completed Form Preview

    Note: If you are on G Suite, you might need to change the form settings and uncheck “Restrict to [your company] users”

    Integrate Your Form to Apptivo

    Once we are satisfied with our form, we have a few steps to complete the connection with your Apptivo account.

    1. Copy+paste some code in the script editor
    2. Update with your Apptivo account API & access keys
    3. Create a trigger to run when submitted

    Configure the Script Editor

    This is the most complex part, but don’t worry, you don’t need to know programming to complete these steps.

    1. In the top right corner, click the 3 dots, then click “Script Editor…”
      Open Script Editor
    2. Click the text “Untitled Project” in the upper left corner,type in “Apptivo Lead Submit”, and click OK
    3. Now in the main text area of the page (editing, we want to paste in the special Apptivo code.
      1. Click here to view the code:
      2. Copy everything on the screen to your clipboard
      3. Now paste the entire contents into the editor in Google Forms. This should replace everything, including the default text that is already present before you paste.
        Pasted Code
    4. Now click “File” in the upper left corner, then hover over “New”, and select “Script”
      Create New Script
    5. Provide name of “” for the file name, and click OK
    6. Now in the main area of the page (editing you want to paste in a different chunk of special code
      1. Click here to view the code:
      2. Copy everything on the screen to your clipboard
      3. Now paste the entire contents into the editor in Google Forms. This should replace everything, including the default text that is already present before you paste.
    7. Lastly you need to update this code with your API & Access key, shown in the next section

    Update Your API/Access Key

    This section requires you to have Super User access in your Apptivo account. First you’ll log into your account and locate the page with your API & Access key.

    Now in the previous step we pasted in some code that contains some sample keys, and we just need to replace them.

    //Replace everything in between the quotation marks with the API Key from your Apptivo account
    var apiKey = ‘vxYDzLZYxPwO-QyY55vUvDjSv-cb34493-2b1a-43ab-8fa1-6c7347725f’;
    //Replace everything in between the quotation marks with the Access Key from your Apptivo account
    var accessKey = ’96R53463CnIfH34′;

    As noted in the text, carefully copy & paste the API Key from Apptivo first, and replace the line that starts with “var apiKey”.

    var apiKey = ‘vxYDzLZYxPwO-QyY55vUvDjSv-cb34493-2b1a-43ab-8fa1-6c7347725f’;

    Now repeat the same for the access key, and you are done.

    Create Your Trigger

    Before we create a trigger, you should save your progress. Click “File” in the upper left corner, and select “Save All”

    Save Scripts

    Now we’ll follow a few final steps to enable the submission to Apptivo:

    1. Click the clock icon in the menu bar to open triggers
      Create New Trigger
    2. A popup will open with some blue text that says “No triggers set up”, click that link (or add a new trigger)
    3. Change the “Run” dropdown to “onSubmit”
    4. Leave the other options as their default selection, and click “Save”.
      Save New Trigger
    5. You will now be taken through a few steps to confirm permissions for Apptivo. Simply follow these steps until complete.
      Authorize Access
      Grant Access 2

    That’s it! Your form is now connected to Apptivo and ready to test.

    Test The Results

    Now that our form is fully integrated, we can run a test. You can close the script editor tab and return to the page where you are viewing/editing your Google Form.

    Now click the “Send” button in the upper right corner, and select the link icon to view a hyperlink.

    Get Link to Send

    Now open this link in a new browser tab, and you should be able to type in your form details and submit a test.

    View Form as User

    After about 10 seconds, you should be able to find that test lead inside of Apptivo.

    New Lead in Apptivo

    Embed In Your Website

    Now that everything is up and running, the last step is to get this form in front of your customers! Navigate back to the page where you are viewing/editing your form, and click the “Send” button in the upper right corner.

    Now click the < > icon to view the embed HTML, and specify a good width & height for where you’d like to place the form.

    Get Embed HTML

    Now just paste this code into any page(s) on your website where you’d like it to display. This step will vary based on who your current web host is, and which platform you use. For instructions on how to embed HTML code on your website, please see your current website provider.

    Customizing The Design of Your Form

    The default form allows basic control over the size of the form, but not much else. It is possible to customize this further, but will require HTML/CSS knowledge to proceed. There are several guides available across the web that you can leverage, such as this:

    Latest Blogs

    No Image in Post

    Apptivo's Integration with Amazon SES for Outgoing Email Server

    Amazon Simple Email Service (SES) is an email platform that provides an easy, cost-effective way to send and receive email using your email addresses and domains. Apptivo has migrated its email service to Amazon SES (Simple Email Service) to enhance the performance and reliability of our email services

    Read more 
    No Image in Post


    1.What is customer service software? 2

    Read more 
    No Image in Post

    Maximize your business performance with seamless CRM Integration

    1.What is CRM Integration? 2

    Read more