...

1. Make sure the version of  is compatible with the version of the Google Connector you are installing. View the compatibility matrix to check the versions. If you are not using the correct version of , first upgrade your server software.  

2. Stop .

3. Download the compatible version of the Google Connector from our frevvo Software Download Directory. Rename Extract the .zip file to a temporary location. Copy the google.war and copy it to c:\<frevvo-home>\tomcat\webapps. 

4. If you are running  on your local machine, you must set a domain name for your machine - otherwise you can skip this step. 

   1. Ex: For Windows edit the C:\WINDOWS\system32\drivers\etc\hosts file as an administrator and modify the 127.0.0.1 entry with a domain name:  

      Code Block
      127.0.0.1 example.com

      Note

      If you are currently using a previous version of the Google Connector and you want to upgrade, follow these steps if you are using the Tomcat bundle: Ensure you have downloaded the supported version of OpenJDK. Check Supported Platforms before beginning. Stop Download the Google Connector. Rename the google-connector-2.3.1.war to google.war and replace the existing one in <frevvo-home>\tomcat\webapps. Delete the <frevvo-home>\tomcat\webapps\google directory. If this directory is not deleted then the Google Connector will run from the old directory and the newer version won't take effect. Continue with step 5.

5. Go to https://console.developers.google.com. Login to the google account that you are going to use with the Google connector. View this Google documentation to help you set up your project: https://developers.google.com/adwords/api/docs/guides/authentication, or follow the steps below. If you have a Location Group/Business Account your Google Domain admin will need to set up the organization and give the frevvo user permission to add projects to it. Please see this google documentation for details. 
   

6. Create a new project.
7. Enable the Google Drive API named Drive API.
8. Enable the Google Sheets API named Sheets API.
9. Select the email address you want to associate with this project on the OAUTH consent screen. Provide a project name. Click Save.
10. Go to Credentials - Create new client ID
1. The Consent screen must contain a product name and email address before continuing.
2. Application Type = Web Application
3. Authorized Javascript Origins = Empty
4. Authorized Redirect URIs = http://<DOMAIN_NAME>/google/credential. Replace <DOMAIN_NAME> with your domain name. If you are using localhost, this name must match the entry in your hosts file and you must provide the port number.
5. Click Create Client ID.
11. Click the Download JSON file. The credentials from this file (client id and client secret) become available to the Google Connector as a property in the frevvo-config.properties file.
    
    1. If you do not have a file named frevvo-config.properties in <frevvo-home>\tomcat\conf, you can rename the JSON file to frevvo-config.properties.
       

       1.  Edit the file and append the prefix client.secrets= to the file content.

          Code Block

          client.secrets={"web":{"client_id":"1042723840399-112fedk6nurt8j657rl4etl8441m3evf.apps.googleusercontent.com","project_id":"maryann-domain","auth_uri":"https://accounts.google.com/o/oauth2/auth","token_uri":"https://accounts.google.com/o/oauth2/token","auth_provider_x509_cert_url":"https://www.googleapis.com/oauth2/v1/certs","client_secret":"E1P4VRTudW7mXZ7Pps5hsm5C","redirect_uris":["http://maryann.com/google/credential"]}}

       2. Save the file. Make sure the file type is changed from json to properties.
    2. If you already have a file named frevvo-config.properties in <frevvo-home>\tomcat\conf directory, then copy the information from the json file and add it to your existing frevvo-config.properties file.
       

       1.  Append the prefix client.secrets= to the pasted content from the json file

          Code Block

          client.secrets={"web":{"client_id":"1042723840399-112fedk6nurt8j657rl4etl8441m3evf.apps.googleusercontent.com","project_id":"maryann-domain","auth_uri":"https://accounts.google.com/o/oauth2/auth","token_uri":"https://accounts.google.com/o/oauth2/token","auth_provider_x509_cert_url":"https://www.googleapis.com/oauth2/v1/certs","client_secret":"E1P4VRTudW7mXZ7Pps5hsm5C","redirect_uris":["http://maryann.com/google/credential"]}}

       2. Save the file. Make sure the file type is changed from json to properties
    3. You can also
       
       1. Rename the JSON file as client_secrets.json
       2. Copy it to tomcat/lib folder
       3. Create/edit the frevvo-config.properties in <frevvo-home>\tomcat\conf directory. Add the client.secrets= property to this file without a value e.g. client.secrets=
       
       

...