Learn how to import your contacts from Salesforce CRM into Google Sheets to send a mail merge with Gmail from your spreadsheet.
Awesome Table Connectors allows you to import Salesforce data, including your contacts.
Prerequisites
- In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
- Open the Salesforce connector.
- On the Connect to Salesforce screen, click Sign in with Salesforce.
- On the Salesforce authorization screen, enter your username and password and click Log In.
You are now logged in with the Salesforce connector.
- Open the Select data drop-down and select List records.
- Open the Salesforce object drop-down and select Contact.
- (Optional) Use the Preview & Select columns feature to choose the columns you need, edit their names, and configure a sort order.
- Click Preview & Select columns.
A new window opens. - Make the changes you want.
- Click Save changes.
- Click Preview & Select columns.
- Click Run to start your request.
info If you are running a request for the first time, the Permission needed pop-up window opens.
done That’s it! You have imported your contacts from Salesforce into your Google spreadsheet. You are now ready to use YAMM to email your contact list!