Salesforce Google Drive Integration

decor
decor

Salesforce to Google Drive Integration extends the power of G Drive to your CRM. It enables real-time synchronization and complex business process optimization. It allows users to spend more time building relationships with customers instead of wasting time on manual tasks. It allows team collaboration in the context of the customer by attaching Sheets, Docs and Slides to an opportunity, account or customer contact in Salesforce. Salesforce to G Drive integration is the need of various industries as Salesforce analyzes data and generates reports.

decor
decor

Table of Contents

  • Use cases of Google Drive integration with Salesforce
  • Benefits of Google Drive integration with Salesforce
  • Steps to Integrate Salesforce with Google Drive
  • Related Services Peeklogic Team Provides
  • Frequently asked questions
decor
decor

Use cases of Google Drive integration with Salesforce

Google Drive integration with Salesforce can be used for various purposes by different industries. Let’s talk about some common use-cases of Google Drive integration with Salesforce. This Integration can be used for sharing photographs of events held within an organization. It is a common phrase after an event – “Where are the photos?” It is challenging to store pictures captured by different people in a single place. The credentials of the organization’s Google Drive repository can be shared with everyone. It is where Salesforce comes into existence and can be used to upload the pictures to the organization’s Google Drive without requiring the Google Drive credentials.

Let’s talk about another example. A project is running in your organization and a Google Drive repository is used for storing all the files related to the project. The project manager only has the credentials of the Google Drive repository. The team members want to upload files to this Google Drive repository. There are two ways of doing this – [a] Either they have the credentials to the repository which they don;t have as the folders need to be secured and credentials can’t be shared with everyone OR [b] the members upload the files to their google drive repository and share the links to the folder with the project manager. It will become a time-consuming and irritating task for the project manager to open the links received by each member and upload the files from there to the common G drive repository. This is where Salesforce comes into existence and can be used to upload the data to the organization’s Google Drive without requiring the Google Drive credentials.

Benefits of Google Drive integration with Salesforce

  1. Real-time synchronization: Any changes made to a file can be reflected to both the platforms without any delay. It is a two-way synchronization.
  2. Cost reduction: Salesforce has limited storage, and G Drive provides ample storage. Industries that require large files to associate to the salesforce objects can avoid purchasing the expensive salesforce storage and reduce cost.
  3. High data security: Google Drive integration with Salesforce is highly secured and provides multi-level security to your data.
  4. Efficiency: Files like google docs, sheets, presentations do not require to be downloaded first and then uploaded into salesforce. It saves a lot of time for the user.

 

Steps to Integrate Salesforce with Google Drive:

01. Create App in Google Console
a. Go to the URL  https://console.developers.google.com/project
b. Click on the create project button to create a new project.

decor
decor

c. From the newly created project dashboard enable the Google Drive API

decor
decor

d. Configured the OAuth consent screen

e. Click on the Create Credentials button then select OAuth Client Id then select web application to create a client id and client secret for authorization. Add a URI for the application from where you will be accessing the API in Authorized redirect URIs field.

 

decor
decor

02. Configure Auth. Provider for Salesforce Google Drive Integration
a. In Salesforce go to Setup enter Auth. Providers in the quick find box and click New button.

decor
decor

b.  A form will open and select Open ID Connect as Provider Type.

decor
decor

c.  Enter name, Consumer Key and Consumer Secret. Enter endpoints URL
I.    Authorize Endpoint URL: https://accounts.google.com/o/oauth2/v2/auth
II.    Token Endpoint URL: https://accounts.google.com/o/oauth2/token
d.  Add scopes defined in your google app e.g.
https://www.googleapis.com/auth/drive   as default scopes. Click Save.

e.  Once saved, a callback URL is available in the Salesforce Configuration Section.

f.  Add this callback URL as the Authorized Redirect URls in the Google App.

decor
decor

g.  Test your connection by going to the Test-Only Initialization URL and
OAuth-Only Initialization URL.

03. Create Named Credentials in Salesforce
a.  In Salesforce go to Setup enter Named Credentials in the quick find box and click
New Named Credentials button

decor
decor

b.  A form will open. Fill out the following fields:
I.      Name
II.     URL: https://www.googleapis.com
III.    Identity Type: Named Principal
IV.    Authentication Protocol: OAuth 2.0
V.     Authentication Provider: Auth. Provider configured earlier
VI.    Scope: Enter space separated scope defined in your google app.
e.g. https://www.googleapis.com/auth/drive
VII.    Start Authentication Flow on Save: check the checkbox

c.  Upon saving, your will redirect to the google Authorization.

d.  We need to open an unsafe connection.

e.  Allow the access.

f. Once you are authorized as a user. If you find (The authentication provider didn’t provide a refresh token. If the access token expires, your org won’t be able to access this named credential) on the name credential page, that means the refresh token logic is missing.

decor
decor

g. Update the Authorization endpoint URL in the auth provider configured earlier to continue
getting the refresh token. Add the query parameter to the base URL. The updated URL will be
https://accounts.google.com/o/oauth2/auth?access_type=offline&approval_prompt=force.
The approval_prompt parameter is required to get the refresh token after the first one
continuously .

h. Test the connection once again and the user will be authenticated.

decor
decor

04. Create a Remote Site Setting in Salesforce
a. In Salesforce go to Setup enter Remote Site Settings in the quick find box and click
New Remote Site button.

decor
decor

b. Fill Out the form.
Enter https://www.googleapis.com as the remote site URL as the remote site URL.

decor
1432591614_api-code-window
5. Make Callouts!
decor
decor

Frequently Asked Questions

1. How can I integrate Google Drive with Salesforce and what are the benefits?

Google Drive can be integrated with Salesforce using various methods, such as third-party apps or custom development. The integration allows users to access and manage Google Drive files directly within Salesforce, improving collaboration, centralizing document storage, and enhancing productivity by eliminating the need to switch between platforms.

2. Can I sync files between Google Drive and Salesforce, and how does it work?

Answer: Yes, file sync between Google Drive and Salesforce is possible through integration solutions like Salesforce Files Connect or third-party apps. These solutions establish a bi-directional sync, enabling users to view, edit, and collaborate on Google Drive files directly within Salesforce and vice versa, ensuring data consistency and eliminating the need for manual file transfers.

3. Is data security maintained when integrating Google Drive with Salesforce?

Answer: Yes, data security is a priority in Google Drive integration with Salesforce. Both platforms employ robust security measures, including data encryption, access controls, and permissions management. Integration solutions typically provide additional security features such as authentication protocols and audit trails, ensuring that data remains protected throughout the integration process.

decor
decor
Need Help Integrating Salesforce with Google Drive?

    Send Message
    Follow Us


    Austin, TX 78759, USA