-
XL-Connector
-
- Dynamically Adjust UI Elements for XL-Connector Users via Customer Portal
- Mass-managing Salesforce Fields
- Mass-managing Field-Level Security Settings
- Accounting Seed Financial Cube Formula (ASFC)
- Converting Leads
- Automating Your Salesforce Data Loads with XL-Connector Flows
- Loading Custom Metadata
- Exporting and Importing Flows and Flow Steps from/to Salesforce
- Using Custom Formulas to Dynamically Pull Data From Salesforce
- Edit Report Filters
- Run Any Data Load Scenario with a Single Click
- Bring Picklist Values to your Salesforce Report
- Scheduling Automated Data Refreshes in XL-Connector
- Upload Multiple Related Records in One Shot
- Getting rid of duplicate Accounts, Contacts, and Leads in your Salesforce org
- Generating VisualForce pages from Page Layouts
- Determining Field Utilization
- Figuring Out Field Utilization Across Layouts
- VBA Interface
- Uploading Files to Salesforce
- Validating Dependent Picklists
- Show Remaining Articles ( 6 ) Collapse Articles
-
- Mass Import/Export of images stored in Rich Text Area fields in Salesforce
- Filling Gaps in your Data
- Using Record Names Instead of Ids in ID and Lookup Fields
- Mass-downloading Documents from Salesforce.com
- Mass-uploading Attachments to Salesforce.com
- Bulk Deleting Records from Salesforce.com
- Figuring Out the Upsert Operation
- Updating Existing Records in Salesforce
- Creating New Records in Salesforce
- Pulling Data From Multiple Related Objects
- Importing Data from Salesforce.com using SOQL
- Importing Data from Salesforce.com reports
- Logging in to Salesforce.com
- Deploying XL-Connector via MSI Package
- Installing XL-Connector On Your Own
-
- What is the difference between XL-Connector and XL-Connector 365?
- My reports stopped working after enabling MFA
- My reports stopped working after enabling MFA
- How do I add users to my XL-Connector subscription?
- How do I update fields with Null values?
- I'm getting a 'Failed to Create Browser' error when trying to use Web and SSO Login
- How do I transfer my existing XL-Connector license to a new user?
- What is the maximum amount of records I can work with?
- I'm having proxy issues
- What if my data is filtered in the spreadsheet?
- What Do I need to select when inserting/updating/deleting records?
- Where do I find Security Token?
- My Get Data (or Update/Insert/Upsert) Dialog Box Is Visible in Windows Toolbar, but I Can't Bring It Forward
- I downgraded/reinstalled Microsoft Office and XL-Connector stopped working
- My Automatic Schedule(s) Stop Frequently
- Why do I need to provide my permission to send email on my behalf?
- I can only see the the Help item on the addon menu
- I used to have the XL-Connector tab in my Excel ribbon, but now it's gone
- Show Remaining Articles ( 3 ) Collapse Articles
-
- Articles coming soon
-
-
XL-Connector 365
- Slack Integration
- Mass Merge Accounts, Contacts, and Leads
- Mass Converting Leads in Salesforce
- Logging in to Salesforce
- Owner Change Settings
- Mapping Fields to Constant Values
- Using Record Names Instead of Ids in ID and Lookup Fields
- Convenient Editing of all Salesforce Field Types
- Using Upsert to Update or Create Records in Salesforce
- Updating Existing Records in Salesforce
- Creating New Records in Salesforce
- Integration with Accounting Seed
- Installing XL-Connector 365 for users in your Office 365 account (for Admins)
- XL-Connector 365 Privacy Policy
- Refreshing your Spreadsheets Automatically Offline
- Refreshing Data Pulled from Salesforce
- Importing Data from Salesforce.com Reports
- Importing Data from Salesforce.com using SOQL (Salesforce Object Query Language)
- Installing XL-Connector 365
- Pulling Data From Multiple Related Objects
- Show Remaining Articles ( 5 ) Collapse Articles
-
Excel Merge
- Configuring a button to download object-specific XL-Connector templates on Salesforce Lightning
- Configuring a button to download object-specific XL-Connector templates on Salesforce Classic
- Configuring Mail Merge component on a Lightning page
- Configuring Mail Merge component on a Classic page layout
- Configuring the Mail Merge
- Uploading an XL-Connector template to Salesforce
- Creating an XL-Connector template for upload
- Installing XL-Connector Managed Package
- Placing XL-Connector Lightning component on any Lightning page
- Adding XL-Connector component to Salesforce Classic page layouts
- Excel Merge Managed Package
-
G-Connector
-
- Slack Integration
- Scheduling Automatic Notifications in G-Connector for Salesforce
- Using Record Names Instead of Ids in ID and Lookup Fields
- Scheduling Automatic Data Snapshots in G-Connector for Salesforce
- Integration with AccountingSeed
- Utilizing Web Hooks to trigger automatic jobs
- Using Custom Formulas to Dynamically Pull Data From Salesforce
- Deleting Records from Salesforce using G-Connector
- Upserting Records in Salesforce from Google Sheets
- Updating Existing Records in Salesforce from Google Sheets
- Creating New Records in Salesforce Using G-Connector
- Scheduling Automatic Data Operations
-
- Articles coming soon
-
G-Connector for Zoho CRM
- Scheduling Automatic Data Snapshots in G-Connector for Zoho CRM
- Scheduling Automatic Data Alerts in G-Connector for Zoho CRM
- Scheduling Automatic Notifications in G-Connector for Zoho CRM
- Scheduling Automatic Data Pushes to Zoho CRM
- Setting Up Push Templates in G-Connector for Zoho CRM
- Updating Existing Records in Zoho CRM from Google Sheets
- Creating New Records in Zoho CRM Using G-Connector
- Deleting Records from Zoho CRM using G-Connector
- Scheduling Automatic Data Refresh from Zoho CRM
- Manually Refreshing your Zoho CRM Data
- Retrieving Module Data from Zoho CRM
- Logging in to Zoho CRM
- G-Connector for Zoho CRM terms of service
-
Looker Studio Connector
-
Customer Portal
- Dynamically Adjust UI Elements for XL-Connector Users via Customer Portal
- Dynamically Adjust UI Elements for G-Connector Users via Customer Portal
- Delegate your subscription user management to a co-worker
- How do I add users to my XL-Connector subscription?
- Customer Portal
- How do I add users to my G-Connector subscription?
- How do I transfer my G-Connector license to a different user?
- How do I transfer my existing XL-Connector license to a new user?
-
Legal
-
Videos
- Easy Mass Downloading and Uploading of Images Stored in Rich Text Area Fields in Salesforce
- Mass-converting Leads to a specific Contact Record Type
- Short How To Videos
- Filling Gaps in your Data
- Looking up Salesforce Ids based on an arbitrary field
- Updating Existing Records in Salesforce
- Creating New Records in Salesforce
- XL-Connector Personal Edition Video
- Refreshing Multiple Tables in XL-Connector Video
- Importing Data Using SOQL in XL-Connector Video
- Logging In XL-Connector Video
- Installing XL-Connector video
-
Blog
- Mass update Salesforce records - your ultimate guide
- Match Salesforce relationship fields to records with any text fields
- How to export a Salesforce report to Excel
- Enabling Multi-factor Authentication for a Salesforce User
- Edit Report Filters
- Run Any Data Load Scenario with a Single Click
- Bring Picklist Values to your Salesforce Report
-
Links
Updating Existing Records in Salesforce from Google Sheets
To update records in Salesforce in bulk, you will first need to pull them to your Google spreadsheet. You can do it via either SOQL or Reports.
In our example here we’ll use G-Connector to update the stage of all opportunities under one specific account. We’ll use the following query to pull the data:
SELECT Id, Name, StageName FROM Opportunity
Please note that we’re pulling record IDs. Even though a column of record IDs is required to be able to update records via Salesforce.com API, G-Connector has a built in feature to convert unique record names into Ids. Please see the following article on details about that: Using Record Names Instead of Ids in ID and Lookup Fields
We got the following results back from our sample database:
Now we want to change the stage of all four Opportunities to Closed Won. After the stage has been changed we’ll select the rows of data so that the selection spans across all the records that we want to update (it doesn’t matter if the selection spans across one or multiple columns):
Then we’ll click Add-ons -> G-Connector for Salesforce-> Update/Insert/Upsert. The system already knows what object the data was pulled from, that is why the Opportunity object will be already selected. The Update operation is the default one, so you won’t need to change that too:
G-Connector will try to automatically map your spreadsheet columns to the corresponding fields in Salesforce, and because we pulled data using SOQL – in this case it will map all columns correctly. However, please verify the mappings each time before proceeding with an update and re-map if necessary. Incorrect mappings may lead to unrecoverable data loss!
The top table in the mapping dialog lists all available fields from the selected object. You can map your spreadsheet columns to fields in Salesforce by dragging fields from the top table and dropping them on the column names in the bottom table.
Click on Save Template to save the current mappings and other settings in this dialog box as a template for future re-use.
After you’ve verified your mappings and re-mapped if necessary, you you need to do is click Push Selected Rows, and all the Opportunity records will get updated.
After the Update operation has been completed, you’ll see the operation results on the very right from your data, one column over after the last data column: