function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
nagalakshminagalakshmi 

How to import the data of google spreadsheet in to salesforce object

Hi,

 

Any one please help me, for importing the data of google spreadsheet in to salesforce object using salesforce classes. I tried a lot. But i am not getting. any one give me suggestion for solving these. Thanks in advance.

 

Thanks,

Lakshmi

KaranrajKaranraj

Hi,

 

Instead of loading data from online, you can download the google spreadsheet into your local system an then import using Dataloader option in salesforce.

anu123anu123

Hi, 

 

      Thanks for your reply. But i want to import the data from google spreadsheet to salesforce object through coding. Please help me out.

 

 

Thanks,

Lakshmi.

MikeGillMikeGill
The ability to push data and pull data would be useful for sure.

I would start with OAuth and REST API for force.com

Followed by here -http://code.google.com/apis/spreadsheets

What is the actual use case?
md1md1
Haven't tried it yet but the Enabler for Google Spreadsheets (https://appexchange.salesforce.com/listingDetail?listingId=a0N3000000B5f7vEAB) seems to be the tool to do just that.
RockfordealerRockfordealer
Hi,
You can now use this free add-on for Google Sheets, offered by Google: https://gsuite.google.com/marketplace/app/data_connector_for_salesforce/857627895310