--- title: How To Connect Google BigQuery to Salesforce description: A step-by-step guide for sending any company data from BigQuery to Salesforce—or any other CRM—using Dataddo vs. manually. image: https://blog.dataddo.com/hubfs/BQ-_Salesforce%20preview.png --- [![Dataddo Blog](https://blog.dataddo.com/hs-fs/hubfs/blog-logo.png?width=180&name=blog-logo.png)](https://blog.dataddo.com) ** [Get Dataddo Free](https://www.dataddo.com/signup?hsLang=en) [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9) # How To Connect Google BigQuery to Salesforce By Haziqa Sajid | 9 min read ![](https://blog.dataddo.com/hubfs/BQ-_Salesforce%20preview.png) - ** - ** - ** CRM platforms like Salesforce hold a wealth of customer information. But what if you could unlock even deeper insights by making any company data from Google BigQuery immediately viewable in Salesforce? This would, for example, give Salesforce users direct access to custom-computed metrics, like lifetime value (LTV) or conversion probability, in the middle of a call with a prospect. Fortunately, this is possible in more than one way. This article explores the step-by-step process of sending data from Google BigQuery to Salesforce. It will cover the method for manual connection methods as well as the method for automated connection via Dataddo—a data integration tool. Click to skip down: - [Connecting Google BigQuery to Salesforce Manually ](https://blog.dataddo.com/how-to-connect-google-bigquery-to-salesforce#ManualConnection) - [Connecting Google BigQuery to Salesforce via Dataddo](https://blog.dataddo.com/how-to-connect-google-bigquery-to-salesforce#DataddoConnection) - [Why Use Dataddo to Connect BigQuery to Salesforce](https://blog.dataddo.com/how-to-connect-google-bigquery-to-salesforce#WhyDataddo) - [More Tips, Tricks, and Resources for Google BigQuery](https://blog.dataddo.com/how-to-connect-google-bigquery-to-salesforce#TipsTricks)   ## **Connecting Google BigQuery to Salesforce Manually ** Connecting Google BigQuery to Salesforce manually involves exporting data from BigQuery and importing it into Salesforce. It is important to note that this method requires some technical know-how, and—since it is manual—it's only really suitable for one-time integrations, and not scenarios where data needs to be regularly updated in Salesforce. Here are the steps involved: 1. If you don't already have a BigQuery account, Sign up for a BigQuery trial account on the Google Cloud Platform Console. 2. Create a project or select a dataset that you want to export. ![BigQuery select dataset](https://blog.dataddo.com/hs-fs/hubfs/BigQ%231.png?width=1600&height=763&name=BigQ%231.png) 3. Click on the **Export** option on the right and then choose **Explore with Sheets** to get your data into Google Sheets. ![Export from BigQuery](https://blog.dataddo.com/hs-fs/hubfs/BigQ%232.png?width=1600&height=763&name=BigQ%232.png) 4. Once you get your data into **Google Sheets**, you can download it in your preferred format, such as **CSV**, which is supported by Salesforce. ![Download CSV](https://blog.dataddo.com/hs-fs/hubfs/BigQ%233.png?width=1600&height=763&name=BigQ%233.png) 5. In Salesforce, **Log In** with your account or** Start a free trial**. 6. From the sidebar on the homepage, select an object based on the type of your dataset. For this guide, let’s select the **Contacts** tab in the top right corner. ![Salesforce select contacts](https://blog.dataddo.com/hs-fs/hubfs/BigQ%234%20(1).png?width=1600&height=666&name=BigQ%234%20(1).png) 7. Click on the **Import** button to import the CSV file exported from BigQuery.  ![Salesforce click import](https://blog.dataddo.com/hs-fs/hubfs/SF%232.png?width=1600&height=650&name=SF%232.png) 8. Now, choose the CSV dataset you downloaded from BigQuery. ![Salesforce choose CSV](https://blog.dataddo.com/hs-fs/hubfs/SF%233%20(1).png?width=1600&height=686&name=SF%233%20(1).png) 9. Now, match the columns from your file to the Salesforce fields and click **Start Import**. ![Salesforce map fields](https://blog.dataddo.com/hs-fs/hubfs/SF%234.png?width=1600&height=696&name=SF%234.png) 10. After that, your import process will start. ![Salesforce importing contacts](https://blog.dataddo.com/hs-fs/hubfs/SF%235.png?width=1442&height=629&name=SF%235.png) 11. After a few minutes, your data will be imported to Salesforce. ![Salesforce contacts imported](https://blog.dataddo.com/hs-fs/hubfs/SF%236.png?width=1600&height=674&name=SF%236.png) Voila! You've completed a one-off import of BigQuery data to Salesforce. To learn how to automate regular imports, read on.   ## **Connecting Google BigQuery to Salesforce using Dataddo** Dataddo offers a simple alternative for automatic data transfer—up to every 5 minutes—from Google BigQuery to Salesforce. This way, your BigQuery data will always be up to date in Salesforce. Dataddo eliminates the need for complex coding or manual data manipulation. Its intuitive interface empowers anyone, regardless of technical expertise, to connect BigQuery and Salesforce in minutes. Here's a step-by-step guide for how to do it: 1. Head over to Dataddo and [**Sign in**](https://app.dataddo.com/sign-in?_gl=1*19vy67a*_ga*MTUxMzU3MjY3Ni4xNzEzMjYzODg0*_ga_NQ4TN4KP4V*MTcxNjIyODQxMS4xNS4xLjE3MTYyMjk1ODAuNTguMC4w*_fplc*SDN5SGlSWnQwZktLNWZLS01XRURhckVuNWZsSGwwV0JuT3BLQ0RTeXdZeXNOdzNzQzhXMTYxUkw5b3NaOURwb1VVUENZZlZIUjdEM29uNUJOcFBuNmlPU0UzUjR4MUowZ3lsYjhVUkVQbzhVNjVEY0V3R2hJJTJGaGo0cXVoTmclM0QlM0Q.) to your account. If you don't have an account, you can [sign up](https://www.dataddo.com/signup?hsLang=en&_gl=1%2a19vy67a%2a_ga%2aMTUxMzU3MjY3Ni4xNzEzMjYzODg0%2a_ga_NQ4TN4KP4V%2aMTcxNjIyODQxMS4xNS4xLjE3MTYyMjk1ODAuNTguMC4w%2a_fplc%2aSDN5SGlSWnQwZktLNWZLS01XRURhckVuNWZsSGwwV0JuT3BLQ0RTeXdZeXNOdzNzQzhXMTYxUkw5b3NaOURwb1VVUENZZlZIUjdEM29uNUJOcFBuNmlPU0UzUjR4MUowZ3lsYjhVUkVQbzhVNjVEY0V3R2hJJTJGaGo0cXVoTmclM0QlM0Q.) for free. 2. Choose the option **Create Flow** in the top left to create a new integration. ![Start creating a flow](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-1.png?width=1502&height=763&name=Dataddo-1.png) 3. Once you're in, click the intuitive **Connect Your Data** button. ![Click connect data](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-2.png?width=1502&height=712&name=Dataddo-2.png) 4. In the source selection window, choose **BigQuery** as the platform to extract data. Once you've configured a source, it will be available in your sources catalog for future flows you create in Dataddo. ![Choose BigQuery source connector](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-3.png?width=1387&height=712&name=Dataddo-3.png) 5. Provide your BigQuery credentials and specify the objects (e.g., Accounts, Leads) for authentication. **Note:** If you need assistance configuring Google BigQuery, please refer to our [comprehensive documentation](https://docs.dataddo.com/docs/google-bigquery-source?_gl=1*xzty3n*_ga*MzE2NTM5MDc2LjE3MTIyMjM1MDA.*_ga_NQ4TN4KP4V*MTcxNjE4Njc3OC4xMS4xLjE3MTYxODY4MDMuNTguMC4w) for detailed guidance.  6. Once done, click **Next** to proceed.* * ![Configure BigQuery](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-4.png?width=1475&height=712&name=Dataddo-4.png) 7. You must also select the frequency of your data export and then click **Save** to save your source configuration. ![Set sync frequency](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-5.png?width=1475&height=694&name=Dataddo-5.png) 8. Now click on **Connect Your Data Destination**.  ![Connect your data destination](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-6.png?width=1475&height=688&name=Dataddo-6.png) 9. Select **Salesforce** as the destination for your data. 10. Then, configure the connection to your salesforce project and dataset where the extracted data will be stored. Click **Save**. ![Authorize Salesforce](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-8.png?width=1475&height=688&name=Dataddo-8.png) 11. Configure how your data will be transferred. Select the write mode you want, then map your data. ![Choose write mode and map data](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-9.png?width=1443&height=688&name=Dataddo-9.png) 12. Once satisfied with the configuration and data preview, name your flow and click **Create Flow** to initiate the data transfer process. ![Create Flow in Dataddo](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-10.png?width=1457&height=688&name=Dataddo-10.png) 13. Your data flow is now fully configured and will automatically synchronize data from Google BigQuery to Salesforce at the specified intervals, ensuring your data is consistently up-to-date and ready for analysis. ![Dataddo flow screen](https://blog.dataddo.com/hs-fs/hubfs/Dataddo-11.png?width=1457&height=503&name=Dataddo-11.png) Dataddo enables this process to be repeated with any operational apps—other CRMs like [Hubspot](https://blog.dataddo.com/how-to-connect-google-bigquery-to-hubspot?hsLang=en), marketing platforms like [Google Ads](https://blog.dataddo.com/easy-automated-accurate-offline-conversion-imports-to-google-ads?hsLang=en), finance software like [Exact Online](https://dataddo.com/app/exact_online), and more.   ## **Why Use Dataddo to Connect BigQuery to Salesforce** Connecting Google BigQuery to Salesforce can be complex, but using Dataddo simplifies the process with its advanced features and user-friendly interface. Here are some compelling reasons to choose Dataddo for your integration needs: ### **Leading-Edge Integration Technology for Reverse ETL Use Case** Dataddo excels at reverse ETL, the process of pushing data from your analytical warehouse (e.g., BigQuery) back to your operational systems (e.g., Salesforce). Its user-friendly interface eliminates the need for complex coding, allowing you to set up data flows with drag-and-drop ease. This translates to significant time savings and empowers even non-technical users to [harness the power of reverse ETL](https://blog.dataddo.com/3-ways-reverse-etl-can-turn-your-crm-into-a-data-powerhouse?hsLang=en). ### **Highly Customizable** Dataddo doesn't force a one-size-fits-all approach. Our platform offers a high degree of customization, allowing you to tailor data flows to your needs. You can define transformations, filter data based on specific criteria, and extract any custom dataset using our [universal JSON connector](https://dataddo.com/connector/json). ### **Transparent Flow Management and Monitoring** Dataddo provides a centralized hub for managing and [monitoring your data flows](https://docs.dataddo.com/docs/manage-and-monitor-data-flows?_gl=1*ma0r3x*_ga*MzE2NTM5MDc2LjE3MTIyMjM1MDA.*_ga_NQ4TN4KP4V*MTcxNjIwOTI3OS4xMy4wLjE3MTYyMDkyODAuNTkuMC4w). You can easily track the progress of each flow, view transfer history, and troubleshoot any potential issues. This level of observability ensures your data pipelines operate smoothly and deliver the data you need. ### **Scheduled Automation** Dataddo empowers you to schedule automated data flows, ensuring your Salesforce data remains consistently up-to-date with the latest information from BigQuery. This eliminates the risk of human error and keeps your CRM system constantly refreshed with the most recent insights. ### **Impenetrably Secure** Dataddo prioritizes the safety of your information by employing [robust security measures](https://docs.dataddo.com/v1/docs/en/security). We leverage industry-standard encryption protocols and access controls to protect your data throughout the integration process.   |   **Connect All Your Data with Dataddo** Just a few quick steps to get data from any database into Salesforce. [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a) | | --- |   ## More Tips, Tricks, and Resources for BigQuery Continue reading the Dataddo blog for more BigQuery tips, tricks, and resources! 1. [[WEBINAR] Enabling Any-to-Any Data Integration to and from Google BigQuery](https://blog.dataddo.com/webinar-enabling-any-to-any-data-integration-to-and-from-google-bigquery?hsLang=en) 2. [[CASE STUDY] How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo](https://blog.dataddo.com/how-livesport-activates-data-saves-engineering-resources-with-bigquery-and-dataddo?hsLang=en) 3. [[CASE STUDY] How FoodChéri Syncs MongoDB to BigQuery for Quicker Insights, with Less Engineering](https://blog.dataddo.com/how-foodcheri-syncs-mongodb-to-bigquery-for-quicker-insights-with-less-engineering?hsLang=en) 4. [Tips to Prevent Data Duplication in Google Big Query](https://blog.dataddo.com/tips-to-prevent-data-duplicates-in-google-bigquery?hsLang=en) 5. [[WEBINAR] Data Integration with Google BigQuery](https://blog.dataddo.com/data-integration-with-google-bigquery?hsLang=en) 6. [Get Started with Google BigQuery](https://blog.dataddo.com/get-started-with-google-bigquery?hsLang=en) 7. [Google Analytics 4 to BigQuery: Fast, Secure, Scalable Connection](https://blog.dataddo.com/google-analytics-4-to-bigquery-fast-secure-scalable-connection?hsLang=en) 8. [How to Connect Google BigQuery to HubSpot](https://blog.dataddo.com/how-to-connect-google-bigquery-to-hubspot?hsLang=en) 9. [JSON to Google BigQuery: Data Pipeline in Less than 2 Minutes](https://blog.dataddo.com/json-to-google-bigquery-data-pipeline-in-less-than-2-minutes?hsLang=en) Category: [Product](https://blog.dataddo.com/tag/product), [Tools](https://blog.dataddo.com/tag/tools), [Reverse ETL](https://blog.dataddo.com/tag/reverse-etl), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Related Articles** ## [Databox now supported for easy data visualization](https://blog.dataddo.com/databox-new-visualization-destination?hsLang=en) *(9 min read )* Topics: [Product](https://blog.dataddo.com/tag/product), [Tools](https://blog.dataddo.com/tag/tools), [Reverse ETL](https://blog.dataddo.com/tag/reverse-etl), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [Dataddo Now Connects to Microsoft Fabric](https://blog.dataddo.com/dataddo-now-connects-to-microsoft-fabric?hsLang=en) *(9 min read )* Topics: [Product](https://blog.dataddo.com/tag/product), [Tools](https://blog.dataddo.com/tag/tools), [Reverse ETL](https://blog.dataddo.com/tag/reverse-etl), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [Never Lose a Byte: When and Why to Use Full Data Re-Sync](https://blog.dataddo.com/never-lose-a-byte-when-and-why-to-use-full-data-re-sync?hsLang=en) *(9 min read )* Topics: [Product](https://blog.dataddo.com/tag/product), [Tools](https://blog.dataddo.com/tag/tools), [Reverse ETL](https://blog.dataddo.com/tag/reverse-etl), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Subscribe to The Chronicles of Marketing Newsletter ## Comments ## Subscribe to Our Blog Stay up to date with the latest marketing, sales, and service tips and news. ![subscribe](https://blog.dataddo.com/hubfs/Illustrations/subscribe.svg) - [****](https://www.linkedin.com/company/dataddo) - © Dataddo, Inc. All Rights Reserved ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Haziqa Sajid", "url" : "https://blog.dataddo.com/author/haziqa-sajid" }, "dateModified" : "2024-05-23T14:03:40.446Z", "datePublished" : "2024-05-21T11:28:13.000Z", "headline" : "How To Connect Google BigQuery to Salesforce", "image" : [ "https://blog.dataddo.com/hubfs/BQ-_Salesforce%20preview.png" ], "mainEntityOfPage" : { "@id" : "https://blog.dataddo.com/how-to-connect-google-bigquery-to-salesforce", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dataddo.com/hubfs/Dark%20logo@3x-1.png" }, "name" : "Dataddo, Inc." } } ```