The typical way I quickly export data from Salesforce is to use Data Loader, or go to Dataloader.io. But, there’s also this alternative that is super useful and free.
Login to your Google Sheets.
Get Add-ons > Search for
Data Connector for Salesforce (by Google).
Install add-on and provide required permissions. Once done, go back to your Google Sheet and select the add-on from
The add-on will ask your permission to connect to your org. Provide credentials and authorize access.
You can now use the add-on to -
- export data from a report in salesforce
- export data with a custom query
- update or delete data in salesforce
Perform a quick test by selecting selecting the option to
Import Salesforce Data. Select the SObject and fields that you need. Hit import data to see data from Salesforce in your Google Sheet.
This method is super convenient if you are in the midst of testing batch jobs and stuck in iterative testing of multiple (specific) data points. You can get the data backed up to Google Sheets, update the data before each iteration and perform your batch tests quickly.