...
Install the Plugin into Google Sheets https://chrome.google.com/webstore/detail/data-connector-for-salesf/jijmhhpjhgeafilgjkdeocjepoacekof
Bottom line. If it was the only tool at your disposal, you could make it work, but be very careful using it. But I would much prefer to pay the US$149 or US$299 per year for XL-Connector or the Google Apps version G-Connector (US$300 per year), and remember XL-Connect is free to retrieve data from Salesforce too.
Login
It's annoying as it hijacks your last used MyDomain URL and you can't change it. Just give us an option to change whatever org I want to log into! So log into your org first!
...
When I clicked Get Data it completely removed data in my sheet. BEWARE of this button! The button for Reports warns you, this button doesn't
Nice, but slow to set up.
Update
Why can't it show the name of the column rather than just the column numbers?
Mapping is nice but a bit cumbersome
Seems a bit final!
After running it doesn't say it's finished. It just goes back to the mapping screen.
Hmm, Upsert doesn't work if you are using Record IDs
So changed it all to Update - you have to do the whole setup again.
Don't include the ID field in the mapping.
And my update failed because of a duplicate - this is why you only turn on REPORT for Duplicates, not ALERT.
Grrrr! If you set it all up based on Row 2, then try to update Row 50, it doesn't work, it's mapped to row 2 only! So you have to go back through the WHOLE mapping exercise again. This is NOT cool this will lead to errors!
Beware!
Reports export blanks as - so when you go to update these records again it updates them as - literally!
Delete
You have to specify the object to delete from! Salesforce knows this!