Integrating Google Forms & Apptivo

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”
   
2. Click on “Blank” (Start a new form) 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
      
      
      
   3. Give your form a name, and make any other desired adjustments

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…”
   
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 Code.gs), we want to paste in the special Apptivo code.
   1. Click here to view the code: https://pastebin.com/raw/B6ECQLue
   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.
      
4. Now click “File” in the upper left corner, then hover over “New”, and select “Script”
   
5. Provide name of “Config.gs” for the file name, and click OK
6. Now in the main area of the page (editing Config.gs) you want to paste in a different chunk of special code
   1. Click here to view the code: https://pastebin.com/raw/RwGEfaD6
   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 Config.gs 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”

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
   
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”.
   
5. You will now be taken through a few steps to confirm permissions for Apptivo. Simply follow these steps until complete.
   
   

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.

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

After about 10 seconds, you should be able to find that test lead inside of 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.

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:
https://morningstudio.com.au/blog/2013/06/how-to-style-google-forms/