[ Part - 4 ] Google Sheet Automation for Salesforce Data Pull-Push Using G-connector

Google Sheet Automation Process for Salesforce Data Pull/Push Using G-connector

Hi All,

Welcome Back — to another blog related to the G-Connector for Salesforce.

A recap for newbies 4e5cf7d4ccb9c59b6620a9c71944d51e

In my first blog of “G-Connector for Salesforce“, I shared with you all the required steps to install and configure G-connector for Salesforce.

In my second blog of “Get Salesforce record data into your Google Sheet through G-Connector, I shared with you all how to use G-Connector for getting salesforce record just simple as we can do it in our salesforce query editor to see the records.

In my third blog of “Pushing Google Sheet data into the Salesforce database through G-Connector“, I shared with you all how to push the Google Sheet rows data to Salesforce sObject records on the basis of Sheet columns with the correct/matching salesforce fields.

Now in this new blog, I am going to give you some interesting info which is very easy and a way more relaxing for doing the manual pushing and pulling of data.

Follow the below steps to automate your pushing/pulling of Salesforce data from/to Google Sheet through G-Connector:

  1.  Open your Google sheet and verify the connection, is it connected with either of salesforce sandbox or production org. NOTE: If not connected please connect your sheet with desired salesforce org.
    g5
  2. Now after making/verifying connection with salesforce, Click on the “Schedule Automatic Data Operations”  option under “G-connector for Salesforce
    01Here you can select the Data Operation Action(Pull, Push, Notification, etc) under the “Scheduler” tab
  3. Also you the “Frequency” option for your data operation which is very great for automatic operation
  4. Make a combination of all the option and build a schedule automatic data operation and click on “Apply” button. An example is showing in below image.
    02
  5. After clicking on apply button, you will see a new tab in your Google Sheet for “Automatic Operations Events Log“, where you can find your result of data operation as shown in below image
    03

Hope this blog helps in knowing how you can schedule your data operations in Google Sheet. For better knowing/understanding build your own Schedule Automatic Data Operation and see the working magic.

Happy Salesforce!

0 Comments

Leave a Reply

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2018 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?