owned this note
owned this note
Published
Linked with GitHub
Title: 2 ways for Salesforce Google Drive Integration [2022]
[Toc]
Description: This guide shows you how to connect Salesforce to Google Drive in a comprehensive and detailed manner. It is easy to follow and suitable for beginners as well.
# Salesforce Google Drive Integration: The Complete Guide
The world is spinning around data. Data has to be collected, processed, stored, and protected. Modern CRM platforms such as Salesforce, Dynamics, Zoho CRM, and others offer the best opportunities for customer-related data collecting, processing, and protection.
However, CRM users bump into storage capacity limits when it comes to storage capabilities. Users are forced to pay extra fees for additional space or manually keep track of data volumes by deleting or transporting data elsewhere. And here, the storage services come to the rescue.
The problem is that the storage services are used separately from the CRM tool. Thus, the users have to think about transferring data from the CRM to the storage service. Fortunately, the Salesforce CRM platform supports direct integration with such file storage as Google Drive.
This article describes how to avoid manual data transfer or extra payments. It tells how to connect Salesforce to Google Drive using different means, including the solutions offered by Skyvia.
## What is Salesforce?
[Salesforce](https://skyvia.com/connectors/salesforce) is a global platform providing customer relationship management services for Sales, Marketing, Customer Support, and other business functions.
Together with CRM services, Salesforce offers a boost of additional opportunities for its users worldwide. You can create apps, integrate data from other systems, visualize data, and even study with Salesforce.
## What is Google Drive?
[Google Drive](https://skyvia.com/connectors/google-drive) is a simple, user-friendly service allowing users from all over the world safely store their files on Google cloud servers. It allows storing files of any possible type and size. You can set up automatic file synchronization with any device and integrate your files with other available Google tools.
## Advantages of Google Drive Salesforce Integration
When working in Salesforce, users may create and process files, such as photos from events, product pictures, screenshots, and ticket attachments. Salesforce supports all audio, video, image, and archive formats. All these files have to be stored somewhere and accessed directly from Salesforce. Direct Salesforce Google Drive integration lets Salesforce users store their files, synchronize them across devices and share these files with other users or teams.
With Salesforce and Google Drive connected, users don't have to pay for Salesforce storage extension additionally and bother searching for a way of clearing the space in Salesforce native storage.
## Salesforce to Google Drive Files Connector
Salesforce enables integration with external data storage, such as Google Drive with its native tool Salesforce Files Connect. This feature allows accessing Google Drive from Salesforce directly.
To Connect Google Drive and Salesforce, you have to perform the following steps:
1. Enable Salesforce Files Connect for your organization:
* Sign In with Salesforce.
* On the Setup page, enter _Files Connect_ in the Quick Find box, and then select **Files Connect**. Click **Edit** and select the **Enable Files Connect** checkbox. There you can also select file-sharing options applicable to your scenario. More details are available in Salesforce [documentation](https://help.salesforce.com/s/articleView?id=sf.admin_files_connect_enable.htm&type=5).
2. [Let users and administrators access Files Connect data sources.](https://help.salesforce.com/s/articleView?id=sf.admin_files_connect_perm.htm&type=5).
After enabling Salesforce Files Connect, you have to grant your users and administrators permission to access the external data sources from Salesforce.
3. [Create an Authentication Provider for Google Drive.](https://help.salesforce.com/s/articleView?id=sf.admin_files_connect_google_auth.htm&type=5).
* Go to https://console.cloud.google.com and sign in using your Google App for the Work admin account.
* Click **Create Project**, enter the project name and location, and click **Create**.
* Navigate to **APIs & Services** in the project dashboard.
* Then go to the Library tab and search for Google Drive API. Select **Google Drive API** and click **Enable API**.
* Click **Credentials** on the left.
* Enter a valid email address and application name in the OAuth Consent Screen tab. Click **Save**.
* Add credentials on the Credentials tab, select **OAuth client ID**, select Web application, and click **Create**.
You need the client ID and client secret values to create an authentication provider in Salesforce. Thus, we recommend saving them to a text file.
4. Create an Authentication Provider in Salesforce.
* In Salesforce, search for Auth. Providers in the Quick Find box, select it and click **New**.
* Select **OpenID Connect for Provider Type**, and set the following options:
Name, URL Suffix — suffix at the end of the URL path, Consumer Key, and client ID copied from the Google project.
* Authorize Endpoint URL, Token Endpoint URL, Default Scopes, Click **Save**. Then, at the bottom of the Auth. Provider detail page, copy the Callback URL entry to a text file (Use this URL when editing the Google project).
5. Edit the Project in Google Developer Console.
In the API Manager, click **Credentials** and select the previously created web app.
In the Authorized Redirect URIs section, add the Callback URL copied when creating the authentication provider in Salesforce and click **Save**.
6. [Define an External Data Source for Google Drive](https://help.salesforce.com/s/articleView?id=sf.admin_files_connect_google_xds.htm&type=5).
In the Setup menu, enter _External Data Sources_ in the Quick Find box, then select **External Data Sources**. Click **New External Data Source**. Then set the following options Label, Name, Type, Identity Type, Authentication Protocol, Authentication Provider, Scope, Start Authentication Flow on Save.
## Universal Cloud Integration Salesforce and Google Drive
Build your [Salesforce Google Drive integration](https://skyvia.com/data-integration/integrate-salesforce-google-drive) fast and easy with [Skyvia](https://skyvia.com/).
Skyvia is a cloud platform offering various services to perform data-related tasks. Load data from Google Drive files to Salesforce or other supported connectors with Skyvia Import. Extract Salesforce data into CSV files and place these files in Google Drive storage using Skyvia Export.
This method differs from the native one. Salesforce Files Connect enables accessing files directly from the Salesforce interface. Skyvia instead integrates the Salesforce data with the file data. There are no data volume or file size limits for Skyvia. The integration is possible in both directions.
You don't need technical skills to build Salesforce Google Drive integration with Skyvia. This method doesn't require coding.
### Prerequisites
To connect Salesforce and Google Drive using Skyvia, you have to be registered in Skyvia, which can be done for free.
Additionally, Skyvia offers a two weeks trial for any of its paid plans.
You also have to create the connection to both Google Drive and Salesforce in Skyvia:
Sign In with Skyvia, click **+NEW** —> **Connection** — select the connector.
For [Salesforce connection](https://skyvia.com/connectors/salesforce), you have to select the Environment and the Authentication type and specify other connection parameters and settings.
When creating the [connection to Google Drive](https://skyvia.com/connectors/google-drive), you need only the access token, which is automatically generated when you sign in with Google.
### Export from Salesforce to Google Drive
Let's imagine you need to perform daily backups of your Salesforce contacts to an external file on Google Drive.
When you need to export Salesforce data to Google Drive, you have to use [Skyvia Export](https://docs.skyvia.com/data-integration/export/). Skyvia reads Salesforce data, downloads this data to a CSV file, and places this file in the needed folder on Google Drive.
To set up the Export, you have to do the following:
1. Create a new Export package: Click **+NEW** —> Select **Export** in the Data Integration block and specify the package name instead of the _Untitled_ value.
2. Select Salesforce connection as a Source.
3. Select the Target type **CSV to storage_ service** and select your Google Drive connection as a Target. Optionally set the target folder.
4. Click **More options** to set the additional CSV options for the target file, if needed.
5. Then proceed to set up the package task. Click **Add new** on the right to open the package task editor.

#### Source Definition
Skyvia offers two Task editor modes, Simple and Advanced. We will use Simple Mode in our case.
1. Select the Salesforce object to be exported from the dropdown list. In our case, you have to select the Contacts table.
By default, all the fields of the table are selected for Export. You can clear the fields checkboxes to exclude some fields from the Export.
2. Add filters if needed and specify the file name optionally.
3. Proceed to the Output Columns tab.

#### Output Columns
1. Drag and drop the fields to change their order in the result CSV file.
2. Type the custom column names if you want to have other field names in the result file.
3. Click **Save** and proceed to set up the automatic package execution.

More details on how to create export tasks are available [here](https://docs.skyvia.com/data-integration/export/how-to-create-export-task.html)
#### Package Execution Scheduling
Skyvia allows setting the [automatic execution](https://docs.skyvia.com/data-integration/scheduling-packages-for-automatic-execution.html) for integration packages:
1. After saving the task, click **Schedule** on the top left corner of the package editor page.
By default, the State, Recurrence, and Run every schedule parameters are already configured to run every day. We will keep them as is.
2. Then set the execution start time in the Time parameter and save the Schedule.

3. Drag and drop the fields to change their order in the result CSV file.
4. Type the custom column names if you want to have other field names in the result file.
5. Click **Save** and proceed to set up the automatic package execution.
6. Click **Create** on the top right of the package editor and proceed to package execution.
### Package Execution and Results
After that, the package will run at the specified time automatically.
You can see the result of the last five package runs on the Monitor tab. The Log tab shows the package results for different periods of time.
Click the certain run to check the number of successfully processed records or the failed ones.
Skyvia allows exporting several files at the same time in one package. Just add more tasks to the package and enjoy.
### Import from Google Drive to Salesforce
Skyvia supports bi-directional Salesforce Google Drive integration.
Let's imagine you need to import Salesforce Contacts data from the file on Google Drive, avoiding duplication of data and enriching Salesforce records with new data from the file.
To upload data in the opposite way from Google Drive to Salesforce in Skyvia, you have to use Skyvia [Import](https://docs.skyvia.com/data-integration/import/).
Skyvia will open the Google Drive file, extract the data and load this data to the needed table in Salesforce.
To set up the Import package, do the following:
1. Create a new Import package. Click **+NEW** —> Select **Import** in the Data Integration block.
2. Select **CSV from storage service** Source type.
3. Select your Google Drive as a Source and Salesforce connection as a target.
4. Click **Add new** to create a new package task.
#### Source Definition
Select the source file in the Source Definition tab. Skyvia will read the file and display the list of the file fields.
Adjust the [CSV options](https://docs.skyvia.com/working-with-csv.html) if necessary. In our case, we will leave the default settings state as is and proceed to other package task settings.

#### Target Definition
Select the _Contacts_ table as a target and choose the Upsert operation.
The Upsert operation inserts the new records and updates the existing records.
Select the **Use Primary Key** mark and proceed to the mapping.

#### Mapping Definition
The source file and target table structure may be different sometimes. Thus to perform smooth Import, you have to map source and target fields.
Skyvia maps the fields with equal names automatically.
The Upsert operation requires the _Id_ field to be mapped.
Click on the _Id_ field and select the Target Lookup mapping from the dropdown list.
Select the _Contact_ table as the Lookup object and the _Id_ field as the _Result column_.
Select the _Email_ field as both **Lookup Key columns**.
Click the Options near the mapping type and select the **Set null when no match is found**.
The Lookup feature will compare the _Email_ field value in the Source file with the _Email_ field value in the Target. If the match is found, the record will be updated. If the match is not found, Skyvia will insert the new record.
Map other fields using the available [mapping types](https://docs.skyvia.com/data-integration/common-package-features/mapping/).

### Package Execution and Results
Save the task and the package. Set the Schedule, if needed, or run the package manually. Check the package results as described above.
## Summary
CRM systems and data storage services solve different business tasks. But when such services are integrated, businesses come to a new level of growth.
Salesforce and Google Drive integration open new opportunities for companies in terms of data management. We have described two methods that help connect Salesforce and Google Drive to save Salesforce storage volumes and money spent on these storage extensions.
The Salesforce Files Connect integration method is safe and reliable. However, it may have some limitations. It enables accessing, sharing, and searching external data in Google Drive, but there is no opportunity to upload files directly from Salesforce to Google Drive.
It is also difficult to connect Salesforce and Google Drive if you are not tech-savvy. You need to be an advanced user to set up the integration smoothly.
Skyvia Data Integration solutions allow exporting data from Salesforce to Google Drive and importing data from external Google Drive files directly to Salesforce with minimum effort and no additional skills or knowledge.
You can set the regular automatic integration in both directions.
With Skyvia, you can connect Salesforce to other supported storage services, databases, or cloud platforms and implement more complicated data integration scenarios.
## More Articles About Salesforce Integrations
See other capabilities of data integration with Skyvia:
[How to connect OneDrive to Salesforce Manually or with Connector](https://skyvia.com/blog/onedrive-salesforce-integration)
[How to connect Hubspot and Salesforce easily](https://skyvia.com/blog/hubspot-salesforce-integration)
[Asana and Salesforce Integration: 2 easiest methods](https://skyvia.com/blog/asana-salesforce-integration)
[https://skyvia.com/blog/snowflake-to-salesforce-integration](Snowflake to Salesforce Integration: Best Code-Free Connectors)
[https://skyvia.com/blog/shopify-salesforce-integration](How to connect Shopify and Salesforce)
[https://skyvia.com/blog/dropbox-salesforce-integration](Dropbox and Salesforce Integration)
[https://skyvia.com/blog/salesforce-and-quickbooks-integration](Salesforce QuickBooks Integration: 3 Different Ways)
[https://skyvia.com/blog/jira-salesforce-integration](Simple ways to connect Jira and Salesforce)