posts - 88 , comments - 3 , trackbacks - 0

Import Salesforce Data into Google Spreadsheets

The Salesforce Cloud Driver enables applications to connect to Salesforce data via Web services. In Google Spreadsheets, you can consume Web services in the CSV format by calling the ImportData function. You can follow the three steps below to use the ImportData function to consume Salesforce data in Google Spreadsheets.

  1. If you have not already connected successfully in the cloud driver administration console, see the "Getting Started" chapter in the help documentation for a guide.
  2. Authenticate your query with the authtoken of a user authorized to access the OData endpoint of the cloud driver. Append the authtoken to the URL. OData queries, such filters, order-bys, etc. can be specified in the URL. See the APIs page in the cloud driver administration console for some example queries.
  3. In a new Google sheet, use the =ImportData() formula to request the CSV file from the exposed data source. This example requests the entire Account table. Google will periodically update the results of the formula, ensuring that the sheet contains up-to-date data. You can use a formula like the one below:

    =ImportData("https://your-server/api.rsc/Account?@csv&@authtoken=your-authtoken")
Consuming Web services in Google Spreadsheets. (Salesforce is shown.)

Print | posted on Monday, February 3, 2014 5:44 AM | Filed Under [ salesforce odata google google docs integration cdata ]

Feedback

Gravatar

# re: Import Salesforce Data into Google Spreadsheets

woho! This is absolutely great help for me. Thank you for sharing excellent insight!

Julie
9/21/2016 9:54 PM | cloudchillies
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: