In the Export Salesforce Leads to Google Spreadsheet scenario, you work with the Salesforce SOAP connector, which requires you to get the username, password, and the security token that appear in the email that you get when you register to Salesforce. If you do not have this now, do the following:
- Log in to Salesforce.
- Click My Settings -> Personal -> Reset My Security Token. Then, click the Reset Security Token button.
You get an email with the security token.
Note that the password is a concatenation of the user's password and the security token provided by Salesforce. For example, if your password is "abc" and security token is "xyz", then the password for the connector is "abcxyz".