function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
nagalakshminagalakshmi 

How to export the data from sales force object in to google spread sheet

Hi, 

 

Any one help me, how to export the data from salesforce object in to google spread sheet. Thanks in advance.

 

 

Thanks,

Lakshmi.

Devendra NataniDevendra Natani

are you planning to use apex class to upload data into google spread sheet from salesforcec object? Can you please provide some more details?

 

Thanks,

Devendra Natani

Blog
nagalakshminagalakshmi

Hi,

 

 Yes through apex class, want to insert the values in to google spread sheet from salesforce object. And again want to import the data from google spread sheet to salesforce object. Please help me out.

 

 

Thanks,

Lakshmi.
Devendra NataniDevendra Natani

Can you please send me your email Id. I will give you the code.

 

Thanks,

Devendra
nagalakshminagalakshmi

 Hi

 

ok... My mail id is nagalakshmi_b@dskvap.com. can you send me the code.

 

 

Thanks,

Lakshmi
Devendra NataniDevendra Natani

http://code.google.com/p/apex-google-data/source/browse/trunk/google_data_toolkit/src/classes/GoogleData.cls?spec=svn37&r=37

http://code.google.com/p/apex-google-data/source/browse/trunk/google_data_toolkit/src/classes/GoogleService.cls?spec=svn37&r=37

http://code.google.com/p/apex-google-data/source/browse/trunk/google_data_toolkit/src/classes/DocumentService.cls?spec=svn37&r=37

 

Please go through these url's and create the classes it into salesforce account.



Then use the below code to upload the content into google spreadsheet.

 

DocumentService obj = new DocumentService();

if(obj.useClientLogin('username','password'))

{

    //example uploadDocument('foo,bar,gack','upload sample.csv','text/csv');

    GoogleData gd = obj.uploadDocument (body, title, contentType) 
}

 

Please let me know if there is any issue.

 

Thanks,
Devendra Natani

Blog 
eeshaeesha

Hi devendra,

 

           Actually am also seeking answer for same question. I saw the links which you have posted. But i did not understand how to use this classes for exporting or importing data from google spreadsheet. Can you please tell me how to use this classes if you don't mind. 

 

 

Thanks,

Eesha.
nagalakshminagalakshmi

Hi,

 

 I am follow the code which u have sent. But got the error as

 

The page you have requested cannot be displayed. Another site was requesting access to your Google Account, but sent a malformed request. Please contact the site that you were trying to use when you received this message to inform them of the error. A detailed error message follows:

The site "http://force.com" has not been registered.

 

how can i solve these. Please help me out.

 

Thanks,

Lakshmi.
JFraileJFraile

Hi.

 

I`m running into the same problem, did anyone find a solution.

 

Regards