How To Setup and Run CloudConnector
In a previous post, I introduced a script that I developed that allows querying and displaying data from a Salesforce org in a Google spreadsheet. I am still awaiting approval for the script to be posted to the Google Apps Scripts Gallery. The galley hosts a bunch of scripts that can be easily imported into a google doc. In the mean time, if you would like to use the script, I have put together the following how to use the script in any Google spreadsheet. If you would like to contribute to the script please feel free to fork away. The script can be found on github: https://github.com/gidzone/cloudconnector.
- Create a new Google Apps Spreadsheet.
- In the new spreadsheet goto the Tools -> Script Editor to open the script editor.
- Copy the script from here to your clipboard.
- Paste the script into the Script Editor window.
- Save the script by selecting File -> Save.
- Enter CloudConnector as a name for the script.
- The script needs to be authorized before it can be run. Select and run the onOpen function from the functions dropdown. This will activate the authorization dialog.
- Click the Authorize button to authorize the script.
- Rerun the onOpen function to add the CloudConnector menu to the Google spreadsheet.
- Close the Script Editor window.
- Click the Settings menu item in CloudConnector menu to activate the Settings window.
- Enter your Username, Password and Security Token for the Salesforce org.
- Click Login in the CloudConnector menu to login to your Salesforce org.
- Click Query in the CloudConnector menu to activate the SOQL Query dialog
- Enter your SOQL query and click Query to run the query.
- The results should display in your spreadsheet.
- If there are more records in the resultset, click the Query More option in the CloudConnector menu will return those results.
The instructions should clarify which Salesforce Editions the code can interact with.
Most people may not be familiar with API calls are valid for Salesforce Enterprise + Unlimited.
For clarification on editions, see http://www.sfdcstatic.com/assets/pdf/datasheets/DS_SalesCloud_EdCompare.pdf
BTW:
The code does work for the developer edition of Salesforce aka Force.com;
users can register for a free developer account at this link to test the
CloudConnector code (it works!).
http://www.developerforce.com/events/regular/registration.php
@Otto Thanks for the posts. What errors were you running into when trying to connect via the developer edition?
Leave a Reply