Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Sync Salesforce Data to Google Sheets Instantly

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Salesforce with Google Sheets, first access Pabbly Connect. You can do this by visiting the Pabbly website and navigating to the Connect section. If you’re a new user, sign up for a free account to get started.

Once you are logged in, you will find yourself on the dashboard. Here, you can easily create new workflows that will automate the data transfer between Salesforce and Google Sheets. This setup eliminates the need for manual entry, saving you time and effort.

2. Creating a Workflow in Pabbly Connect

To create a new workflow, click on the ‘Create Workflow’ button on the dashboard. Select the ‘Quick Builder’ option, which allows you to easily set up your integration without manual configuration. You will need to specify that you want to sync Salesforce data to Google Sheets.

Click on the ‘Create Workflow’ button.
Select ‘Quick Builder’ to streamline the process.
Specify the integration as Salesforce to Google Sheets.

After setting this up, approve the workflow and proceed to set the trigger. This trigger will ensure that whenever a new contact is created in Salesforce, it will automatically update Google Sheets with the new information.

3. Setting Up the Trigger in Pabbly Connect

In your workflow, click on the ‘Connect’ option to begin setting up your trigger. You will need to add a new connection to your Salesforce account. Click on the ‘Add New Connection’ section and follow the prompts to allow Pabbly Connect access to your Salesforce account.

Once the connection is established, click on the ‘Save and Send Test Request’ button. This action will capture the last contact created in Salesforce, allowing you to verify that the trigger is functioning correctly. Make sure to adjust the trigger time settings according to your needs.

4. Mapping Salesforce Data to Google Sheets

After the trigger is set up, the next step is to map the Salesforce data to Google Sheets. Click on the ‘Connect’ option again, and choose to add a new connection for Google Sheets. Sign in to your Google account and allow access for Pabbly Connect.

Select the Google Sheets document you want to use.
Map the fields from Salesforce to the corresponding columns in Google Sheets.
Click on ‘Save and Send Test Request’ to verify the mapping.

This mapping ensures that every time a new contact is added in Salesforce, the details will automatically populate in your Google Sheets. This setup provides a systematic record of all your contacts without any manual effort.

5. Finalizing the Integration

To finalize your integration, ensure that all fields are correctly mapped and that you receive a positive response from the test request. This means that the data is successfully flowing from Salesforce to Google Sheets through Pabbly Connect.

Once everything is set, you can start adding new contacts in your Salesforce account. Each new entry will automatically update in Google Sheets, providing a seamless workflow for your team. This automation not only saves time but also enhances collaboration across your business.

Conclusion

Integrating Salesforce with Google Sheets using Pabbly Connect streamlines your workflow by automating contact management. This tutorial provides a clear, step-by-step process to set up the integration effectively.