Integrating with Google Drive and Google Spreadsheet

The Viindoo system integrates with Google Drive and Google Spreadsheets to make your management, storage, and sharing of documents more convenient and user-friendly.

Configuration

You navigate to Settings ‣ General Settings, in the Integrations section, check on Google Spreadsheet and Google Drive, then choose Save.

Integrate Google Drive Viindoo

With Google Drive integration, you need to do the following additional steps:

In the Google Drive area, you choose Set up token to connect to a Google account.

Install token connects Google Drive Viindoo

A popup requires the Authorization Code.

Enter the Authorization Code Google Drive Viindoo

Hit Get Authorization Code to redirect to the screen where you choose a Google account for the integration.

Google Account Google Drive Viindoo

Hit Allow to grant the access.

Connect with Google

Operating on the connection, the system will generate an Authorization Code.

Authorization Code Google Viindoo

Copy this code and paste it into the field Authorization Code as shown in the picture below. Hit Confirm to complete the integration.

Use the generated authorization code Google Drive Viindoo

Successful integration with Google Drive.

The integration is completed Google Drive Viindoo

Warning

Only users with Settings right of the system can perform this configuration.

Steps to use the Google Drive integration feature in Viindoo

After the connection is successful, the system provides the link feature between the documents stored on your drive with the models on the system. With this feature, the managers can add the company’s document templates on many models to help employees propitious in search and use.

In the General Settings, hit Google Drive Templates to create a new one.

Create a new template Google Drive Viindoo

Hit Create and fill in the information as follows:

Template creation Google Drive Viindoo
  • Template Name: Name of the template.

  • Active: When checked, this template will be active and ready to use.

  • Model: The model in the system, to which this template links.

  • Filter: The customizable filter of this template.

  • Template URL: The URL of the Google Drive document. Note: you need to create a sample document on Google Drive first to get the URL.

  • Google Drive Name Pattern: Define rules to name Google Drive documents using fixed words and fields.

Note

In Google Drive, you can select the type of the sample document, such as: Google docs, Google sheets, Google form, Google Slides, etc. You must ensure the URL is correct.

Creating a new template example Google Drive Viindoo

Assume you have already installed the Project app. Navigate to Project ‣ Configuration ‣ Projects. Select an existing project. Here, hit the Action button, select the template created in the previous steps.

Access the link to the template Google Drive Viindoo

A new document will be generated, which has the same information as the created Google Drive template. The new document is just created once. With the above steps in the second time, you will be redirected to the created one.

Display the integrated template Google Drive Viindoo

You can do the same with the other models: Contacts, CRM, Sales, Purchase, etc.

Steps to use the Google Spreadsheet integration feature in Viindoo

After integrating Google spreadsheet, the system allows you to export data from many models as a spreadsheet. For instance, in the CRM app, navigate to the Favorites and hit Add to Google Spreadsheet.

Create a new spreadsheet Google Viindoo

A new spreadsheet will be automatically generated in your Google Drive. You need to open this spreadsheet and navigate to the menu Odoo ‣ Settings.

Set up Odoo Settings Spreadsheet Google Drive Viindoo

Click on Continue in the new pop up then follow the Google tutorials to allow Odoo Template access to your Google account.

Continue click on Odoo > Settings and configure:

  • User name: enter your user account’s name that you use in Viindoo system.

Configure Username Google Spreadsheet Viindoo
  • Password: enter the password of the account you use in Viindoo system.

Configure Password Google Spreadsheet Viindoo
  • URL: your Viindoo system’s URL.

Configure URL server Google Spreadsheet Viindoo Get Database Name Configure Database Name Google Spreadsheet Viindoo
  • Username: retype your user name.

Configure Username Google Spreadsheet Viindoo
  • Password: enter your password to access to Viindoo system.

Configure Password Google Spreadsheet Viindoo

After the setup is completed, you coppy the code in the first raw and first colum of sheet, repaste to reload the data system.

Reload

The CRM data in Viindoo system will be export to the data on Google Spreadsheet. Any time you want to get change, creating new, editing or deleting records from CRM app, recoppy and paste the code follow the below tutorial.

data display Google Spreadsheet Viindoo

Tip

You can do the same with the other apps in the Viindoo system such as Contacts, Sales, etc.