[ Part - 3 ] Pushing Google Sheet data into the Salesforce database through G-Connector

Pushing Google Sheet data into the Salesforce database through G-Connector

Hi All,

Welcome Back to an another blog related to the G-Connector for Salesforce. In my first blog “G-Connector for Salesforce“, I shared with you all the required steps to install and configure G-connector for Salesforce. And in my second Blog “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 this blog I am going to share the important steps that needed to be followed for pushing the Google Sheet rows data to Salesforce sObject records on the basis of Sheet columns with the correct/matching salesforce fields.

Follow the below steps guided with the screenshot for getting salesforce records:

  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 “Update/Insert/Upsert Selected Row(s)” option under “G-connector for Salesforce
    g8
  3. Now select the sObject and DML option from the picklist under the “Mapping” tab and also map the Google Sheet columns with the Salesforce sObject fields as shown in the below image
    g9
  4. You can have multiple options for Auto Data Push under “Automatic Push Setting“, select as per your need/requirement
    g10
  5. Now hit the “Push Selected Rows” button and see the magic in Salesforce
    g11
  6. You can see in your Google sheet that “ID“, “Success“, “Created“, “Error” and “Timestamp” columns are added with some info regarding your DML operation through Google Sheet to Salesforce org as shown in below image
    g12

Now just login to your Salesforce org and see the newly created/updated record that was done with the help of G-connector. Also, you can open the same record through the new “ID” column by just clicking on the id and it will redirect to the Salesforce record if you are logged in.

Have fun and create your own operations and mapping as per your requirements and see the magic in few seconds.

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 2019 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?