Integration Overview

This integration provides users with easy syncing between Google Sheets and Utility Connect! Once set up, changes to columns in Google Sheets will sync to and create/update Leads inside Utility Connect. This sync will continue to run automatically and require no user input.

To get started, please see the steps below. Further down the page is a list of fields that this integration will sync betwen Utility Connect and Google Sheets.

Connecting Utility Connect

1. Log into API Nation and sign in / create an account.
2. Navigate to Utility Connect in the Apps Marketplace.
3. Click on "Connections" and then "Add Account".
   1. 
4. Fill out your Utility Connect username, password, and Partner Code on the pop-up.
   1. If you do not know your Partner Code, please contact the support team for your code.
   2. 
5. Press Connect to complete the process.

Connecting Google Sheets

1. Log into API Nation and sign in / create an account.
2. Navigate to Google Sheets in the Apps Marketplace.
3. Click on "Connections" and then "Add Account".
4. You will be brought to Google - sign-in as needed, and you'll be brought back to API Nation and connected.
   1. 

Setting up your Workflow

1. To set up your Workflow, navigate to the Utility Connect - Google Sheets page here.
2. Click on "Activate" on "Google Sheets Spreadsheet" into Utility Connect".
   1. 
3. Select both Accounts that you would like to use as your connection for Google Sheets and Utility Connect and then press "Select". If you only have one account, just press "Select".
   1. 
4. On the "Review Settings and Start sync" page, enter the URL of the spreadsheet that you would like to sync into Utility Connect.Press "Subscribe" when you are done.
   1. 
5. Add your billing information as necessary, if it hasn't been added to your account yet. After this, you will be brought to your new Workflow.
   1. 
6. Scroll down the page and adjust the Mapping as needed. Mapping allows you to customize which fields from your Spreadsheet are chosen when syncing into Utility Connect.  A description of Utility Conect fields is as follows. Highlighted fields are highly recommended changes for users to make for the best experience with this integration.
   1. 
      1. Participants: A list of fields for any Participants associated with this Lead. This is where Agent data is most heavily stored and can be used to set. If possible, it's recommended to set these fields based on the Assigned Agent of a Lead.
         1. Participant Email: The email of an associated Participant.
         2. Participant Full Name: The full name of an associated Participant.
         3. Participant First Name: The first name of an associated Participant.
         4. Participant Last Name: The last name of an associated Participant.
         5. Participant Primary Phone: The main phone number of an associated Participant.
         6. Participant Additional Phones: An additional option if an associated Participant possesses multiple phone numbers.
         7. Participant Role: The role that identifies this Participant within Utility Connect.
         8. Participant Photo: An image to help users identify this particpant.
         9. Participant Notes: Any additional notes that may be helpful in describing this Participant associated with this Lead.
      2. First Name: The first name of the Lead.
      3. Last Name: The last name of the Lead.
      4. Full Name: The full name of the Lead, combining First and Last names.
      5. Email: The contact and primary email associated with this Lead.
      6. Additional Emails: Any additional emails possessed by this Lead.
      7. Primary Phone: The primary phone number associated with this Lead.
      8. Secondary Phone: The secondary phone number associated with this Lead, if applicable.
      9. Additional Phone: An additional phone number associated with this Lead, if applicable.
      10. Address, First Line: The first line of the Lead's address.
      11. Address, Additional Line: The second line of the Lead's address.
      12. City: The city of the Lead's address.
      13. Zip: The Zip code/postal code of the Lead's address.
      14. State: The State of the Lead's address, if applicable.
      15. Property Address: The property of interest for this Lead.
      16. Agent First Name: The first name of the Agent associated with this Lead.
      17. Agent Last Name: The last name of the Agent associated with this Lead.
      18. Agent Email: The email of the Agent associated with this Lead.
      19. Agent Phone: The phone number of the Agent associated with this Lead. 
      20. Agent Role: The role of the Agent for this Lead.
      21. Agent Photo: A link or file of the Agent for this Lead.
      22. Agent Notes: A note attached to this Agent - it is an old field that should be left blank.
      23. Address First Line: An old field that should be left blank.
      24. Address Additional Line: An old field that should be left blank.
      25. Old City: An old field that should be left blank.
      26. Old Zip: An old field that should be left blank.
      27. Old State: An old field that should be left blank.
      28. Move-in Date: The date that the Lead plans to move into a purchased property.
      29. Transaction Type: The type of the Transaction associated with this Lead, such as if it is a Listing-type Transaction.
      30. Transaction Status: The status of the Transaction associated with this Lead.

Optional - Setting up a Filter

Filters can also be utilized to only allow specific Participants to flow from Google Sheets to Utility Connect. To set up a Filter like above:

1. Press the box that says "No Filter". Select the field that you would like to use as the criteria for the sync.
2. Choose your logic statement in the middle box. In order for a Participant to sync, it needs to make this statement equal "True." Common choices include "Contains" or "does not contain".
3. Choose your value that completes the statement and acts as the "key" that allows a Lead to pass through.

In the example above, only Participants whose Tags contain "utility connect" will sync over.

Additional Filters can be added by pressing "Advanced mode" and then "Add filter." These will be additional critiera that a Lead has to meet in order to sync (additional locks requiring keys).

There is also an option to add additional rules to the Filter; these are additional "keys" that will allow Leads to pass through.

Still have Questions?

Reach out to our support team at [email protected] and respond to any inquiries as soon as possible.